ShadyNagy.DapperManager

Dapper ORM

A NuGet library that will extend your IDbConnection interface with awesome extensions!

Load Services

services.AddMicrosoftSqlServices(DatabaseConstants.CONNECTION_STRING);
services.AddOracleSqlServices(DatabaseConstants.CONNECTION_STRING);

Dapper Usage is

string sql = "INSERT INTO Customers (CustomerName) Values (@CustomerName);";

using (var connection =  My.ConnectionFactory())
{
      var affectedRows = connection.Execute(sql, new {CustomerName = "Mark"});
   
      var customers = connection.Query<Customer>("Select * FROM CUSTOMERS).ToList();  
}

Package ShadyNagy.DapperManager Usage is

var customers = await oracleDapperService.GetFromAsync<Customer>("EMPLOYEES");

• More information on the tests ShadyNagy.DapperManager.Tests

Dapper tests

There are not any tools to test the dapper so this package ShadyNagy.DapperInMemory will help you to create tests for Dapper without database

var connection = new InMemoryConnection(DatabaseConstants.CONNECTION_STRING);
connection.Open();

var sql = @"SELECT * FROM EMPLOYEES;";
var employees =  (await connection.QueryAsync<Employee>(sql, commandType: CommandType.Text)).ToList();

Insert

var tableName = "EMPLOYEES";
var employee = new Employee()
{
    Id = 1,
    Name = "Shady"
};

var affectedRows = await oracleDapperService.InsertAsync<Employee>(tableName, employee);

• More information on the tests ShadyNagy.DapperInMemory.Tests