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