public async Task <int> DeleteAsync(T entity)
{
string statement = MssqlQueryBuilder.BuildSingleUpdateStatement <T>();
var result = await ExecuteAsync(statement, entity);
return(result);
}
public async Task <int> PutAsync(T entity)
{
string statement = MssqlQueryBuilder.BuildSinglePutStatement <T>();
int result = await ExecuteAsync(statement, entity);
return(result);
}
public async Task <IEnumerable <T> > FindAsync(object condition)
{
string statement = MssqlQueryBuilder.BuildSelectStatement <T>(condition);
var result = await QueryAsync <T>(statement, condition);
return(result);
}
public async Task <int> InsertAsync(T entity)
{
string statement = MssqlQueryBuilder.BuildInsertStatement <T>();
var result = await ExecuteAsync(statement, entity);
return(result);
}
public int Put(T entity)
{
string statement = MssqlQueryBuilder.BuildSinglePutStatement <T>();
int result = Execute(statement, entity);
return(result);
}
public int Update(T entity)
{
string statement = MssqlQueryBuilder.BuildSingleUpdateStatement <T>();
var result = Execute(statement, entity);
return(result);
}
public async Task <T> GetFirstAsync(object condition)
{
string statement = MssqlQueryBuilder.BuildSelectStatement <T>(condition);
var result = await QueryAsync <T>(statement, condition);
if (result.Any())
{
return(result.ElementAt(0));
}
return(null);
}
public T GetFirst(object condition)
{
string statement = MssqlQueryBuilder.BuildSelectStatement <T>(condition);
var result = Query <T>(statement, condition);
if (result.Any())
{
return(result.ElementAt(0));
}
return(null);
}
public IEnumerable <T> Find(object condition)
{
using (var connection = new SqlConnection(connectionString))
{
connection.Open();
string statement = MssqlQueryBuilder.BuildSelectStatement <T>(condition);
var result = connection.Query <T>(statement, condition);
connection.Close();
return(result);
}
}