public async Task <IEnumerable <T> > FindALLRecords()
{
try
{
using (IDbConnection db = new SqlConnection(_config.Connection._ConnectionString))
{
var _ret_val = await db.QueryAsync <T>(MSSQLQueryCreater.CombineQueryForSelectAll(_tablename, "Id"));
return(_ret_val);
}
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <T> FindOneRecord(int _FK_value)
{
try
{
using (IDbConnection db = new SqlConnection(_config.Connection._ConnectionString))
{
var _ret_val = await db.QuerySingleOrDefaultAsync <T>(MSSQLQueryCreater.CombineQueryForSelect(_tablename, "Id", _FK_value));
return(_ret_val);
}
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <bool> DeleteSingle(int Id)
{
try
{
using (IDbConnection db = new SqlConnection(_config.Connection._ConnectionString))
{
var _ret_val = await db.ExecuteAsync(MSSQLQueryCreater.CombineQueryForDelete(_tablename, "Id", Id));
return(_ret_val > 0 ? true : false);
}
}
catch (Exception ex)
{
throw ex;
}
}
