Crud method reference

These are the public methods of abstract class SqlCrudProvider. Platform-specific packages surface these as extension methods of IDbConnection. Use this to get a feel for what Dapper.CX can do as well as quick access to the implementation.

Crud methods

• Task DeleteAsync<TIdentity> (IDbConnection connection, TIdentity id)
• Task<bool> ExistsAsync<TIdentity> (IDbConnection connection, TIdentity id)
• Task<bool> ExistsWhereAsync (IDbConnection connection, object criteria)
• Task<TModel> GetAsync<TIdentity> (IDbConnection connection, TIdentity identity)
• string GetDeleteStatement (Type modelType)
• Task<TModel> GetWhereAsync (IDbConnection connection, object criteria)
• Task<TIdentity> InsertAsync<TModel> (IDbConnection connection, TModel model, Action<TModel, SaveAction> onSave)
• Task<TIdentity> MergeAsync<TModel> (IDbConnection connection, TModel model, IEnumerable<string> keyProperties, ChangeTracker<TModel> changeTracker, Action<TModel, SaveAction> onSave)
• Task<TIdentity> MergeAsync<TModel> (IDbConnection connection, TModel model, ChangeTracker<TModel> changeTracker, Action<TModel, SaveAction> onSave)
• Task<TIdentity> SaveAsync<TModel> (IDbConnection connection, TModel model, ChangeTracker<TModel> changeTracker, Action<TModel, SaveAction> onSave)
• Task UpdateAsync<TModel> (IDbConnection connection, TModel model, ChangeTracker<TModel> changeTracker, Action<TModel, SaveAction> onSave)

Helpers

• TIdentity GetIdentity<TModel> (TModel model)
• bool IsNew<TModel> (TModel model)

SQL Generation

• string GetInsertStatement (Type modelType)
• string GetQuerySingleStatement (Type modelType)
• string GetQuerySingleWhereStatement (Type modelType, object criteria)
• string GetQuerySingleWhereStatement (Type modelType, IEnumerable<string> propertyNames)
• string GetQuerySingleWhereStatement (Type modelType, IEnumerable<PropertyInfo> properties)
• string GetUpdateStatement<TModel> (TModel model, ChangeTracker<TModel> changeTracker)