/// <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)); }