public void BatchUpdate_1()
        {
            Cleannup();
            Seed();
            using (var context = new ModelAndContext.EntityContext())
            {
                context.Customers.Update(c => new ModelAndContext.Customer {
                    TotalNumberOfOrders = c.Orders.Count(o => o.Name == "Works")
                });

                Assert.AreEqual(1, context.Customers.Where(x => x.TotalNumberOfOrders == 1 && x.Name == "Customer_A").ToList().Count);
                Assert.AreEqual(0, context.Customers.Where(x => x.TotalNumberOfOrders == 1 && x.Name != "Customer_A").ToList().Count);
                Assert.AreEqual(2, context.Customers.Where(x => x.TotalNumberOfOrders != 1 && x.Name != "Customer_A").ToList().Count);
            }

            using (var context = new ModelAndContext.EntityContext())
            {
                context.Customers.Update(c => new ModelAndContext.Customer {
                    TotalNumberOfOrders = c.Orders.Count(o => o.Company.Name == "DoesntWork")
                });


                Assert.AreEqual(1, context.Customers.Where(x => x.TotalNumberOfOrders == 1 && x.Name == "Customer_B").ToList().Count);
                Assert.AreEqual(0, context.Customers.Where(x => x.TotalNumberOfOrders == 1 && x.Name != "Customer_B").ToList().Count);
                Assert.AreEqual(2, context.Customers.Where(x => x.TotalNumberOfOrders != 1 && x.Name != "Customer_B").ToList().Count);
            }
        }
コード例 #2
0
 public static void cleannup()
 {
     using (var context = new ModelAndContext.EntityContext())
     {
         context.ContractComplexs.RemoveRange(context.ContractComplexs);
         context.SaveChanges();
     }
 }
コード例 #3
0
        public static void CreateContext(Microsoft.VisualStudio.TestTools.UnitTesting.TestContext testContext)
        {
            Effort.Provider.EffortProviderConfiguration.RegisterProvider();

            using (var context = new ModelAndContext.EntityContext())
            {
                ModelAndContext.My.CreateBD(context);
            }
        }
 public static void Cleannup()
 {
     using (var context = new ModelAndContext.EntityContext())
     {
         context.Companies.Delete();
         context.Orders.Delete();
         context.Customers.Delete();
     }
 }
