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