public void OrderByConstant2([IncludeDataSources(false, TestProvName.AllSQLite)] string context) { using (var db = (TestDataConnection)GetDataContext(context)) { var param = 2; var query = from ch in db.Child orderby Sql.ToNullable((int)Sql.Abs(1) !) descending, Sql.ToNullable((int)Sql.Abs(param + 1) !) select ch; query.ToArray(); Assert.That(db.LastQuery, Does.Not.Contain("ORDER BY")); } }
public void OrderByImmutableSubquery([IncludeDataSources(false, TestProvName.AllSQLite)] string context) { using (var db = (TestDataConnection)GetDataContext(context)) { var param = 2; var query = from ch in db.Child orderby Sql.ToNullable((int)Sql.Abs(1) !) descending, Sql.ToNullable((int)Sql.Abs(param + 1) !) select new { ch.ChildID, ch.ParentID, OrderElement = (int?)param }; query.AsSubQuery().OrderBy(c => c.OrderElement).ToArray(); Assert.That(db.LastQuery, Does.Not.Contain("ORDER BY")); } }
public void OrderByUnionImmutable([IncludeDataSources(false, TestProvName.AllSQLite)] string context) { using (var db = (TestDataConnection)GetDataContext(context)) { var param = 2; var query1 = from ch in db.Child orderby Sql.ToNullable((int)Sql.Abs(1) !) descending, Sql.ToNullable((int)Sql.Abs(param) !) select new { ch.ChildID, ch.ParentID, OrderElement = Sql.ToNullable((int)Sql.Abs(1) !) }; var query2 = from ch in db.Child orderby "1" descending, param select new { ch.ChildID, ch.ParentID, OrderElement = (int?)param }; var result = query1.Concat(query2).OrderBy(c => c.OrderElement) .ToArray(); Assert.That(db.LastQuery, Does.Contain("ORDER BY")); } } }