Innobate.DAM 1.0.0

DAM

A smiple Data Access Manager for ADO.Net

• Available on nuget: https://www.nuget.org/packages/Innobate.DAM

Ever just wanted to execute a bit of SQL without jumping through the hoops imposed by other frameworks?

Then DAM is for you.

You provide DAM with the SQL to be executed.

Supported Frameworks

• .NET Core 2.1
• .NET Core 3.0
• .NET Core 3.1
• .NET 4.0
• .NET 4.5

Performance This is a pure SQL solution having no performance overheads like ORMs, Entity or other frameworks.

Learning Curve If you know SQL and how to code in .NET, just USE

Examples

• Examples can be found in the following repository:- https://github.com/innobate/DAM-Examples

Example connection to SQL Server

 var connection = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

var dbManager = new DataAccessManager("System.Data.SqlClient", connection);

var country = dbManager.Select("Select * from Country ;");

Example connection to SQLite

 var connection = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

var dbManager = new DataAccessManager("System.Data.SQLite", connection);

var country = dbManager.Select("Select * from Country ;");

Example connection to MySQL

 var connection = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

var dbManager = new DataAccessManager("MySql.Data.MySqlClient", connection);

var country = dbManager.Select("Select * from Country ;");

Example connection to SQLite

 var connection = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

var dbManager = new DataAccessManager("System.Data.SQLite", connection);

var country = dbManager.Select("Select * from Country ;");

Example connection to Oracle

 var connection = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

var dbManager = new DataAccessManager("Oracle.DataAccess.Client", connection);

var country = dbManager.Select("Select * from Country ;");

Using parameters in queries

var connection = "Server=.//;Initial Catalog=CountriesDB;integrated security=True;Connection Timeout=3000;"
var dbManager = new DataAccessManager("System.Data.SqlClient", connection);

var countries = dbManager.Select("Select * from Country where CountryId > @countryId;", new DatabaseParameter("@countryId", 100));