Esempio n. 1
0
        public static void Initialize(IServiceProvider serviceProvider)
        {
            using (var context = new MvcTitleContext(
                       serviceProvider.GetRequiredService <
                           DbContextOptions <MvcTitleContext> >()))
            {
                if (context.User.Any())
                {
                    return;
                }

                var user = new User
                {
                    Name  = "Ryan",
                    Email = "*****@*****.**"
                };

                context.User.Add(user);

                context.SaveChanges();

                if (context.Title.Any())
                {
                    return;
                }

                var csvImporter = new CsvImporter();

                csvImporter.ImportTitles(context);
            }
        }
Esempio n. 2
0
        public void ImportTitles(MvcTitleContext context)
        {
            using (var reader = new StreamReader(@"C:\Users\Ryan\source\repos\MvcTitle\Models\netflix_titles.csv"))
                using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
                {
                    csv.Configuration.RegisterClassMap <TitleMap>();

                    var titles = csv.GetRecords <Title>();

                    foreach (var title in titles)
                    {
                        context.Title.Add(title);
                    }

                    context.SaveChanges();
                }
        }