本文整理匯總了C#中MySql.Data.MySqlClient.MySqlConnection.ExecuteAsync方法的典型用法代碼示例。如果您正苦於以下問題：C# MySqlConnection.ExecuteAsync方法的具體用法？C# MySqlConnection.ExecuteAsync怎麽用？C# MySqlConnection.ExecuteAsync使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類MySql.Data.MySqlClient.MySqlConnection的用法示例。
在下文中一共展示了MySqlConnection.ExecuteAsync方法的1個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的C#代碼示例。
示例1: Create
public async Task Create(DocumentEntity request)
{
// This would create a connection, open it,
// begin a transaction and put the repositories on
// the uow.
//using (var uow = new UnitOfWork(connectionString))
//{
// var user = uow.Users.GetByUserName(userName);
//}
using (var connection = new MySqlConnection(ConfigurationManager.ConnectionStrings[Constants.ConnectionStringName].ConnectionString))
{
await connection.OpenAsync();
//var transaction = connection.BeginTransaction();
// Get the name of the logged in user from the controller.
var userName = this.User.Identity.Name;
// Get the user id of the logged in user from the database.
var user = await new UserRepository(connection).GetByUserName(userName);
var userId = user.UserId;
// Set the created by to be the current user.
request.CreatedBy = userId;
// Set the created when to be now.
request.CreatedWhen = DateTime.UtcNow;
request.Title.ToString();
// Create the new document in the database.
await connection.ExecuteAsync(@"
INSERT INTO Document
(Title, Body, CreatedWhen, CreatedBy)
VALUES
(@Title, @Body, @CreatedWhen, @CreatedBy);
", request);
}
}