コード例 #5
0
 public static void cleannup()
 {
     using (var context = new ModelAndContext.EntityContext())
     {
         context.TvContracts.RemoveRange(context.TvContracts);
         context.MobileContracts.RemoveRange(context.MobileContracts);
         context.BroadbandContracts.RemoveRange(context.BroadbandContracts);
         context.SaveChanges();
     }
 }
        public void BatchUpdate_2()
        {
            Cleannup();
            Seed();
            var changedUpdatedEntityIds = new[] { Guid.NewGuid() };

            var changedJoinedEntity1Ids          = new[] { Guid.NewGuid() };
            var changedIndirectlyJoinedEntityIds = new[] { Guid.NewGuid() };

            var changedJoinedEntity2Ids = new[] { Guid.NewGuid() };

            using (var context = new ModelAndContext.EntityContext())
            {
                context.Customers.Update(c => new ModelAndContext.Customer {
                    TotalNumberOfOrders = c.Orders.Count(o => o.Name == "Works")
                });


                context.Customers.Update(c => new ModelAndContext.Customer {
                    TotalNumberOfOrders = c.Orders.Count(o => o.Company.Name == "DoesntWork")
                });


                // TODO CHECK VALUE !
                context.Set <ModelAndContext.UpdatedEntity>().Include(x => x.JoinedEntity1).Include(x => x.JoinedEntity2)
                .Where(
                    sp => changedUpdatedEntityIds.Contains(sp.UpdatedEntityId) ||
                    changedJoinedEntity2Ids.Contains(sp.JoinedEntity2.JoinedEntity2Id) ||
                    changedJoinedEntity1Ids.Contains(sp.JoinedEntity1.JoinedEntity1Id) ||
                    changedIndirectlyJoinedEntityIds.Contains(sp.JoinedEntity1.IndirectlyJoinedEntity.IndirectlyJoinedEntityId))
                .Update(
                    u => new ModelAndContext.UpdatedEntity
                {
                    Status = (!u.IsActive
                                                                ? ModelAndContext.UpdatedEntityStatus.Inactive
                                                                : u.RestrictedBool && u.JoinedEntity2.String == null
                                                                        ? ModelAndContext.UpdatedEntityStatus.Invalid
                                                                        : u.JoinedEntity1.Status != ModelAndContext.JoinedEntity1Status.Valid
                                                                                ? ModelAndContext.UpdatedEntityStatus.Invalid
                                                                                : u.JoinedEntity1.Restrictions.Restriction1 && u.RestrictedNumber == 0
                                                                                        ? ModelAndContext.UpdatedEntityStatus.Invalid
                                                                                        : u.JoinedEntity1.Restrictions.Restriction2 && !u.RestrictedBool
                                                                                                ? ModelAndContext.UpdatedEntityStatus.Invalid
                                                                                                : ModelAndContext.UpdatedEntityStatus.Valid)
                });
            }
        }
        public static void Seed()
        {
            using (var context = new ModelAndContext.EntityContext())
            {
                var Company = new ModelAndContext.Company()
                {
                    Name = "DoesntWork"
                };
                var Company2 = new ModelAndContext.Company()
                {
                    Name = "DoesntWorkZ"
                };
                var order1 = new ModelAndContext.Order()
                {
                    Name = "Works"
                };
                var order2 = new ModelAndContext.Order()
                {
                    Name = "NotWorks"
                };
                order2.Company = Company;
                order1.Company = Company2;
                context.Orders.Add(order1);
                context.Orders.Add(order2);

                context.Customers.Add(new ModelAndContext.Customer()
                {
                    Name = "Customer_A", IsActive = false, Orders = new List <ModelAndContext.Order>()
                    {
                        order1
                    }
                });
                context.Customers.Add(new ModelAndContext.Customer()
                {
                    Name = "Customer_B", IsActive = true, Orders = new List <ModelAndContext.Order>()
                    {
                        order2
                    }
                });
                context.Customers.Add(new ModelAndContext.Customer()
                {
                    Name = "Customer_C", IsActive = false
                });
                context.SaveChanges();
            }
        }
