本文整理汇总了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);
}
}