/// <summary>
/// removes a record from the database
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="Obj"></param>
/// <returns></returns>
public virtual async Task Delete <T>(T Obj)
{
try
{
this.Query = DBISamHelper.GenerateDeleteStatement(Obj);
await ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Updates a record in the database
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="obj"></param>
/// <returns></returns>
public virtual async Task Update <T>(T obj)
{
try
{
this.Query = DBISamHelper.GenerateUpdateStatment <T>(obj);
await ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Creates a record in the database
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="Obj"></param>
/// <returns></returns>
public virtual async Task <int> Create <T>(T Obj)
{
try
{
this.Query = DBISamHelper.GenerateInsertStatment(Obj);
return(await ExecuteNonQuery());
}
catch (Exception ex)
{
throw ex;
}
}