Пример #1
0
        private async Task <FindMyTutorWebContext> GetContext()
        {
            var options = new DbContextOptionsBuilder <FindMyTutorWebContext>()
                          .UseInMemoryDatabase(databaseName: "FindMyTutor_InMemory_Database")
                          .Options;
            var context = new FindMyTutorWebContext(options);

            context.Database.EnsureDeleted();
            context.Database.EnsureCreated();

            var reportedComment = new ReportedComment
            {
                Id                = 122,
                ReporterId        = "a",
                ResourceCreatorId = "b"
            };
            var reportedOffer = new ReportedOffer
            {
                Id                = 112,
                ReporterId        = "a",
                ResourceCreatorId = "n"
            };

            context.ReportedComment.Add(reportedComment);
            context.ReportedOffers.Add(reportedOffer);
            await context.SaveChangesAsync();

            return(context);
        }
        public async Task SeedAsync(FindMyTutorWebContext dbContext, IServiceProvider serviceProvider)
        {
            if (dbContext == null)
            {
                throw new ArgumentNullException(nameof(dbContext));
            }

            if (serviceProvider == null)
            {
                throw new ArgumentNullException(nameof(serviceProvider));
            }

            var logger = serviceProvider.GetService <ILoggerFactory>().CreateLogger(typeof(ApplicationDbContextSeeder));

            var seeders = new List <ISeeder>
            {
                //new RolesSeeder(),
                //new SettingsSeeder(),
            };

            foreach (var seeder in seeders)
            {
                await seeder.SeedAsync(dbContext, serviceProvider);

                await dbContext.SaveChangesAsync();

                logger.LogInformation($"Seeder {seeder.GetType().Name} done.");
            }
        }
        private FindMyTutorWebContext GetContext()
        {
            var options = new DbContextOptionsBuilder <FindMyTutorWebContext>()
                          .UseInMemoryDatabase(databaseName: "FindMyTutor_InMemory_Database")
                          .EnableSensitiveDataLogging()
                          .Options;
            var context = new FindMyTutorWebContext(options);

            return(context);
        }
Пример #4
0
        private async Task <FindMyTutorWebContext> GetContext()
        {
            var options = new DbContextOptionsBuilder <FindMyTutorWebContext>()
                          .UseInMemoryDatabase(databaseName: "FindMyTutor_InMemory_Database")
                          .Options;
            var context = new FindMyTutorWebContext(options);


            context.Comments.AddRange(comments);
            int a = await context.SaveChangesAsync();

            return(context);
        }
Пример #5
0
        //Task<int> AddOffer(OfferDTO offer);

        //Task<int> RemoveOffer(int id);

        private async Task <FindMyTutorWebContext> GetContext()
        {
            var options = new DbContextOptionsBuilder <FindMyTutorWebContext>()
                          .UseInMemoryDatabase(databaseName: "FindMyTutor_InMemory_Database")
                          .EnableSensitiveDataLogging()
                          .UseQueryTrackingBehavior(QueryTrackingBehavior.NoTracking)
                          .Options
            ;
            var context = new FindMyTutorWebContext(options);

            context.Database.EnsureDeleted();
            context.Database.EnsureCreated();

            var offers = new Offer[]
            {
                new Offer
                {
                    Id          = 72,
                    TutorId     = "a",
                    Description = "Very cool",
                    Title       = "Math lessons"
                },
                new Offer
                {
                    Id          = 22,
                    TutorId     = "b",
                    Description = "Very cool indeed",
                    Title       = "Lit lessons"
                },
                new Offer
                {
                    Id          = 32,
                    TutorId     = "a",
                    Description = "Amazing",
                    Title       = "Algebra lessons"
                },
                new Offer
                {
                    Id          = 42,
                    TutorId     = "b",
                    Description = "Ghastly",
                    Title       = "Vazov lessons"
                }
            };


            context.Offers.AddRange(offers);
            int a = await context.SaveChangesAsync();

            return(context);
        }
Пример #6
0
        private async Task <FindMyTutorWebContext> GetContext()
        {
            var options = new DbContextOptionsBuilder <FindMyTutorWebContext>()
                          .UseInMemoryDatabase(databaseName: "FindMyTutor_InMemory_Database")
                          .EnableSensitiveDataLogging()
                          .UseQueryTrackingBehavior(QueryTrackingBehavior.NoTracking)
                          .Options
            ;
            var context = new FindMyTutorWebContext(options);

            context.Database.EnsureDeleted();
            context.Database.EnsureCreated();

            var messages = new Message[]
            {
                new Message
                {
                    Id         = 72,
                    SenderId   = "a",
                    ReceiverId = "b",
                    Content    = "ab"
                },
                new Message
                {
                    Id         = 72,
                    SenderId   = "b",
                    ReceiverId = "a",
                    Content    = "absss"
                },
                new Message
                {
                    Id         = 72,
                    SenderId   = "e",
                    ReceiverId = "d",
                    Content    = "asas"
                },
                new Message
                {
                    Id         = 72,
                    SenderId   = "r",
                    ReceiverId = "e",
                    Content    = "asasa"
                },
            };


            context.Messages.AddRange(messages);
            int a = await context.SaveChangesAsync();

            return(context);
        }