A very lightweight dynamic asynchronous data access for .NET, written in C#.
The project only supports .NET 4.5 and Sql Server.
.NET 4.5 and C# 5.0 allow us to utilize asynchronous programming as a core feature of the .NET Framework, and ADO.NET takes full advantage of the standard design patterns. AsyncORM allows developers to develop asynchronous data access without dealing with the complexity.
you have two classes to work with database, StoredProcedure and DynamicQuery, which both implement IQueryAsync interface.
string connString = ConfigurationManager.ConnectionStrings["test"].ConnectionString;
IQueryAsync storedProcedure = new StoredProcedure(connString);
IEnumerable<dynamic> result =await storedProcedure.ExecuteAsync("proc_test2");
the names of properties of the object are the same with the parameters of stored procedure
string connString = ConfigurationManager.ConnectionStrings["test"].ConnectionString;
IQueryAsync storedProcedure = new StoredProcedure(connString);
IEnumerable<dynamic> result =await storedProcedure.ExecuteAsync("proc_Login", new {UserName="BillGates",Password="WinRT"});
the names of properties of the object are the same with the parameters of stored procedure
string connString = ConfigurationManager.ConnectionStrings["test"].ConnectionString;
IQueryAsync storedProcedure = new StoredProcedure(connString);
IEnumerable<dynamic> result =await storedProcedure.ExecuteAsync("proc_Login", new {UserName="BillGates",Password="WinRT"});
IEnumerable<User> users= result.Select(x=>new User{
FirstName=x.First_Name,
LastName=x.Last_Name
});