public Query(string entity, string select, string filter, string orderby, XElement schema, ParameterCollection parameters) { Entity = entity; Schema = new XElement(schema); Parameters = parameters; // Select = new Select(string.IsNullOrWhiteSpace(select) ? "*" : select, Entity, Schema); List <string> parameterList = new List <string>(); IEnumerable <string> properties = Select.Properties; if (!string.IsNullOrWhiteSpace(filter)) { Filter = new Filter(filter, Entity, Schema); properties = properties.Union(Filter.Properties); parameterList.AddRange(Filter.Parameters); } if (!string.IsNullOrWhiteSpace(orderby)) { Orderby = new Orderby(orderby, Entity, Schema); properties = properties.Union(Orderby.Orders.Select(o => o.Property)); } // List <Property> propertyList = new List <Property>(); XElement entitySchema = Schema.GetEntitySchema(Entity); foreach (string property in properties) { Property oProperty; XElement propertySchema = entitySchema.Elements(SchemaVocab.Property).FirstOrDefault(x => x.Attribute(SchemaVocab.Name).Value == property); if (propertySchema == null) { if (!property.Contains(".")) { throw new SyntaxErrorException(string.Format(ErrorMessages.NotFoundProperty, property, Entity)); } oProperty = ExtendProperty.GenerateExtendProperty(property, Entity, schema); } else { oProperty = FieldProperty.Create(property, entity, Schema); } propertyList.Add(oProperty); } Properties = new PropertyCollection(propertyList, this); Parameters.UnionParameters(parameterList); }
protected string GenerateOrderBy(Orderby orderby, Table table) { List <string> list = new List <string>(); foreach (Order order in orderby.Orders) { Column column = table.Columns[order.Property]; if (order is DescendingOrder) { list.Add(string.Format("{0} {1}", ToSqlString(column, table), "DESC")); } else // AscendingOrder { list.Add(string.Format("{0} {1}", ToSqlString(column, table), "ASC")); } } return("ORDER BY " + string.Join(",", list)); }