public DbFixture()
        {
            using (var context = new PartSupplierContext()) {
                //context.Database.EnsureDeleted();
                //context.Database.EnsureCreated();

                var range = context.TestJsons.Where(r => r.ProjectName == "SomeProject");
                context.TestJsons.RemoveRange(range);
                context.SaveChanges();

                context.TestJsons.Add(new TestJson {
                    ProjectName = "SomeProject",
                    ClassName   = "SomeClass", MethodName = "SomeMethod", TestScenario = "1",
                    TestCase    = "A", TestFile = "Input", Json = "[1]"
                });
                context.TestJsons.Add(new TestJson {
                    ProjectName = "SomeProject",
                    ClassName   = "SomeClass", MethodName = "SomeMethod", TestScenario = "1",
                    TestCase    = "A", TestFile = "Expected", Json = "[2]"
                });
                context.TestJsons.Add(new TestJson {
                    ProjectName = "SomeProject",
                    ClassName   = "SomeClass", MethodName = "SomeMethod", TestScenario = "1",
                    TestCase    = "B", TestFile = "Input", Json = "[3]"
                });
                context.TestJsons.Add(new TestJson {
                    ProjectName = "SomeProject",
                    ClassName   = "SomeClass", MethodName = "SomeMethod", TestScenario = "1",
                    TestCase    = "B", TestFile = "Expected", Json = "[4]"
                });
                context.TestJsons.Add(new TestJson {
                    ProjectName = "SomeProject",
                    ClassName   = "SomeClass", MethodName = "SomeMethod", TestScenario = "2",
                    TestCase    = "A", TestFile = "Input", Json = "[5]"
                });
                context.TestJsons.Add(new TestJson {
                    ProjectName = "SomeProject",
                    ClassName   = "SomeClass", MethodName = "SomeMethod", TestScenario = "2",
                    TestCase    = "A", TestFile = "Expected", Json = "[6]"
                });
                context.TestJsons.Add(new TestJson {
                    ProjectName = "SomeProject",
                    ClassName   = "SomeClass", MethodName = "SomeMethod", TestScenario = "2",
                    TestCase    = "B", TestFile = "Input", Json = "[7]"
                });
                context.TestJsons.Add(new TestJson {
                    ProjectName = "SomeProject",
                    ClassName   = "SomeClass", MethodName = "SomeMethod", TestScenario = "2",
                    TestCase    = "B", TestFile = "Expected", Json = "[8]"
                });
            }
        }
Esempio n. 2
0
        public static void PopulateContext(PartSupplierContext context)
        {
            context.Parts.Add(new Part {
                PartId = 1, PartName = "Nut", Material = "Brass", Weight = 12.50, City = "London"
            });
            context.Parts.Add(new Part {
                PartId = 2, PartName = "Bolt", Material = "Brass", Weight = 27.00, City = "Paris"
            });
            context.Parts.Add(new Part {
                PartId = 3, PartName = "Screw", Material = "Stainless", Weight = 7.25, City = "Rome"
            });
            context.Parts.Add(new Part {
                PartId = 4, PartName = "Screw", Material = "Carbon", Weight = 6.75, City = "London"
            });
            context.Parts.Add(new Part {
                PartId = 5, PartName = "Washer", Material = "Chrome", Weight = 5.10, City = "Paris"
            });
            context.Parts.Add(new Part {
                PartId = 6, PartName = "Bolt", Material = "Stainless", Weight = 25.50, City = "London"
            });

            context.Suppliers.Add(new Supplier {
                SupplierId = 1, SupplierName = "Smith", Since = DateTime.Parse("2000-05-05"), City = "London"
            });
            context.Suppliers.Add(new Supplier {
                SupplierId = 2, SupplierName = "Jones", Since = DateTime.Parse("2012-10-12"), City = "Paris"
            });
            context.Suppliers.Add(new Supplier {
                SupplierId = 3, SupplierName = "Blake", Since = DateTime.Parse("1995-07-23"), City = "Paris"
            });
            context.Suppliers.Add(new Supplier {
                SupplierId = 4, SupplierName = "Clark", Since = DateTime.Parse("2006-11-03"), City = "London"
            });
            context.Suppliers.Add(new Supplier {
                SupplierId = 5, SupplierName = "Adams", Since = DateTime.Parse("1985-12-23"), City = "Athens"
            });

            context.SaveChanges();

            context.PartSuppliers.Add(new PartSupplier {
                SupplierId = 1, PartId = 1, Quantity = 300,
                Part       = context.Parts.Find(1), Supplier = context.Suppliers.Find(1)
            });
            context.PartSuppliers.Add(new PartSupplier {
                SupplierId = 2, PartId = 1, Quantity = 300,
                Part       = context.Parts.Find(1), Supplier = context.Suppliers.Find(2)
            });
            context.PartSuppliers.Add(new PartSupplier {
                SupplierId = 1, PartId = 2, Quantity = 200,
                Part       = context.Parts.Find(2), Supplier = context.Suppliers.Find(1)
            });
            context.PartSuppliers.Add(new PartSupplier {
                SupplierId = 2, PartId = 2, Quantity = 400,
                Part       = context.Parts.Find(2), Supplier = context.Suppliers.Find(2)
            });
            context.PartSuppliers.Add(new PartSupplier {
                SupplierId = 3, PartId = 2, Quantity = 200,
                Part       = context.Parts.Find(2), Supplier = context.Suppliers.Find(3)
            });
            context.PartSuppliers.Add(new PartSupplier {
                SupplierId = 4, PartId = 2, Quantity = 200,
                Part       = context.Parts.Find(2), Supplier = context.Suppliers.Find(4)
            });
            context.PartSuppliers.Add(new PartSupplier {
                SupplierId = 1, PartId = 3, Quantity = 400,
                Part       = context.Parts.Find(3), Supplier = context.Suppliers.Find(1)
            });
            context.PartSuppliers.Add(new PartSupplier {
                SupplierId = 1, PartId = 4, Quantity = 200,
                Part       = context.Parts.Find(4), Supplier = context.Suppliers.Find(1)
            });
            context.PartSuppliers.Add(new PartSupplier {
                SupplierId = 4, PartId = 4, Quantity = 300,
                Part       = context.Parts.Find(4), Supplier = context.Suppliers.Find(4)
            });
            context.PartSuppliers.Add(new PartSupplier {
                SupplierId = 1, PartId = 5, Quantity = 100,
                Part       = context.Parts.Find(5), Supplier = context.Suppliers.Find(1)
            });
            context.PartSuppliers.Add(new PartSupplier {
                SupplierId = 4, PartId = 5, Quantity = 400,
                Part       = context.Parts.Find(5), Supplier = context.Suppliers.Find(4)
            });
            context.PartSuppliers.Add(new PartSupplier {
                SupplierId = 1, PartId = 6, Quantity = 100,
                Part       = context.Parts.Find(6), Supplier = context.Suppliers.Find(1)
            });

            var PartSuppliers_PartIds = context.PartSuppliers.Select(p => p.PartId).ToList();
            var Parts_PartIds         = context.Parts.Select(p => p.PartId).ToList();


            context.SaveChanges();
        }