public static T SelectOne <T>(string sql, params object[] parameters) where T : new()
{
try
{
return(Executer.ExecuteReader <T>(sql, parameters).Single());
}
catch (InvalidOperationException)
{
throw new NotFoundException();
}
}
public static Grouped <T> SelectAllGroupedBy <T>(string sql, Func <T, int> groupId, params object[] parameters) where T : new()
{
return(new Grouped <T>(Executer.ExecuteReader <T>(sql, parameters), groupId));
}
public static T[] SelectAll <T>(string sql, params object[] parameters) where T : new()
{
return(Executer.ExecuteReader <T>(sql, parameters).ToArray());
}
public static T SelectFirst <T>(string sql, params object[] parameters) where T : new()
{
return(Executer.ExecuteReader <T>(sql, parameters).FirstOrDefault());
}