EasyDb (version 4.x)

EasyDb is a Library for .NET Projects.

• Micro ORM
• Mapping explicit or by Data Annotations
• Simple commands with SQL
• Factories for a better project structure
• QueryService SqlClient, OleDb, MySqlClient with with MySQLConnector for .NET
• Interceptors
• No dependencies. Do not require to update the Model.

Installation

With NuGet

PM> Install-Package EasyDb

Documentation

• Wiki

Examples

SelectAllAsync

var db = new EasyDb();
db.SetConnectionStringSettings("Data Source=(LocalDb)\MSSQLLocalDB;Initial Catalog=MyDb;Integrated Security=True", "System.Data.SqlClient");

db.DefaultMappingBehavior = DefaultMappingBehavior.CreateEmptyTable;

// arguments: limit, condition, sorts
var users = await db.SelectAllAsync<User>(10, Check.Op("Age", ">", 18), new string[] { "UserName DESC" });

InsertAsync

var db = new EasyDb();
db.SetConnectionStringSettings("Data Source=(LocalDb)\MSSQLLocalDB;Initial Catalog=MyDb;Integrated Security=True", "System.Data.SqlClient");

db.DefaultMappingBehavior = DefaultMappingBehavior.CreateEmptyTable;

var user = new User
{
    UserName = "Marie"
};
var newId = await db.InsertAsync<User>(user);

Or with command factory

public class UserInsertFactory : IInsertCommandFactory<User>
{
    public DbCommand CreateCommand(EasyDb db, User model)
    {
        return db.CreateSqlCommand("insert into [User](UserName) output inserted.id values(@username)")
                .AddInParameter("@username", model.UserName);
    }

    public void SetNewId(DbCommand command, User model, object result)
    {
        model.Id = (int)result;
    }
}

var db = new EasyDb();
db.SetConnectionStringSettings("Data Source=(LocalDb)\MSSQLLocalDB;Initial Catalog=MyDb;Integrated Security=True", "System.Data.SqlClient");

var user = new User
{
    UserName = "Marie"
};
var result = await db.InsertAsync<User>(new UserInsertFactory(), user);