/// <summary>
/// Inserts an entity into table "T" and returns identity id asynchronously.
/// </summary>
/// <param name="connection">Open SqlConnection</param>
/// <param name="entityToInsert">Entity to insert</param>
/// <param name="queryBuilder"></param>
/// <returns>Identity of inserted entity</returns>
public static async Task <object> InsertAsync(this IDbConnection connection, BaseModel entityToInsert, QB queryBuilder)
{
using (connection)
{
connection.Open();
var cmd = queryBuilder.Insert(entityToInsert);
return(await connection.ExecuteScalarAsync(cmd, entityToInsert));
}
}
/// <summary>
/// Inserts an entity into table "T" and returns identity id.
/// </summary>
/// <param name="connection">Open SqlConnection</param>
/// <param name="entityToInsert">Entity to insert</param>
/// <param name="queryBuilder"></param>
/// <returns>Identity of inserted entity</returns>
public static object Insert(this IDbConnection connection, BaseModel entityToInsert, QB queryBuilder)
{
using (connection)
{
connection.Open();
var cmd = queryBuilder.Insert(entityToInsert);
return(connection.ExecuteScalar(cmd, entityToInsert));
}
}
