A high-performance Micro-ORM supporting SQL Server database. This is the extension of the dapper version for easy to configure and use.
NuGet library: https://www.nuget.org/packages/MicroORM.SQL
NuGet\Install-Package MicroORM.SQL
Query
QueryAsync
QueryFirst
QueryFirstAsync
QuerySingle
QuerySingleAsync
QueryFirstOrDefault
QueryFirstOrDefaultAsync
QuerySingleOrDefault
QuerySingleOrDefaultAsync
QueryMultiple
QueryMultipleAsync
Execute
ExecuteAsync
ExecuteReader
ExecuteReaderAsync
ExecuteScalar
ExecuteScalarAsync
You can configure this package in two ways. I will explain both two ways. you can use your suitable one.
You have to create a new class like ApplicationDbContext inherited from the DatabaseContext class that comes from this library. you have to add using MicroORM.SQL; namespace.
public class ApplicationDbContext:DatabaseContext
{
public ApplicationDbContext():base("DatabaseConnectionString")
{
}
}
Controller code sample.
[ApiController]
[Route("[controller]/[action]")]
public class TestController : ControllerBase
{
[HttpGet]
public IActionResult GetAll()
{
ApplicationDbContext dbContext = new ApplicationDbContext();
var data= dbContext.Query<ReturnType>("Query").ToList();
return Ok(data);
}
}
If you use dependency injection then this option is for you.
using MicroORM.SQL;
builder.Services.AddDatabaseContext(options =>
{
options.ConnectionString = "DatabaseConnectionString"
});
Controller code sample.
[ApiController]
[Route("[controller]/[action]")]
public class TestController : ControllerBase
{
ApplicationDbContext _dbContext;
public TestController(ApplicationDbContext dbContext)
{
_dbContext=dbContext;
}
[HttpGet]
public IActionResult GetAll()
{
var data= _dbContext.Query<ReturnType>("Query").ToList();
return Ok(data);
}
}