BrightstarDB.Tests.EntityFramework.LinqTests.TestLinqJoin1 C# (CSharp) Метод

        public void TestLinqJoin1()
        {
            var connectionString = GetConnectionString("TestLinqJoin1");
            var context = new MyEntityContext(connectionString);

            for(var i = 0; i<3; i++)
            {
                var jobrole = context.JobRoles.Create();
                jobrole.Description = "JobRole " + i;
                if (i <= 0) continue;
                for (var j = 0; j < 50; j++)
                {
                    var person = context.Persons.Create();
                    person.Name = "Person " + j;
                    jobrole.Persons.Add(person);
                }
            }
            context.SaveChanges();

            Assert.AreEqual(3, context.JobRoles.Count());
            Assert.AreEqual(100, context.Persons.Count());

            var rolesThatHavePeople = (from jobrole in context.JobRoles
                                  join person in context.Persons on jobrole.Id equals person.JobRole.Id
                                  select jobrole).Distinct().ToList();
            Assert.AreEqual(2, rolesThatHavePeople.Count);
        }