A simple object mapping library. It uses ADO.NET at backend. The performance is on par with (if it is not faster) Entity Framework Core.
Oracle: https://www.nuget.org/packages/MagicEastern.ADOExt.Oracle/
Sql Server: https://www.nuget.org/packages/MagicEastern.ADOExt.SqlServer/
Put DBColumn attribute to the Properties of the class that you wish to map from database. Optionally, if you need to insert, update, delete, and load record from a table, put DBTable attribute to the class.
[DBTable("Department")]
public class DeptInfo
{
[DBColumn] public string DEPT_ID { get; set; }
[DBColumn] public string DESCRIPTION { get; set; }
}Register your database services.
/*
* Register the DB Services. Thus, you can access DBServiceManager object
* through dependency injection cross the application.
* AddDatabase() can be called multiple times to add multiple databases.
*/
serviceCollection.AddDBServiceManger()
.AddDatabase("mydb", () => new SqlConnection(SqlConnString));Request DBServiceManager object from dependency injection, like the example below.
public SomeController(DBServiceManager dbManager)Use the database.
using (var conn = dbManager.OpenConnection())
{
_ = conn.Query<DeptInfo>("select * from Department");
using (var trans = conn.BeginTransaction())
{
trans.Insert(new DeptInfo
{
DEPT_ID = "IT",
IODescriptionAttribute = "IT"
});
/*
* If missing this line below, the transaction will be
* rolled back by default.
*/
trans.Commit();
}
}
/*
* You may create transaction directly from DBServiceManager.
* Using optional indexer on DBServiceManger object to
* specify the database you want to use instead of the default one.
* The default database will be the 1st database when you
* calling AddDatabase() during registering services.
*/
using (var trans = dbManager["mydb"].BeginTransaction())
{
// do your stuff...
trans.Commit();
}Query<T>()
Execute()
GetSingleValue<T>
GetFirstColumn<T>
Load<T>
Insert<T>
Update<T>
Delete<T>
See example in projects "Test"(SqlServer), "TestOracle"(Oracle).