public virtual Interface.IQueryable <T> MergeTable()
{
// Check.Exception(this.QueryBuilder.SelectValue.IsNullOrEmpty(), "MergeTable need to use Select(it=>new{}) Method .");
// Check.Exception(this.QueryBuilder.Skip > 0 || this.QueryBuilder.Take > 0, "MergeTable Queryable cannot Take Skip OrderBy PageToList ");
var sql = QueryBuilder.ToSqlString();
var tableName = this.SqlBuilder.GetPackTable(sql, "MergeTable");
return(this.Context.Queryable <ExpandoObject>().AS(tableName).Select <T>("*"));
}
public virtual int Count()
{
QueryBuilder.IsCount = true;
var sql = string.Empty;
sql = QueryBuilder.ToSqlString();
sql = QueryBuilder.ToCountSql(sql);
var reval = Context.Ado.GetInt(sql, QueryBuilder.Parameters.ToArray());
QueryBuilder.IsCount = false;
return(reval);
}
public virtual KeyValuePair <string, List <Parameter> > ToSql()
{
string sql = QueryBuilder.ToSqlString();
return(new KeyValuePair <string, List <Parameter> >(sql, QueryBuilder.Parameters));
}