コード例 #8
0
        public void BatchUpdateDelete_ComplexType_4()
        {
            cleannup();

            // SEED
            using (var context = new ModelAndContext.EntityContext())
            {
                //4
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 4
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 4
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 4
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 4
                });

                //4
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 3, MobileContractComplex = new ModelAndContext.MobileContractComplex()
                    {
                        MobileNumber = "4524"
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 3, MobileContractComplex = new ModelAndContext.MobileContractComplex()
                    {
                        MobileNumber = "4524"
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 3, MobileContractComplex = new ModelAndContext.MobileContractComplex()
                    {
                        MobileNumber = "4524"
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 3, MobileContractComplex = new ModelAndContext.MobileContractComplex()
                    {
                        MobileNumber = "4524"
                    }
                });

                //8
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 6, BroadbandContractComplex = new ModelAndContext.BroadbandContractComplex()
                    {
                        DownloadSpeed = 50
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    BroadbandContractComplex = new ModelAndContext.BroadbandContractComplex()
                    {
                        DownloadSpeed = 50
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 6, BroadbandContractComplex = new ModelAndContext.BroadbandContractComplex()
                    {
                        DownloadSpeed = 50
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    BroadbandContractComplex = new ModelAndContext.BroadbandContractComplex()
                    {
                        DownloadSpeed = 50
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 6, BroadbandContractComplex = new ModelAndContext.BroadbandContractComplex()
                    {
                        DownloadSpeed = 50
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    BroadbandContractComplex = new ModelAndContext.BroadbandContractComplex()
                    {
                        DownloadSpeed = 50
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 6, BroadbandContractComplex = new ModelAndContext.BroadbandContractComplex()
                    {
                        DownloadSpeed = 50
                    }, TvContractComplex = new ModelAndContext.TvContractComplex()
                    {
                        PackageType = ModelAndContext.PackageType.L
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    BroadbandContractComplex = new ModelAndContext.BroadbandContractComplex()
                    {
                        DownloadSpeed = 50
                    }, TvContractComplex = new ModelAndContext.TvContractComplex()
                    {
                        PackageType = ModelAndContext.PackageType.L
                    }
                });



                context.SaveChanges();
            }

            var now = DateTime.Now;

            using (var context = new ModelAndContext.EntityContext())
            {
                context.ContractComplexs.Update(x => new ModelAndContext.ContractComplex()
                {
                    StartDate = (x.Months == 1 ?  now : now)
                });
            }

            using (var context = new ModelAndContext.EntityContext())
            {
                Assert.AreEqual(context.ContractComplexs.Where(x => x.StartDate == now).ToList().Count, 16);
            }
        }
コード例 #9
0
        public void BatchUpdateDelete_ComplexType_3()
        {
            cleannup();

            // SEED
            using (var context = new ModelAndContext.EntityContext())
            {
                //4
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 4
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 4
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 4
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 4
                });

                //4
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 3, MobileContractComplex = new ModelAndContext.MobileContractComplex()
                    {
                        MobileNumber = "4524"
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 3, MobileContractComplex = new ModelAndContext.MobileContractComplex()
                    {
                        MobileNumber = "4524"
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 3, MobileContractComplex = new ModelAndContext.MobileContractComplex()
                    {
                        MobileNumber = "4524"
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 3, MobileContractComplex = new ModelAndContext.MobileContractComplex()
                    {
                        MobileNumber = "4524"
                    }
                });

                //8
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 6, BroadbandContractComplex = new ModelAndContext.BroadbandContractComplex()
                    {
                        DownloadSpeed = 50
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    BroadbandContractComplex = new ModelAndContext.BroadbandContractComplex()
                    {
                        DownloadSpeed = 50
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 6, BroadbandContractComplex = new ModelAndContext.BroadbandContractComplex()
                    {
                        DownloadSpeed = 50
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    BroadbandContractComplex = new ModelAndContext.BroadbandContractComplex()
                    {
                        DownloadSpeed = 50
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 6, BroadbandContractComplex = new ModelAndContext.BroadbandContractComplex()
                    {
                        DownloadSpeed = 50
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    BroadbandContractComplex = new ModelAndContext.BroadbandContractComplex()
                    {
                        DownloadSpeed = 50
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 6, BroadbandContractComplex = new ModelAndContext.BroadbandContractComplex()
                    {
                        DownloadSpeed = 50
                    }, TvContractComplex = new ModelAndContext.TvContractComplex()
                    {
                        PackageType = ModelAndContext.PackageType.L
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    BroadbandContractComplex = new ModelAndContext.BroadbandContractComplex()
                    {
                        DownloadSpeed = 50
                    }, TvContractComplex = new ModelAndContext.TvContractComplex()
                    {
                        PackageType = ModelAndContext.PackageType.L
                    }
                });


                context.SaveChanges();
            }
            using (var context = new ModelAndContext.EntityContext())
            {
                context.ContractComplexs.Where(x => x.MobileContractComplex.MobileNumber != "4524").Update(x => new ModelAndContext.ContractComplex()
                {
                    MobileContractComplex = new ModelAndContext.MobileContractComplex()
                    {
                        MobileNumber = "100"
                    }
                });
            }

            using (var context = new ModelAndContext.EntityContext())
            {
                Assert.AreEqual(context.ContractComplexs.Where(x => x.MobileContractComplex.MobileNumber == "100").ToList().Count, 12);
            }
        }
コード例 #10
0
        public void BatchUpdateDelete_ComplexType_1()
        {
            cleannup();

            // SEED
            using (var context = new ModelAndContext.EntityContext())
            {
                //4
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 4
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 4
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 4
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 4
                });

                //4
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 3, MobileContractComplex = new ModelAndContext.MobileContractComplex()
                    {
                        MobileNumber = "4524"
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 3, MobileContractComplex = new ModelAndContext.MobileContractComplex()
                    {
                        MobileNumber = "4524"
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 3, MobileContractComplex = new ModelAndContext.MobileContractComplex()
                    {
                        MobileNumber = "4524"
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 3, MobileContractComplex = new ModelAndContext.MobileContractComplex()
                    {
                        MobileNumber = "4524"
                    }
                });

                //8
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 6, BroadbandContractComplex = new ModelAndContext.BroadbandContractComplex()
                    {
                        DownloadSpeed = 50
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    BroadbandContractComplex = new ModelAndContext.BroadbandContractComplex()
                    {
                        DownloadSpeed = 52
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 6, BroadbandContractComplex = new ModelAndContext.BroadbandContractComplex()
                    {
                        DownloadSpeed = 50
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    BroadbandContractComplex = new ModelAndContext.BroadbandContractComplex()
                    {
                        DownloadSpeed = 52
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 6, BroadbandContractComplex = new ModelAndContext.BroadbandContractComplex()
                    {
                        DownloadSpeed = 50
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    BroadbandContractComplex = new ModelAndContext.BroadbandContractComplex()
                    {
                        DownloadSpeed = 1
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    Months = 6, BroadbandContractComplex = new ModelAndContext.BroadbandContractComplex()
                    {
                        DownloadSpeed = 52
                    }, TvContractComplex = new ModelAndContext.TvContractComplex()
                    {
                        PackageType = ModelAndContext.PackageType.L
                    }
                });
                context.ContractComplexs.Add(new ModelAndContext.ContractComplex()
                {
                    BroadbandContractComplex = new ModelAndContext.BroadbandContractComplex()
                    {
                        DownloadSpeed = 50
                    }, TvContractComplex = new ModelAndContext.TvContractComplex()
                    {
                        PackageType = ModelAndContext.PackageType.L
                    }
                });


                context.SaveChanges();
            }

            using (var context = new ModelAndContext.EntityContext())
            {
                // can't be null, but maybe I can do this where for get nothing
                context.ContractComplexs.Where(x => x.MobileContractComplex != null).Delete();

                context.ContractComplexs.Where(x => x.MobileContractComplex.MobileNumber == "4524").Delete();
                context.ContractComplexs.Where(x => x.BroadbandContractComplex.DownloadSpeed == 52).Update(y => new ModelAndContext.ContractComplex()
                {
                    BroadbandContractComplex = new ModelAndContext.BroadbandContractComplex()
                    {
                        DownloadSpeed = 59
                    }
                });
            }

            using (var context = new ModelAndContext.EntityContext())
            {
                Assert.AreEqual(context.ContractComplexs.ToList().Count, 12);
                Assert.AreEqual(context.ContractComplexs.Where(x => x.BroadbandContractComplex.DownloadSpeed == 59).ToList().Count, 3);
            }
        }
コード例 #11
0
        public void BatchUpdateDelete_TPH_4()
        {
            cleannup();

            // SEED
            using (var context = new ModelAndContext.EntityContext())
            {
                //4
                context.TvContracts.Add(new ModelAndContext.TvContract()
                {
                    Months = 4
                });
                context.TvContracts.Add(new ModelAndContext.TvContract()
                {
                    Months = 4
                });
                context.TvContracts.Add(new ModelAndContext.TvContract()
                {
                    Months = 4
                });
                context.TvContracts.Add(new ModelAndContext.TvContract()
                {
                    Months = 4
                });

                //4
                context.MobileContracts.Add(new ModelAndContext.MobileContract()
                {
                    Months = 3, MobileNumber = "4524"
                });
                context.MobileContracts.Add(new ModelAndContext.MobileContract()
                {
                    Months = 3, MobileNumber = "4524"
                });
                context.MobileContracts.Add(new ModelAndContext.MobileContract()
                {
                    Months = 3, MobileNumber = "4524"
                });
                context.MobileContracts.Add(new ModelAndContext.MobileContract()
                {
                    Months = 3, MobileNumber = "4524"
                });

                //8
                context.BroadbandContracts.Add(new ModelAndContext.BroadbandContract()
                {
                    Months = 6, DownloadSpeed = 50
                });
                context.BroadbandContracts.Add(new ModelAndContext.BroadbandContract()
                {
                    DownloadSpeed = 52
                });
                context.BroadbandContracts.Add(new ModelAndContext.BroadbandContract()
                {
                    Months = 6, DownloadSpeed = 50
                });
                context.BroadbandContracts.Add(new ModelAndContext.BroadbandContract()
                {
                    DownloadSpeed = 52
                });
                context.BroadbandContracts.Add(new ModelAndContext.BroadbandContract()
                {
                    Months = 6, DownloadSpeed = 50
                });
                context.BroadbandContracts.Add(new ModelAndContext.BroadbandContract()
                {
                    DownloadSpeed = 52
                });
                context.BroadbandContracts.Add(new ModelAndContext.BroadbandContract()
                {
                    Months = 6, DownloadSpeed = 50
                });
                context.BroadbandContracts.Add(new ModelAndContext.BroadbandContract()
                {
                    DownloadSpeed = 51
                });


                context.SaveChanges();
            }

            var now = DateTime.Now;

            using (var context = new ModelAndContext.EntityContext())
            {
                context.Contracts.Update(x => new ModelAndContext.BroadbandContract {
                    StartDate = now
                });
            }

            using (var context = new ModelAndContext.EntityContext())
            {
                Assert.AreEqual(context.Contracts.Where(x => x.StartDate == now).ToList().Count, 8);
                Assert.AreEqual(context.TvContracts.Where(x => x.StartDate == now).ToList().Count, 0);
                Assert.AreEqual(context.MobileContracts.Where(x => x.StartDate == now).ToList().Count, 0);
                Assert.AreEqual(context.BroadbandContracts.Where(x => x.StartDate == now).ToList().Count, 8);
            }
        }
コード例 #12
0
        public void BatchUpdateDelete_TPH_1()
        {
            cleannup();

            // SEED
            using (var context = new ModelAndContext.EntityContext())
            {
                //4
                context.TvContracts.Add(new ModelAndContext.TvContract()
                {
                    Months = 4
                });
                context.TvContracts.Add(new ModelAndContext.TvContract()
                {
                    Months = 4
                });
                context.TvContracts.Add(new ModelAndContext.TvContract()
                {
                    Months = 4
                });
                context.TvContracts.Add(new ModelAndContext.TvContract()
                {
                    Months = 4
                });

                //4
                context.MobileContracts.Add(new ModelAndContext.MobileContract()
                {
                    Months = 3, MobileNumber = "4524"
                });
                context.MobileContracts.Add(new ModelAndContext.MobileContract()
                {
                    Months = 3, MobileNumber = "4524"
                });
                context.MobileContracts.Add(new ModelAndContext.MobileContract()
                {
                    Months = 3, MobileNumber = "4524"
                });
                context.MobileContracts.Add(new ModelAndContext.MobileContract()
                {
                    Months = 3, MobileNumber = "4524"
                });

                //8
                context.BroadbandContracts.Add(new ModelAndContext.BroadbandContract()
                {
                    Months = 6, DownloadSpeed = 50
                });
                context.BroadbandContracts.Add(new ModelAndContext.BroadbandContract()
                {
                    DownloadSpeed = 52
                });
                context.BroadbandContracts.Add(new ModelAndContext.BroadbandContract()
                {
                    Months = 6, DownloadSpeed = 50
                });
                context.BroadbandContracts.Add(new ModelAndContext.BroadbandContract()
                {
                    DownloadSpeed = 52
                });
                context.BroadbandContracts.Add(new ModelAndContext.BroadbandContract()
                {
                    Months = 6, DownloadSpeed = 50
                });
                context.BroadbandContracts.Add(new ModelAndContext.BroadbandContract()
                {
                    DownloadSpeed = 52
                });
                context.BroadbandContracts.Add(new ModelAndContext.BroadbandContract()
                {
                    Months = 6, DownloadSpeed = 50
                });
                context.BroadbandContracts.Add(new ModelAndContext.BroadbandContract()
                {
                    DownloadSpeed = 51
                });


                context.SaveChanges();
            }

            using (var context = new ModelAndContext.EntityContext())
            {
                context.MobileContracts.Where(x => 1 == 1).Delete();
                context.BroadbandContracts.Where(x => x.DownloadSpeed == 52).Update(y => new ModelAndContext.BroadbandContract()
                {
                    DownloadSpeed = 59
                });
            }

            using (var context = new ModelAndContext.EntityContext())
            {
                Assert.AreEqual(context.MobileContracts.ToList().Count, 0);
                Assert.AreEqual(context.BroadbandContracts.Where(x => x.DownloadSpeed == 59).ToList().Count, 3);
                Assert.AreEqual(context.TvContracts.ToList(), 4);
            }
        }