This repository has been archived by the owner on Feb 13, 2019. It is now read-only.
SQL Server CRUD Methods
Adam O'Neil edited this page Jan 11, 2019
·
7 revisions
Use the namespace Postulate.Lite.Core.SqlServer.IntKey, Postulate.Lite.Core.SqlServer.LongKey, or Postulate.Lite.Core.SqlServer.GuidKey to get these IDbConnection extension methods.
- void CreateTable (this IDbConnection connection, string tableName)
- void Delete (this IDbConnection connection, int id, IUser user, string tableName)
- Task DeleteAsync (this IDbConnection connection, int id, IUser user, string tableName)
- bool Exists (this IDbConnection connection, int id, IUser user, string tableName)
- Task<bool> ExistsAsync (this IDbConnection connection, int id, IUser user, string tableName)
- bool ExistsWhere<TModel> (this IDbConnection connection, TModel criteria, IUser user, string tableName)
- Task<bool> ExistsWhereAsync<TModel> (this IDbConnection connection, TModel criteria, IUser user, string tableName)
- TModel Find (this IDbConnection connection, int id, IUser user, string tableName)
- Task<TModel> FindAsync (this IDbConnection connection, int id, IUser user, string tableName)
- TModel FindWhere<TModel> (this IDbConnection connection, TModel criteria, IUser user, string tableName)
- Task<TModel> FindWhereAsync (this IDbConnection connection, object criteria, IUser user, string tableName)
- int Insert<TModel> (this IDbConnection connection, TModel object, IUser user, string tableName)
- Task<int> InsertAsync<TModel> (this IDbConnection connection, TModel object, IUser user, string tableName)
- int Merge<TModel> (this IDbConnection connection, TModel object, IUser user, string tableName)
- Task<int> MergeAsync<TModel> (this IDbConnection connection, TModel object, IUser user, string tableName)
- void PlainInsert<TModel> (this IDbConnection connection, TModel object, IUser user, string tableName)
- Task PlainInsertAsync<TModel> (this IDbConnection connection, TModel object, IUser user, string tableName)
- int Save<TModel> (this IDbConnection connection, TModel object, IUser user, string tableName)
- Task<int> SaveAsync<TModel> (this IDbConnection connection, TModel object, IUser user, string tableName)
- void Update<TModel> (this IDbConnection connection, TModel object, IUser user, string tableName)
- void Update<TModel> (this IDbConnection connection, TModel object, IUser user, params Expression<Func<TModel, object>>[] setColumns)
- Task UpdateAsync<TModel> (this IDbConnection connection, TModel object, IUser user, string tableName)
- Task UpdateAsync<TModel> (this IDbConnection connection, TModel object, IUser user, params Expression<Func<TModel, object>>[] setColumns)
Content generated by RoslynSyntaxTreeAnalyzer