コード例 #1
0
        public static void Main()
        {
            var db = new ToyStoreEntities();
            db.Configuration.AutoDetectChangesEnabled = false;

            List<IEntityInsertor> insertors = new List<IEntityInsertor>();
            insertors.Add(new AgeRangeInsertor(100));
            insertors.Add(new CategoryInsertor(100));
            insertors.Add(new ManufacturerInsertor(50));
            insertors.Add(new ToyInsertor(20000));

            foreach (var insertor in insertors)
            {
                insertor.InsertEntities(db);
            }

            db.SaveChanges();
        }
コード例 #2
0
        public void InsertEntities(ToyStoreEntities db)
        {
            for (int i = 0; i < this.numberOfElementsToAdd; i++)
            {
                var country = Utilities.Instance.GenerateRandomString(10, 20);
                var name = Utilities.Instance.GenerateRandomString(5, 10);
                while (db.Manufacturers.Any(manufacturer => manufacturer.Name.Equals(name)))
                {
                    name = Utilities.Instance.GenerateRandomString(5, 10);
                }
                var newManufacturer = new Manufacturer() { Name = name, Country = country };
                db.Manufacturers.Add(newManufacturer);

                if (i % 100 >= 0)
                {
                    db.SaveChanges();
                }
            }
        }
コード例 #3
0
        public void InsertEntities(ToyStoreEntities db)
        {
            for (int i = 0; i < this.numberOfElementsToAdd; i++)
            {
                var name = Utilities.Instance.GenerateRandomString(5, 10);
                var type = Utilities.Instance.GenerateRandomString(5, 10);

                var numberOfManufacturers = db.Manufacturers.Count();
                var selectedManufacturer = db.Manufacturers.Select(manufacturer => manufacturer.Id).ToList()[Utilities.Instance.GenerateRandomInteger(0, numberOfManufacturers - 1)];
                
                var price = Utilities.Instance.GenerateRandomPrice(0, 100);
                var color = Utilities.Instance.GenerateRandomString(5, 10);

                var numberOfAgeRanges = db.AgeRanges.Count();
                var selectedAgeRange = db.AgeRanges.Select(ageRange => ageRange.Id).ToList()[Utilities.Instance.GenerateRandomInteger(0, numberOfAgeRanges - 1)];

                var toy = new Toy() { Name = name, Type = type, Manufacturer = selectedManufacturer, Price = price, Color = color, AgeRange = selectedAgeRange };

                var numberOfCategories = Utilities.Instance.GenerateRandomInteger(1, 3);
                var categoryIds = db.Categories.Select(category => category.Id).ToList();
                var selectedCategories = new HashSet<int>();
                while (selectedCategories.Count < numberOfCategories)
                {
                    selectedCategories.Add(categoryIds[Utilities.Instance.GenerateRandomInteger(0, categoryIds.Count - 1)]);
                }
                foreach (var id in selectedCategories)
                {
                    toy.Categories.Add(db.Categories.Find(id));
                }

                db.Toys.Add(toy);

                if (i % 100 == 0)
                {
                    db.SaveChanges();
                }
            }
        }