/// <summary>
/// Updates a record in the database.
/// </summary>
/// <param name="connection">Database connection.</param>
/// <param name="entityToUpdate">The entity you wish to update.</param>
/// <param name="statementOptions">Optional statement options (usage: statement => statement.SetTimeout().AttachToTransaction()...)</param>
/// <returns>True if the item was updated.</returns>
public static bool Update <TEntity>(
this IDbConnection connection,
TEntity entityToUpdate,
Action <IStandardSqlStatementOptionsBuilder <TEntity> > statementOptions = null)
{
var options = new StandardSqlStatementOptionsBuilder <TEntity>();
statementOptions?.Invoke(options);
return(options.SqlStatementsFactoryChain().UpdateById(connection, entityToUpdate, options));
}
/// <summary>
/// Inserts a row into the database.
/// </summary>
/// <param name="connection"></param>
/// <param name="entityToInsert"></param>
/// <param name="statementOptions">Optional statement options (usage: statement => statement.SetTimeout().AttachToTransaction()...)</param>
public static Task InsertAsync <TEntity>(
this IDbConnection connection,
TEntity entityToInsert,
Action <IStandardSqlStatementOptionsBuilder <TEntity> > statementOptions = null)
{
var options = new StandardSqlStatementOptionsBuilder <TEntity>();
statementOptions?.Invoke(options);
return(options.SqlStatementsFactoryChain().InsertAsync(connection, entityToInsert, options));
}
/// <summary>
/// Deletes an entity by its primary keys.
/// </summary>
/// <typeparam name="TEntity">Entity Type</typeparam>
/// <param name="connection">Database connection.</param>
/// <param name="entityToDelete">The entity you wish to remove.</param>
/// <param name="statementOptions">Optional statement options (usage: statement => statement.SetTimeout().AttachToTransaction()...)</param>
/// <returns>True if the entity was found and successfully deleted.</returns>
public static Task <bool> DeleteAsync <TEntity>(
this IDbConnection connection,
TEntity entityToDelete,
Action <IStandardSqlStatementOptionsBuilder <TEntity> > statementOptions = null)
{
var options = new StandardSqlStatementOptionsBuilder <TEntity>();
statementOptions?.Invoke(options);
return(options.SqlStatementsFactoryChain().DeleteByIdAsync(connection, entityToDelete, options));
}
/// <summary>
/// Updates a record in the database.
/// </summary>
/// <param name="connection">Database connection.</param>
/// <param name="entityToUpdate">The entity you wish to update.</param>
/// <param name="statementOptions">Optional statement options (usage: statement => statement.SetTimeout().AttachToTransaction()...)</param>
/// <returns>True if the item was updated.</returns>
public static bool Update <TEntity>(
this IDbConnection connection,
TEntity entityToUpdate,
Action <IStandardSqlStatementOptionsBuilder <TEntity> > statementOptions = null)
{
var options = new StandardSqlStatementOptionsBuilder <TEntity>();
statementOptions?.Invoke(options);
return(OrmConfiguration.GetSqlStatements <TEntity>(options.EntityMappingOverride)
.UpdateById(connection, entityToUpdate, options));
}
/// <summary>
/// Inserts a row into the database.
/// </summary>
/// <param name="connection"></param>
/// <param name="entityToInsert"></param>
/// <param name="statementOptions">Optional statement options (usage: statement => statement.SetTimeout().AttachToTransaction()...)</param>
public static Task InsertAsync <TEntity>(
this IDbConnection connection,
TEntity entityToInsert,
Action <IStandardSqlStatementOptionsBuilder <TEntity> > statementOptions = null)
{
var options = new StandardSqlStatementOptionsBuilder <TEntity>();
statementOptions?.Invoke(options);
return(OrmConfiguration.GetSqlStatements <TEntity>(options.EntityMappingOverride)
.InsertAsync(connection, entityToInsert, options));
}
