A simple, fast, fluently structured library that takes the pain out of writing ADO.NET by eliminating boiler plate code and providing SQL result mappings to strongly-typed objects with no attributing or baseclass/interface, just pure POCOs and fast!
####Usage
var command = CommandManager.Instance
.DefineCommand(@"SELECT Id, FirstName, LastName
FROM Customers
WHERE HasStoreCard = @HasStoreCard", CommandType.Text)
.DefineResults<Customer>()
.Realize();
using (var databaseManager =
new DatabaseManager("DepartmentStoreConnectionString"))
{
IEnumerable<Customer> customers =
command.Execute(databaseManager, new { HasStoreCard = true });
}
Currently Structured parameters are not supported on Mono do to limitation with SqlDataRecord missing on Mono.
####Documentation Docs are available here.
####Project Updates Susanoo's Blog is here
####How does it work? Susanoo uses Linq expression trees to dynamically write and compile code to map your objects before the command ever executes, leaving your SQL calls unaffected. It does this all while avoiding slow reflection code and nasty reflection.emit IL.
####Installation Susanoo does not require any configuration out of the box. The easiest way to install is of course via nuget package.
PM> Install-Package Susanoo.Core
#####Debugging Susanoo
Debugging symbols are hosted at SymbolSource. A guide on adding the symbol server to Visual Studio is available here.
Susanoo is licensed under MIT. Refer to license.txt for more information.