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

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

            var pe = context.Persons.Create();
            pe.Name = "Eddie";
            pe.Age = 30;

            var pb = context.Persons.Create();
            pb.Name = "Bill";
            pb.Age = 30;

            var pf = context.Persons.Create();
            pf.Name = "Freddie";
            pf.Age = 30;

            var pd = context.Persons.Create();
            pd.Name = "Dennis";
            pd.Age = 29;

            var pc = context.Persons.Create();
            pc.Name = "Carole";
            pc.Age = 29;

            var pa = context.Persons.Create();
            pa.Name = "Annie";
            pa.Age = 35;

            context.SaveChanges();
            Assert.AreEqual(6, context.Persons.Count());

            var orderedByAgeThenName = context.Persons.OrderBy(p => p.Age).ThenBy(p => p.Name);
            Assert.IsNotNull(orderedByAgeThenName);
            Assert.AreEqual(6, orderedByAgeThenName.Count());
            var i = 0;
            foreach (var p in orderedByAgeThenName)
            {
                Assert.IsNotNull(p.Name);
                Assert.IsNotNull(p.Age);
                switch (i)
                {
                    case 0:
                        Assert.AreEqual("Carole", p.Name);
                        break;
                    case 1:
                        Assert.AreEqual("Dennis", p.Name);
                        break;
                    case 2:
                        Assert.AreEqual("Bill", p.Name);
                        break;
                    case 3:
                        Assert.AreEqual("Eddie", p.Name);
                        break;
                    case 4:
                        Assert.AreEqual("Freddie", p.Name);
                        break;
                    case 5:
                        Assert.AreEqual("Annie", p.Name);
                        break;
                }
                i++;
            }

        }