异步操作mysql数据库_多线程编程学习笔记——异步操作数据库

detachCommand.Parameters.AddWithValue("@dbname", dbName);awaitdetachCommand.ExecuteNonQueryAsync();

Console.WriteLine("分离数据库 成功！！");

Console.WriteLine("删除数据库文件.....");if(File.Exists(dbLogFileName))

File.Delete(dbLogFileName);

File.Delete(dbFileName);

Console.WriteLine("删除数据库文件成功！！");

}

Console.WriteLine("创建数据库文.......");string createCommand = String.Format("Create Database {0} on

(Name=N'{0}',FILENAME='{1}')", dbName, dbFileName);var cmd = newSqlCommand(createCommand, connection);awaitcmd.ExecuteNonQueryAsync();

Console.WriteLine("创建数据库成功！！");

}using (var connection = newSqlConnection(dbConnectionString))

{awaitconnection.OpenAsync();var cmd = new SqlCommand("select newid()", connection);var result = awaitcmd.ExecuteScalarAsync();

Console.WriteLine("New GUID from database :{0}", result);

cmd= new SqlCommand(@"Create Table [dbo].[CustomTable](

[ID] [int] IDENTITY(1,1) NOT NULL,[Name] [nvarchar](50) NOT NULL,

CONSTRAINT [PK_ID] PRIMARY KEY CLUSTERED([ID] ASC) ON [PRIMARY]) ON [PRIMARY]", connection);awaitcmd.ExecuteNonQueryAsync();

Console.WriteLine("创建表CustomTable成功！");

cmd= new SqlCommand(@"INSERT INTO [dbo].[CustomTable](Name) values('John') ;

INSERT INTO [dbo].[CustomTable](Name) values('张三') ;

INSERT INTO [dbo].[CustomTable](Name) values('李四') ;

INSERT INTO [dbo].[CustomTable](Name) values('王五') ;", connection);awaitcmd.ExecuteNonQueryAsync();

Console.WriteLine("表CustomTable数据插入成功！");

Console.WriteLine("查询表CustomTable数据。。。。");

cmd= new SqlCommand(@"select * from [dbo].[CustomTable]", connection);using (SqlDataReader dr = awaitcmd.ExecuteReaderAsync())

{while (awaitdr.ReadAsync())

{var id = dr.GetFieldValue(0);var name = dr.GetFieldValue(1);

Console.WriteLine("表CustomTable数据 : Id {0} ,Name {1}", id, name);

}

}

}

}catch(Exception ex)

{

Console.WriteLine("错误信息 : {0}",ex.Message);

}

}

}

}