public void DbQuery_SelectMany_with_TVFs_and_hierarchyid_types_works() { using (var context = new HierarchyIdNorthwindContext(_connectionString)) { var results = (from s1 in context.SuppliersWithinRange(HierarchyId.Parse("/-100/"), HierarchyId.Parse("/100/")) from s2 in context.SuppliersWithinRange(HierarchyId.Parse("/-100/"), HierarchyId.Parse("/100/")) where s1.Name == s2.Name select new { s1, s2 }).ToList(); Assert.Equal(16, results.Count); } }
private void DbQuery_with_TVFs_mapped_to_context_instance_methods_involving_hierarchyid_types_works( Func <IQueryable <IQueryable <SupplierWithHierarchyId> >, List <IQueryable <SupplierWithHierarchyId> > > toList) { using (var context = new HierarchyIdNorthwindContext(_connectionString)) { var suppliers = toList( from x in context.Suppliers select context.SuppliersWithinRange( HierarchyId.Parse("/1/"), HierarchyId.Parse("/10/"))); Assert.Equal(16, suppliers.Count); } }