Dapper - Parameter Anonymous

Description

Dapper make it simple & safe (SQL Injection) to use parameter by supporting anonymous type.

Single

Execute a single time a SQL Command.

string sql = "INSERT INTO Customers (CustomerName) Values (@CustomerName);";
using (var connection = new SqlCeConnection("Data Source=SqlCe_W3Schools.sdf"))
{
var affectedRows = connection.Execute(sql, new );
Console.WriteLine(affectedRows);

// Only for see the Insert.
var customer = connection.Query<Customer>("Select * FROM CUSTOMERS WHERE CustomerName = 'Mark'").ToList();

FiddleHelper.WriteTable(customer);

}

Try it online

Many

Execute many times a SQL Command

string sql = "INSERT INTO Customers (CustomerName) Values (@CustomerName);";
using (var connection = new SqlCeConnection("Data Source=SqlCe_W3Schools.sdf"))
{			
var affectedRows = connection.Execute(sql,
new[]
{
new ,
new ,
new 
}
Console.WriteLine(affectedRows);

)

Try it online