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

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

            var jr1 = context.JobRoles.Create();
            jr1.Description = "development";

            var jr2 = context.JobRoles.Create();
            jr2.Description = "sales";

            var jr3 = context.JobRoles.Create();
            jr3.Description = "marketing";

            var jr4 = context.JobRoles.Create();
            jr4.Description = "management";

            var jr5 = context.JobRoles.Create();
            jr5.Description = "administration";

            context.SaveChanges();

            var roles = new IJobRole[] {jr1, jr2, jr3, jr4, jr5};

            for (var i = 0; i < 100; i++)
            {
                var p = context.Persons.Create();
                p.Name = "Person" + i;
                p.EmployeeId = i;
                p.JobRole = roles[i%5];
            }

            context.SaveChanges();

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

            var management = context.JobRoles.Where(s => s.Description.Equals("management")).First();
            Assert.IsNotNull(management);
            var managers = management.Persons;
            Assert.IsNotNull(managers);
            Assert.AreEqual(20, managers.Count);
        }