public Task <T> ExecuteScalarAsync <T>(string sql, params object[] args) { return(Task <T> .Factory.StartNew( () => { SqliteSession conn = this.GetAsyncConnection(); using (conn.Lock()) { return conn.ExecuteScalar <T>(sql, args); } })); }
public Task <T> GetAsync <T>(object pk, params object[] primaryKeys) where T : new() { return(Task.Factory.StartNew( () => { SqliteSession conn = this.GetAsyncConnection(); using (conn.Lock()) { return conn.Get <T>(pk, primaryKeys); } })); }
public Task <int> ClearTableAsync <T>() where T : new() { return(Task.Factory.StartNew( () => { SqliteSession conn = this.GetAsyncConnection(); using (conn.Lock()) { return conn.ClearTable <T>(); } })); }
public Task <int> ExecuteAsync(string query, params object[] args) { return(Task <int> .Factory.StartNew( () => { SqliteSession conn = this.GetAsyncConnection(); using (conn.Lock()) { return conn.Execute(query, args); } })); }
public Task <int> UpdateAllAsync <T>(string propertyName, object propertyValue) { return(Task.Factory.StartNew( () => { SqliteSession conn = this.GetAsyncConnection(); using (conn.Lock()) { return conn.UpdateAll <T>(propertyName, propertyValue); } })); }
public Task <int> DeleteAsync <T>(T item) { return(Task.Factory.StartNew( () => { SqliteSession conn = this.GetAsyncConnection(); using (conn.Lock()) { return conn.Delete(item); } })); }
public Task <List <T> > QueryAsync <T>(string sql, params object[] args) where T : new() { return(Task <List <T> > .Factory.StartNew( () => { SqliteSession conn = this.GetAsyncConnection(); using (conn.Lock()) { return conn.Query <T>(sql, args); } })); }
public Task <int> InsertAsync <T>(T item, ConflictResolution extra) { return(Task.Factory.StartNew( () => { SqliteSession conn = this.GetAsyncConnection(); using (conn.Lock()) { return conn.Insert(item, extra); } })); }
public Task <int> InsertAllAsync <T>(IEnumerable <T> items) { return(Task.Factory.StartNew( () => { SqliteSession conn = this.GetAsyncConnection(); using (conn.Lock()) { return conn.InsertAll(items); } })); }
public Task <T> GetAsync <T>(Expression <Func <T, bool> > expression) where T : new() { return(Task.Factory.StartNew( () => { SqliteSession conn = this.GetAsyncConnection(); using (conn.Lock()) { return conn.Get(expression); } })); }
public Task <int> InsertDefaultsAsync <T>() where T : class { return(Task.Factory.StartNew( () => { SqliteSession conn = this.GetAsyncConnection(); using (conn.Lock()) { return conn.InsertDefaults <T>(); } })); }