//-- DeletePermanent (T entity) public virtual bool DeletePermanent(T entity) { using (var context = DBRepository.ReturnMySqlContext(_connectionString)) { return(context.Connection.Delete(entity)); } }
//-- DeletePermanentAsync (T entity) public virtual async Task <bool> DeletePermanentAsync(T entity) { using (var context = DBRepository.ReturnMySqlContext(_connectionString)) { return(await context.Connection.DeleteAsync(entity)); } }
//-- InsertAsync (T entity) public virtual async Task <object> InsertAsync(T entity) { entity = SetIncludeData(entity); using (var context = DBRepository.ReturnMySqlContext(_connectionString)) { return(await context.Connection.InsertAsync(entity)); } }
//-- UpdateAsync (T entity) public virtual async Task <bool> UpdateAsync(T entity) { entity = SetAlterData(entity); using (var context = DBRepository.ReturnMySqlContext(_connectionString)) { return(await context.Connection.UpdateAsync(entity)); } }
//-- Update (T entity) public virtual bool Update(T entity) { entity = SetAlterData(entity); using (var context = DBRepository.ReturnMySqlContext(_connectionString)) { return(context.Connection.Update(entity)); } }
//-- Insert (T entity) public virtual T Insert(T entity) { using (var context = DBRepository.ReturnMySqlContext(_connectionString)) { entity = SetIncludeData(entity); entity.Id = Convert.ToInt32(context.Connection.Insert(entity)); return(entity); } }
//-- DeletePermanent (int id) public virtual bool DeletePermanent(int id) { using (var context = DBRepository.ReturnMySqlContext(_connectionString)) { var obj = Activator.CreateInstance <T>(); obj.Id = id; return(context.Connection.Delete(obj)); } }
//-- DeletePermanentAsync (int id) public virtual async Task <bool> DeletePermanentAsync(int id) { using (var context = DBRepository.ReturnMySqlContext(_connectionString)) { var obj = Activator.CreateInstance <T>(); obj.Id = id; return(await context.Connection.DeleteAsync(obj)); } }
public T ExecuteProcedureFirst(string storedProcedure, object objParameters = null, int?timeout = 120, IMySQLContext dbContext = null, bool buffered = true) { if (dbContext == null) { using (var context = DBRepository.ReturnMySqlContext(_connectionString)) { return(context.Connection.QueryFirstOrDefault <T>(storedProcedure, objParameters, null, timeout, CommandType.StoredProcedure)); } } else { return(dbContext.Connection.QueryFirstOrDefault <T>(storedProcedure, objParameters, dbContext.Transaction, timeout, CommandType.StoredProcedure)); } }
public async Task <SqlMapper.GridReader> ExecuteProcedureMultipleAsync(string storedProcedure, object objParameters = null, int?timeout = 120, IMySQLContext dbContext = null, bool buffered = true) { if (dbContext == null) { using (var context = DBRepository.ReturnMySqlContext(_connectionString)) { return(await context.Connection.QueryMultipleAsync(storedProcedure, objParameters, null, timeout, CommandType.StoredProcedure)); } } else { return(await dbContext.Connection.QueryMultipleAsync(storedProcedure, objParameters, dbContext.Transaction, timeout, CommandType.StoredProcedure)); } }
public async Task <IEnumerable <T> > ExecuteProcedureAsync(string storedProcedure, object objParameters = null, int?timeout = 120, IMySQLContext dbContext = null) { if (dbContext == null) { using (var context = DBRepository.ReturnMySqlContext(_connectionString)) { return(await context.Connection.QueryAsync <T>(storedProcedure, objParameters, null, timeout, CommandType.StoredProcedure)); } } else { return(await dbContext.Connection.QueryAsync <T>(storedProcedure, objParameters, dbContext.Transaction, timeout, CommandType.StoredProcedure)); } }
public virtual IEnumerable <T> GetAll() { using var dbContext = DBRepository.ReturnMySqlContext(_connectionString); return(GetAll(dbContext)); }
public IMySQLContext NewConnection(string connectionString) { _connectionString = connectionString; return(DBRepository.ReturnMySqlContext(_connectionString)); }
public virtual async Task <IEnumerable <T> > GetAllAsync() { using var dbContext = DBRepository.ReturnMySqlContext(_connectionString); return(await GetAllAsync(dbContext)); }
public virtual async Task <T> GetByIdAsync(int id) { using var dbContext = DBRepository.ReturnMySqlContext(_connectionString); return(await GetByIdAsync(id, dbContext)); }
public virtual T SelectFirst <TKey>(Expression <Func <T, bool> > linqExpression, bool ascOrder, Func <T, TKey> orderExpression) { using var dbContext = DBRepository.ReturnMySqlContext(_connectionString); return(SelectFirst(linqExpression, ascOrder, orderExpression, dbContext)); }
public virtual IEnumerable <T> Select(Expression <Func <T, bool> > linqExpression) { using var dbContext = DBRepository.ReturnMySqlContext(_connectionString); return(Select(linqExpression, dbContext)); }
public virtual T GetById(int id) { using var dbContext = DBRepository.ReturnMySqlContext(_connectionString); return(GetById(id, dbContext)); }
public virtual async Task <T> SelectFirstAsync(Expression <Func <T, bool> > linqExpression) { using var dbContext = DBRepository.ReturnMySqlContext(_connectionString); return(await SelectFirstAsync(linqExpression, dbContext)); }