//
// Summary:
// By default queries the table matching the class name
// -Table name can be overridden by adding an attribute on your class [Table("YourTableName")]
// conditions is an SQL where clause ex: "where name='bob'" or "where age>=@Age"
// - not required
// parameters is an anonymous type to pass in named parameter values: new { Age
// = 15 }
// Supports transaction and command timeout
// ///
//
// Parameters:
// connection:
//
// conditions:
//
// parameters:
//
// transaction:
//
// commandTimeout:
//
// Type parameters:
// T:
//
// Returns:
// Returns a count of records.
public Task <int> RecordCountAsync(string conditions = "", object parameters = null, IDbTransaction transaction = null, int?commandTimeout = null)
{
return(MethodHelper.CatchFunction(Connection.RecordCountAsync <T>, conditions, parameters, transaction, commandTimeout));
}
//
// Summary:
// By default queries the table matching the class name
// -Table name can be overridden by adding an attribute on your class [Table("YourTableName")]
// Returns a number of records entity by a single id from table T
// Supports transaction and command timeout
// whereConditions is an anonymous type to filter the results ex: new {Category
// = 1, SubCategory=2}
//
// Parameters:
// connection:
//
// whereConditions:
//
// transaction:
//
// commandTimeout:
//
// Type parameters:
// T:
//
// Returns:
// Returns a count of records.
public Task <int> RecordCountAsync(object whereConditions, IDbTransaction transaction = null, int?commandTimeout = null)
{
return(MethodHelper.CatchFunction(Connection.RecordCountAsync <T>, whereConditions, transaction, commandTimeout));
}
//
// Summary:
// Inserts a row into the database, using ONLY the properties defined by T
// By default inserts into the table matching the class name
// -Table name can be overridden by adding an attribute on your class [Table("YourTableName")]
// Insert filters out Id column and any columns with the [Key] attribute
// Properties marked with attribute [Editable(false)] and complex types are ignored
// Supports transaction and command timeout
// Returns the ID (primary key) of the newly inserted record if it is identity using
// the defined type, otherwise null
//
// Parameters:
// connection:
//
// entityToInsert:
//
// transaction:
//
// commandTimeout:
//
// Returns:
// The ID (primary key) of the newly inserted record if it is identity using the
// defined type, otherwise null
public TKey Insert <TKey>(T entityToInsert, IDbTransaction transaction = null, int?commandTimeout = null)
{
return(MethodHelper.CatchFunction(Connection.Insert <TKey, T>, entityToInsert, transaction, commandTimeout));
}
//
// Summary:
// Inserts a row into the database asynchronously
// By default inserts into the table matching the class name
// -Table name can be overridden by adding an attribute on your class [Table("YourTableName")]
// Insert filters out Id column and any columns with the [Key] attribute
// Properties marked with attribute [Editable(false)] and complex types are ignored
// Supports transaction and command timeout
// Returns the ID (primary key) of the newly inserted record if it is identity using
// the int? type, otherwise null
//
// Parameters:
// connection:
//
// entityToInsert:
//
// transaction:
//
// commandTimeout:
//
// Returns:
// The ID (primary key) of the newly inserted record if it is identity using the
// int? type, otherwise null
public Task <int?> InsertAsync(T entityToInsert, IDbTransaction transaction = null, int?commandTimeout = null)
{
return(MethodHelper.CatchFunction(Connection.InsertAsync, entityToInsert, transaction, commandTimeout));
}
//
// Summary:
// Execute parameterized SQL.
//
// Parameters:
// cnn:
// The connection to query on.
//
// sql:
// The SQL to execute for this query.
//
// param:
// The parameters to use for this query.
//
// transaction:
// The transaction to use for this query.
//
// commandTimeout:
// Number of seconds before command execution timeout.
//
// commandType:
// Is it a stored proc or a batch?
//
// Returns:
// The number of rows affected.
public int Execute(string sql, object param = null, IDbTransaction transaction = null, int?commandTimeout = null, CommandType?commandType = null)
{
return(MethodHelper.CatchFunction(Connection.Execute, sql, param, transaction, commandTimeout, commandType));
}
//
// Summary:
// Deletes a list of records in the database
// By default deletes records in the table matching the class name
// -Table name can be overridden by adding an attribute on your class [Table("YourTableName")]
// Deletes records where that match the where clause
// whereConditions is an anonymous type to filter the results ex: new {Category
// = 1, SubCategory=2}
// The number of records affected
// Supports transaction and command timeout
//
// Parameters:
// connection:
//
// whereConditions:
//
// transaction:
//
// commandTimeout:
//
// Type parameters:
// T:
//
// Returns:
// The number of records affected
public int DeleteList <T>(object whereConditions, IDbTransaction transaction = null, int?commandTimeout = null)
{
return(MethodHelper.CatchFunction(Connection.DeleteList <T>, whereConditions, transaction, commandTimeout));
}
//
// Summary:
// By default queries the table matching the class name
// -Table name can be overridden by adding an attribute on your class [Table("YourTableName")]
// conditions is an SQL where clause and/or order by clause ex: "where name='bob'"
// or "where age>=@Age"
// parameters is an anonymous type to pass in named parameter values: new { Age
// = 15 }
// Supports transaction and command timeout
// Returns a list of entities that match where conditions
//
// Parameters:
// connection:
//
// conditions:
//
// parameters:
//
// transaction:
//
// commandTimeout:
//
// Type parameters:
// T:
//
// Returns:
// Gets a list of entities with optional SQL where conditions
public Task <IEnumerable <T> > GetListAsync(string conditions, object parameters = null, IDbTransaction transaction = null, int?commandTimeout = null)
{
return(MethodHelper.CatchFunction(Connection.GetListAsync <T>, conditions, parameters, transaction, commandTimeout));
}
//
// Summary:
// Updates a record or records in the database asynchronously
// By default updates records in the table matching the class name
// -Table name can be overridden by adding an attribute on your class [Table("YourTableName")]
// Updates records where the Id property and properties with the [Key] attribute
// match those in the database.
// Properties marked with attribute [Editable(false)] and complex types are ignored
// Supports transaction and command timeout
// Returns number of rows affected
//
// Parameters:
// connection:
//
// entityToUpdate:
//
// transaction:
//
// commandTimeout:
//
// Returns:
// The number of affected records
public async Task <int> UpdateAsync(T entityToUpdate, IDbTransaction transaction = null, int?commandTimeout = null, CancellationToken?token = null)
{
return(await MethodHelper.CatchFunction(Connection.UpdateAsync, entityToUpdate, transaction, commandTimeout, token));
}
//
// Summary:
// By default queries the table matching the class name
// -Table name can be overridden by adding an attribute on your class [Table("YourTableName")]
// whereConditions is an anonymous type to filter the results ex: new {Category
// = 1, SubCategory=2}
// Supports transaction and command timeout
// Returns a list of entities that match where conditions
//
// Parameters:
// connection:
//
// whereConditions:
//
// transaction:
//
// commandTimeout:
//
// Type parameters:
// T:
//
// Returns:
// Gets a list of entities with optional exact match where conditions
public IList <T> GetList(object whereConditions, IDbTransaction transaction = null, int?commandTimeout = null)
{
return(MethodHelper.CatchFunction(Connection.GetList <T>, whereConditions, transaction, commandTimeout).ToList());
}
//
// Summary:
// By default queries the table matching the class name asynchronously
// -Table name can be overridden by adding an attribute on your class [Table("YourTableName")]
// Returns a list of all entities
//
// Parameters:
// connection:
//
// Type parameters:
// T:
//
// Returns:
// Gets a list of all entities
public Task <IEnumerable <T> > GetListAsync()
{
return(MethodHelper.CatchFunction(Connection.GetListAsync <T>));
}
//
// Summary:
// By default queries the table matching the class name
// -Table name can be overridden by adding an attribute on your class [Table("YourTableName")]
// conditions is an SQL where clause and/or order by clause ex: "where name='bob'"
// or "where age>=@Age"
// parameters is an anonymous type to pass in named parameter values: new { Age
// = 15 }
// Supports transaction and command timeout
// Returns a list of entities that match where conditions
//
// Parameters:
// connection:
//
// conditions:
//
// parameters:
//
// transaction:
//
// commandTimeout:
//
// Type parameters:
// T:
//
// Returns:
// Gets a list of entities with optional SQL where conditions
public IList <T> GetList(string conditions, object parameters = null, IDbTransaction transaction = null, int?commandTimeout = null)
{
return(MethodHelper.CatchFunction(Connection.GetList <T>, conditions, parameters, transaction, commandTimeout).ToList());
}
//
// Summary:
// By default queries the table matching the class name
// -Table name can be overridden by adding an attribute on your class [Table("YourTableName")]
// Returns a list of all entities
//
// Parameters:
// connection:
//
// Type parameters:
// T:
//
// Returns:
// Gets a list of all entities
public IEnumerable <T> GetList()
{
return(MethodHelper.CatchFunction(Connection.GetList <T>));
}
//
// Summary:
// By default queries the table matching the class name asynchronously
// -Table name can be overridden by adding an attribute on your class [Table("YourTableName")]
// By default filters on the Id column
// -Id column name can be overridden by adding an attribute on your primary key
// property [Key]
// Supports transaction and command timeout
// Returns a single entity by a single id from table T
//
// Parameters:
// connection:
//
// id:
//
// transaction:
//
// commandTimeout:
//
// Type parameters:
// T:
//
// Returns:
// Returns a single entity by a single id from table T.
public Task <T> GetAsync(object id, IDbTransaction transaction = null, int?commandTimeout = null)
{
return(MethodHelper.CatchFunction(Connection.GetAsync <T>, id, transaction, commandTimeout));
}
//
// Summary:
// Updates a record or records in the database with only the properties of TEntity
// By default updates records in the table matching the class name
// -Table name can be overridden by adding an attribute on your class [Table("YourTableName")]
// Updates records where the Id property and properties with the [Key] attribute
// match those in the database.
// Properties marked with attribute [Editable(false)] and complex types are ignored
// Supports transaction and command timeout
// Returns number of rows affected
//
// Parameters:
// connection:
//
// entityToUpdate:
//
// transaction:
//
// commandTimeout:
//
// Returns:
// The number of affected records
public int Update(T entityToUpdate, IDbTransaction transaction = null, int?commandTimeout = null)
{
return(MethodHelper.CatchFunction(Connection.Update, entityToUpdate, transaction, commandTimeout));
}
//
// Summary:
// By default queries the table matching the class name asynchronously
// -Table name can be overridden by adding an attribute on your class [Table("YourTableName")]
// whereConditions is an anonymous type to filter the results ex: new {Category
// = 1, SubCategory=2}
// Supports transaction and command timeout
// Returns a list of entities that match where conditions
//
// Parameters:
// connection:
//
// whereConditions:
//
// transaction:
//
// commandTimeout:
//
// Type parameters:
// T:
//
// Returns:
// Gets a list of entities with optional exact match where conditions
public Task <IEnumerable <T> > GetListAsync <T>(object whereConditions, IDbTransaction transaction = null, int?commandTimeout = null)
{
return(MethodHelper.CatchFunction(Connection.GetListAsync <T>, whereConditions, transaction, commandTimeout));
}
//
// Summary:
// Deletes a record or records in the database by ID
// By default deletes records in the table matching the class name
// -Table name can be overridden by adding an attribute on your class [Table("YourTableName")]
// Deletes records where the Id property and properties with the [Key] attribute
// match those in the database
// The number of records affected
// Supports transaction and command timeout
//
// Parameters:
// connection:
//
// id:
//
// transaction:
//
// commandTimeout:
//
// Type parameters:
// T:
//
// Returns:
// The number of records affected
public int Delete(object id, IDbTransaction transaction = null, int?commandTimeout = null)
{
return(MethodHelper.CatchFunction(Connection.Delete, id, transaction, commandTimeout));
}
//
// Summary:
// By default queries the table matching the class name
// -Table name can be overridden by adding an attribute on your class [Table("YourTableName")]
// conditions is an SQL where clause ex: "where name='bob'" or "where age>=@Age"
// - not required
// orderby is a column or list of columns to order by ex: "lastname, age desc" -
// not required - default is by primary key
// parameters is an anonymous type to pass in named parameter values: new { Age
// = 15 }
// Supports transaction and command timeout
// Returns a list of entities that match where conditions
//
// Parameters:
// connection:
//
// pageNumber:
//
// rowsPerPage:
//
// conditions:
//
// orderby:
//
// parameters:
//
// transaction:
//
// commandTimeout:
//
// Type parameters:
// T:
//
// Returns:
// Gets a paged list of entities with optional exact match where conditions
public IList <T> GetListPaged(int pageNumber, int rowsPerPage, string conditions, string orderby, object parameters = null, IDbTransaction transaction = null, int?commandTimeout = null)
{
return(MethodHelper.CatchFunction(Connection.GetListPaged <T>, pageNumber, rowsPerPage, conditions, orderby, parameters, transaction, commandTimeout).ToList());
}
//
// Summary:
// Return a sequence of dynamic objects with properties matching the columns.
//
// Parameters:
// cnn:
// The connection to query on.
//
// sql:
// The SQL to execute for the query.
//
// param:
// The parameters to pass, if any.
//
// transaction:
// The transaction to use, if any.
//
// buffered:
// Whether to buffer the results in memory.
//
// commandTimeout:
// The command timeout (in seconds).
//
// commandType:
// The type of command to execute.
//
// Remarks:
// Note: each row can be accessed via "dynamic", or by casting to an IDictionary<string,object>
public IEnumerable <T> Query(string sql, object param = null, IDbTransaction transaction = null, bool buffered = true, int?commandTimeout = null, CommandType?commandType = null)
{
return(MethodHelper.CatchFunction(Connection.Query <T>, sql, param, transaction, buffered, commandTimeout, commandType));
}
//
// Summary:
// By default queries the table matching the class name
// -Table name can be overridden by adding an attribute on your class [Table("YourTableName")]
// conditions is an SQL where clause ex: "where name='bob'" or "where age>=@Age"
// - not required
// orderby is a column or list of columns to order by ex: "lastname, age desc" -
// not required - default is by primary key
// parameters is an anonymous type to pass in named parameter values: new { Age
// = 15 }
// Returns a list of entities that match where conditions
//
// Parameters:
// connection:
//
// pageNumber:
//
// rowsPerPage:
//
// conditions:
//
// orderby:
//
// parameters:
//
// transaction:
//
// commandTimeout:
//
// Type parameters:
// T:
//
// Returns:
// Gets a list of entities with optional exact match where conditions
public Task <IEnumerable <T> > GetListPagedAsync(int pageNumber, int rowsPerPage, string conditions, string orderby, object parameters = null, IDbTransaction transaction = null, int?commandTimeout = null)
{
return(MethodHelper.CatchFunction(Connection.GetListPagedAsync <T>, pageNumber, rowsPerPage, conditions, orderby, parameters, transaction, commandTimeout));
}
//
// Summary:
// Execute parameterized SQL.
//
// Parameters:
// cnn:
// The connection to execute on.
//
// command:
// The command to execute on this connection.
//
// Returns:
// The number of rows affected.
public int Execute(CommandDefinition command)
{
return(MethodHelper.CatchFunction(Connection.Execute, command));
}
//
// Summary:
// Deletes a record or records in the database that match the object passed in asynchronously
// -By default deletes records in the table matching the class name
// Table name can be overridden by adding an attribute on your class [Table("YourTableName")]
// Supports transaction and command timeout
// Returns the number of records affected
//
// Parameters:
// connection:
//
// entityToDelete:
//
// transaction:
//
// commandTimeout:
//
// Type parameters:
// T:
//
// Returns:
// The number of records affected
public Task <int> DeleteAsync(T entityToDelete, IDbTransaction transaction = null, int?commandTimeout = null)
{
return(MethodHelper.CatchFunction(Connection.DeleteAsync, entityToDelete, transaction, commandTimeout));
}
