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

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

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

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

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

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

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

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

            context.SaveChanges();

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

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

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