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);
}