public static Query CreateQuery() { Query query = new Query {TableName = "MainTable"}; query.Columns.Add("Column1"); query.Columns.Add("Column2"); query.Columns.Add("Column3"); Table subTable1 = new Table { TableName = "SubTabel1", ParenKey = "MainTableId", ChildKey = "SubTabel1Id" }; Table subTable2 = new Table { TableName = "SubTabel2", ParenKey = "MainTableId", ChildKey = "SubTabel2Id" }; query.Tables.Add(subTable1); query.Tables.Add(subTable2); RangeCondition rangeCondition = new RangeCondition { Column = "Column1", From = 10, To = 40 }; query.Conditions.Add(rangeCondition); CompareCondition compareCondition = new CompareCondition { Column = "Column2", Compare = CompareType.Equal, Value = "SomeValue" }; query.Conditions.Add(compareCondition); OrderBy orderBy1 = new OrderBy { Column = "Column1", Direction = OrderByDirection.Ascending }; OrderBy orderBy2 = new OrderBy { Column = "Column2", Direction = OrderByDirection.Descending }; query.OrderBys.Add(orderBy1); query.OrderBys.Add(orderBy2); return query; }
public static Query CreateQuery() { Query query = new Query(); query.TableName = "MainTable"; query.Columns.Add("Column1"); query.Columns.Add("Column2"); query.Columns.Add("Column3"); Table subTable1 = new Table(); subTable1.TableName = "SubTabel1"; subTable1.ParenKey = "MainTableId"; subTable1.ChildKey = "SubTabel1Id"; Table subTable2 = new Table(); subTable2.TableName = "SubTabel2"; subTable2.ParenKey = "MainTableId"; subTable2.ChildKey = "SubTabel2Id"; query.Tables.Add(subTable1); query.Tables.Add(subTable2); RangeCondition rangeCondition = new RangeCondition(); rangeCondition.Column = "Column1"; rangeCondition.From = 10; rangeCondition.To = 40; query.Conditions.Add(rangeCondition); CompareCondition compareCondition = new CompareCondition(); compareCondition.Column = "Column2"; compareCondition.Compare = CompareType.Equal; compareCondition.Value = "SomeValue"; query.Conditions.Add(compareCondition); OrderBy orderBy1 = new OrderBy(); orderBy1.Column = "Column1"; orderBy1.Direction = OrderByDirection.Ascending; OrderBy orderBy2 = new OrderBy(); orderBy2.Column = "Column2"; orderBy2.Direction = OrderByDirection.Descending; query.OrderBys.Add(orderBy1); query.OrderBys.Add(orderBy2); return query; }