public void TestCount() { const int resultRowCount = 77; //create root node var root = new JoinNode(typeof(Products)); // add child node Categories with propertyName "Products". // Because Categories linked with Products by next property: // public EntitySet<Products> Products root.AddChildren(new JoinNode(typeof(Categories), "Category", "Products")); var queryDesinger = new QueryDesigner(context, root); var count = queryDesinger.Count(); // check numbers of entity Assert.AreEqual(resultRowCount, count); }
public void TestDataInNullableCondition() { var queryable = from order in context.Orders where order.OrderDate < DateTime.Now select order; var count = queryable.Count(); var queryDesigner = new QueryDesigner(context, typeof(Order)); var conditions = new ConditionList(new Condition("OrderDate", DateTime.Now, ConditionOperator.LessThan)); queryDesigner = queryDesigner.Where(conditions); var resultCount = queryDesigner.Count(); Assert.AreEqual(count, resultCount); }
public void TestEnumInCondition() { var count = (from order in context.Orders where order.OrderDate.Value.DayOfWeek == DayOfWeek.Monday select order).Count(); QueryDesigner queryDesigner = new QueryDesigner(context, typeof(Order)); ConditionList conditions = new ConditionList(new Condition("OrderDate.Value.DayOfWeek", DayOfWeek.Monday)); queryDesigner = queryDesigner.Where(conditions); var resultCount = queryDesigner.Count(); Assert.AreEqual(count, resultCount); }
public void TestNullInNullableCondition() { var queryable = from order in context.Orders where order.OrderDate == null select order; var count = queryable.Count(); var queryDesigner = new QueryDesigner(context, typeof(Order)); var conditions = new ConditionList(new Condition("OrderDate", null)); queryDesigner = queryDesigner.Where(conditions); var resultCount = queryDesigner.Count(); Assert.AreEqual(count, resultCount); }