异步执行的代码(两种)
第一种:
public async void DoSomething(string sql, SqlConnection conn )
{
var doSomething = new Action(() => {
SqlCommand cmd1 = new SqlCommand(sql, conn);
cmd1.ExecuteNonQuery();
});
await Task.Run(doSomething);
}
第二种:
public async void DoSomething(string sql, SqlConnection conn )
{
SqlCommand cmd1 = new SqlCommand(sql, conn);
//BeginExecuteNonQuery接受所有输入参数
IAsyncResult p = cmd1.BeginExecuteNonQuery();
//判断异步是否完成
if (p.IsCompleted == true)
//{
// Console.WriteLine("Data is inserted completely...\nTotal coast {0}s", time * 0.001);
//EndExecuteNonQuery()提供所有输出参数以及返回值
// cmd.EndExecuteNonQuery(p);//结束异步操作
// cmd.Dispose();
}