public TEntityType SingleById <TEntityType>(int Id) { using (NPoco.IDatabase db = GetDataBase()) { return(db.SingleById <TEntityType>(Id)); } }
public void Save(IDatabaseEntity entity) { using (NPoco.IDatabase db = GetDataBase()) { db.Save(entity); } }
public IEnumerable <TEntityType> Fetch <TEntityType>(ListRequestParam requestParams) { using (NPoco.IDatabase db = GetDataBase()) { return(db.SkipTake <TEntityType>(requestParams.CurrentPage * requestParams.PageCount, requestParams.PageCount, ConvertRequestParamToSqlTemplate(requestParams))); } }
public void Delete <TEntityType>(int Id) { using (NPoco.IDatabase db = GetDataBase()) { db.Delete <TEntityType>(Id); } }
public void Update(IDatabaseEntity entityInstance) { using (NPoco.IDatabase db = GetDataBase()) { db.Save <IDatabaseEntity>(entityInstance); } }
public NPocoDatabase(string connectionString) { ConnectionString = connectionString; if (ConnectionString == null || ConnectionString.Length <= 0) { throw new ArgumentNullException(nameof(connectionString)); } DatabaseInstance = new Database(ConnectionString, DatabaseType.SqlServer2008, SqlClientFactory.Instance); }