Dapper官方教程翻译2：Dapper方法之Execute

Execute方法描述：

Execute是Dapper对数据库操作的一个扩展，可以由IDbConnection对象调用。它可以执行一条命令一或多次，返回类型是受影响的行数。这个方法通常用于执行：

• Stored Procedure （存储过程）
• INSERT statement （插入语句）
• UPDATE statement （更新语句）
• DELETE statement （删除语句）

该方法可传递的参数：

示例：执行存储过程

执行一次存储过程：

string sql = \"Invoice_Insert\";

using (var connection = My.ConnectionFactory())
{
    var affectedRows = connection.Execute(sql,
        new {Kind = InvoiceKind.WebInvoice, Code = \"Single_Insert_1\"},
        commandType: CommandType.StoredProcedure);

    My.Result.Show(affectedRows);
}

执行多次存储过程：

string sql = \"Invoice_Insert\";

using (var connection = My.ConnectionFactory())
{
    var affectedRows = connection.Execute(sql,
        new[]
        {
            new {Kind = InvoiceKind.WebInvoice, Code = \"Many_Insert_1\"},
            new {Kind = InvoiceKind.WebInvoice, Code = \"Many_Insert_2\"},
            new {Kind = InvoiceKind.StoreInvoice, Code = \"Many_Insert_3\"}
        },
        commandType: CommandType.StoredProcedure
    );

    My.Result.Show(affectedRows);
}

示例：Execute执行插入语句

执行单条插入：

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

using (var connection = new SqlCeConnection(\"Data Source=SqlCe_W3Schools.sdf\"))
{
	var affectedRows = connection.Execute(sql, new {CustomerName = \"Mark\"});

	Console.WriteLine(affectedRows);

	var customer = connection.Query<Customer>(\"Select * FROM CUSTOMERS WHERE CustomerName = \'Mark\'\").ToList();

	FiddleHelper.WriteTable(customer);
}

执行多条插入：

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

using (var connection = new SqlCeConnection(\"Data Source=SqlCe_W3Schools.sdf\"))
{
	connection.Open();

	var affectedRows = connection.Execute(sql,
	new[]
	{
	new {CustomerName = \"John\"},
	new {CustomerName = \"Andy\"},
	new {CustomerName = \"Allan\"}
	}
);

Console.WriteLine(affectedRows);

示例：Execute执行更新语句

执行单条更新：

string sql = \"UPDATE Categories SET De ion = @De ion WHERE CategoryID = @CategoryID;\";

using (var connection = new SqlCeConnection(\"Data Source=SqlCe_W3Schools.sdf\"))
{			
	var affectedRows = connection.Execute(sql,new {CategoryID = 1, De ion = \"Soft drinks, coffees, teas, beers, mixed drinks, and ales\"});

	Console.WriteLine(affectedRows);
}

执行多条更新：

string sql = \"UPDATE Categories SET De ion = @De ion WHERE CategoryID = @CategoryID;\";

using (var connection = new SqlCeConnection(\"Data Source=SqlCe_W3Schools.sdf\"))
{	
	var affectedRows = connection.Execute(sql,
	new[]
	{
	new {CategoryID = 1, De ion = \"Soft drinks, coffees, teas, beers, mixed drinks, and ales\"},
	new {CategoryID = 4, De ion = \"Cheeses and butters etc.\"}
	}
);

Console.WriteLine(affectedRows);

示例：Execute执行删除操作

执行单条删除：

string sql = \"DELETE FROM Customers WHERE CustomerID = @CustomerID\";

using (var connection = new SqlCeConnection(\"Data Source=SqlCe_W3Schools.sdf\"))
{			
	var affectedRows = connection.Execute(sql, new {CustomerID = 1});

	Console.WriteLine(affectedRows);
}

执行多条删除：

string sql = \"DELETE FROM OrderDetails WHERE OrderDetailID = @OrderDetailID\";

using (var connection = new SqlCeConnection(\"Data Source=SqlCe_W3Schools.sdf\"))
{			
	var affectedRows = connection.Execute(sql, 
		new[]
	{
	new {OrderDetailID = 1},
	new {OrderDetailID = 2},
	new {OrderDetailID = 3}
	}
);

Console.WriteLine(affectedRows);