Dapper Example

dapper.cs

// Connection and transaction passed in from factory
IEnumerable object GetData(connection, transaction) {

string sql = "SELECT * FROM Person WHERE FirstName = @FirstName And LastName = @LastName 
And Company = @Company And Title = @Tile And Email = @Email";

var parameter = new DynamicParameters();  
parameter.Add("@Id",con.Id,dbType: DbType.Int32,direction:ParameterDirection.InputOutput);  
parameter.Add("@FirstName", con.FirstName);  
parameter.Add("@LastName", con.LastName);  
parameter.Add("@Company", con.Company);  
parameter.Add("@Title", con.Title);  
parameter.Add("@Email", con.Email);

var products = connection.Query<Product>(sql).ToList();
}