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

        public void TestLinqOrderByString()
        {
            var connectionString = GetConnectionString("TestLinqOrderByString");
            var context = new MyEntityContext(connectionString);
            var pe = context.Persons.Create();
            pe.Name = "Eddie";
            var pb = context.Persons.Create();
            pb.Name = "Bill";
            var pf = context.Persons.Create();
            pf.Name = "Freddie";
            var pd = context.Persons.Create();
            pd.Name = "Dennis";
            var pc = context.Persons.Create();
            pc.Name = "Carole";
            var pa = context.Persons.Create();
            pa.Name = "Annie";

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

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

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