public void GroupJoinTest() { Require.AnyFeatureNotSupported(ProviderFeatures.TemporaryTableEmulation | ProviderFeatures.TemporaryTables); using (var session = Domain.OpenSession()) using (var tx = session.OpenTransaction()) { var items = new List <int> { 2, 3 }; var query = from o in session.Query.All <NamedObject>() join i in items on o.Id equals i into j select o; var result = query.ToList(); Assert.That(result.Count, Is.EqualTo(3)); } }
public void ApplyTest() { Require.AnyFeatureNotSupported(ProviderFeatures.TemporaryTableEmulation | ProviderFeatures.TemporaryTables); using (var session = Domain.OpenSession()) using (var tx = session.OpenTransaction()) { var items = new List <int> { 1, 2, 3 }; var query = from o in session.Query.All <NamedObject>() from i in items select new { Object = o, Item = i }; Assert.That(query.Count(), Is.EqualTo(9)); } }