public static T First <T>(this El_Queryable <T> entity) where T : new()
{
string sql = entity.ToSql();
sql = Regex.Replace(sql, "limit.*", "limit 0,1");
return(entity.e.Select <T>(sql).Single());
}
public static List <NewT> ToNewList <T, NewT>(this El_Queryable <T> entity)
where NewT : new()
where T : new()
{
string sql = entity.ToSql();
return(entity.e.Select <NewT>(sql));
}
public static int Count <T>(this El_Queryable <T> entity) where T : new()
{
string sql = entity.ToSql();
sql = Regex.Replace(sql, "select(.*?)from", "select count(*) from ");
var count = entity.e.GetInt(sql);
return(count);
}
public static T Single <T>(this El_Queryable <T> entity) where T : new()
{
string sql = entity.ToSql();
return(entity.e.Select <T>(sql).Single());
}
public static DataTable ToDataTable <T>(this El_Queryable <T> entity) where T : new()
{
string sql = entity.ToSql();
return(entity.e.GetDataTable(sql));
}