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