public async Task <List <T> > ReadOneByParameterAsync <T>(string parmeterName, object parameterValue) where T : BaseItem, new()
{
var typeName = typeof(T).Name;
//var result = await DBConnectionAsync.QueryAsync<T>("Select * from ? where ? = ?", typeName, parmeterName, parameterValue);
var result = await DBConnectionAsync.QueryAsync <T>("Select * from Person where FirstName = Simon");
return(result);
}
public async Task <List <T> > ReadAllAsync <T>() where T : BaseItem, new()
{
return(await DBConnectionAsync.Table <T>().ToListAsync());
}
public async Task <int> DeleteAsync <T>(T deletedItem) where T : BaseItem
{
return(await DBConnectionAsync.DeleteAsync(deletedItem));
}
public async Task <int> UpdateAsync <T>(T updatedItem) where T : BaseItem
{
return(await DBConnectionAsync.UpdateAsync(updatedItem));
}
public async Task <int> InsertAsync <T>(T newItem) where T : BaseItem, new()
{
await DBConnectionAsync.CreateTableAsync <T>();
return(await DBConnectionAsync.InsertAsync(newItem));
}
