public void Contains8() { var arr = new[] { GrandChild.ElementAt(0), GrandChild.ElementAt(1) }; ForEachProvider(db => AreEqual( from p in Parent join ch in Child on p.ParentID equals ch.ParentID join gc in GrandChild on ch.ChildID equals gc.ChildID where arr.Contains(gc) select p, from p in db.Parent join ch in db.Child on p.ParentID equals ch.ParentID join gc in db.GrandChild on ch.ChildID equals gc.ChildID where arr.Contains(gc) select p)); }
public void NotContains8([DataSources] string context) { var arr = new[] { GrandChild.ElementAt(0), GrandChild.ElementAt(1) }; using (var db = GetDataContext(context)) AreEqual( from p in Parent join ch in Child on p.ParentID equals ch.ParentID join gc in GrandChild on ch.ChildID equals gc.ChildID where !arr.Contains(gc) select p , from p in db.Parent join ch in db.Child on p.ParentID equals ch.ParentID join gc in db.GrandChild on ch.ChildID equals gc.ChildID where !arr.Contains(gc) select p); }
public void Contains801() { var arr = new[] { GrandChild.ElementAt(0), GrandChild.ElementAt(1) }; ForEachProvider(db => AreEqual( from p in Parent join ch in Child on p.ParentID equals ch.ParentID join gc in GrandChild on ch.ChildID equals gc.ChildID select new GrandChild { ParentID = 2, ChildID = ch.ChildID, GrandChildID = gc.GrandChildID } into gc where arr.Contains(gc) select gc, from p in db.Parent join ch in db.Child on p.ParentID equals ch.ParentID join gc in db.GrandChild on ch.ChildID equals gc.ChildID select new GrandChild { ParentID = 2, ChildID = ch.ChildID, GrandChildID = gc.GrandChildID } into gc where arr.Contains(gc) select gc)); }
public void Contains803(string context) { var arr = new[] { GrandChild.ElementAt(0), GrandChild.ElementAt(1) }; using (var db = GetDataContext(context)) AreEqual( from p in Parent join ch in Child on p.ParentID equals ch.ParentID join gc in GrandChild on ch.ChildID equals gc.ChildID where arr.Contains(new GrandChild { ParentID = 1, ChildID = ch.ChildID, GrandChildID = gc.GrandChildID }) select p , from p in db.Parent join ch in db.Child on p.ParentID equals ch.ParentID join gc in db.GrandChild on ch.ChildID equals gc.ChildID where arr.Contains(new GrandChild { ParentID = 1, ChildID = ch.ChildID, GrandChildID = gc.GrandChildID }) select p); }
public void Contains801([DataSources] string context) { var arr = new[] { GrandChild.ElementAt(0), GrandChild.ElementAt(1) }; using (var db = GetDataContext(context)) AreEqual( from p in Parent join ch in Child on p.ParentID equals ch.ParentID join gc in GrandChild on ch.ChildID equals gc.ChildID select new GrandChild { ParentID = 2, ChildID = ch.ChildID, GrandChildID = gc.GrandChildID } into gc where arr.Contains(gc) select gc , from p in db.Parent join ch in db.Child on p.ParentID equals ch.ParentID join gc in db.GrandChild on ch.ChildID equals gc.ChildID select new GrandChild { ParentID = 2, ChildID = ch.ChildID, GrandChildID = gc.GrandChildID } into gc where arr.Contains(gc) select gc); }