asp.net-core-mvc - ASP.NET Core 6 中播种数据的问题

Question

我目前在尝试在 ASP.NET Core 6 中植入数据时遇到问题。运行应用程序后，我在数据库中没有看到任何数据更新。下面是我的 DbInitializer.cs 和 Program.cs 代码。

这是我的 DbInitializer.cs 文件:

using e_commerce.Models;

namespace e_commerce.Data
{
    public class DataSeeder
    {
        private readonly ShopDbContext shopDbContext;

        public DataSeeder(ShopDbContext shopDbContext)
        {
            this.shopDbContext = shopDbContext; 
        }  

        public void Seed()
        {
                if (!shopDbContext.Users.Any())
                {
                    var User_List = new List<User>()
                    {
                        new User()
                        {
                            UserId = 1,
                            FirstName = "David", 
                            LastName = "D",
                            Email = "davidd.com",
                            Password = "1234"
                        },

                        new User()
                        {
                            UserId=2, 
                            FirstName = "Alex",
                            LastName = "S",
                            Email="<a href="https://stackoverflow.com/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="21404d44595261464c40484d0f424e4c" rel="noreferrer noopener nofollow">[email protected]</a>",
                            Password="1234"
                        }
                    };
                    shopDbContext.Users.AddRange(User_List);
                    shopDbContext.SaveChanges();
                }
                //Products
                List<Product_Seller> MacBook_Sellers = new List<Product_Seller>();
                Product_Seller macbook_seller_1 = new Product_Seller();
                macbook_seller_1.SellerID = 1;
                macbook_seller_1.ProductID = 1;
                Product_Seller macbook_seller_2 = new Product_Seller();
                macbook_seller_2.SellerID = 2;
                macbook_seller_2.ProductID = 1;
                MacBook_Sellers.Add(macbook_seller_1);
                MacBook_Sellers.Add(macbook_seller_2);
  // adding elements using add() method
                
                if (!shopDbContext.Products.Any())
                {
                    var Product_list = new List<Product>()
                    {
                        new Product()
                        {
                            ProductID = 1,
                            ProductName = "Macbook Pro 2022",
                            ProductImageUrl = "https://i.ibb.co/7nWnHc7/macbookpro.jpg",
                            ProductPrice = 2000.00,
                            Products_Sellers = MacBook_Sellers
                        },
                        new Product()
                        {
                            ProductID = 2, 
                            ProductName = "Dell XPS",
                            ProductImageUrl = "https://i.ibb.co/KXxJsfM/dellxps.jpg",
                            ProductPrice = 1999.00,
                            SellerID = 2
                        }

                    };
                    shopDbContext.Products.AddRange(Product_list);
                    shopDbContext.SaveChanges();

                }
                //Sellers
                List<Product_Seller> store_1_product = new List<Product_Seller>();
                Product_Seller product1 = new Product_Seller();
                product1.SellerID = 1;
                product1.ProductID = 1;
                Product_Seller product2 = new Product_Seller();
                product2.SellerID = 1;
                product2.ProductID = 2;
                store_1_product.Add(product1);
                store_1_product.Add(product2);

                if (!shopDbContext.Sellers.Any())
                {
                    var Seller_list = new List<Seller>()
                    {
                        new Seller()
                        {
                            SellerId = 1,
                            SellerFirstName = "Da",
                            SellerLastName = "Du",
                            SellerEmail = "<a href="https://stackoverflow.com/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="adcccfcec9edcac0ccc4c183cec2c0" rel="noreferrer noopener nofollow">[email protected]</a>",
                            SellerPassword = "1234",
                            SellerPhone = 1900,
                            SellerReview = 5,
                            Products_Sellers = store_1_product

                        },

                        new Seller()
                        {
                            SellerId = 2, 
                            SellerFirstName = "Ng",
                            SellerLastName = "Le",
                            SellerEmail = "<a href="https://stackoverflow.com/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="e28081868798a2858f838b8ecc818d8f" rel="noreferrer noopener nofollow">[email protected]</a>",
                            SellerPassword = "1234",
                            SellerPhone = 1800,
                            SellerReview = 5, 
                            ProductID = 1
                        }
                    } ;
                    shopDbContext.Sellers.AddRange(Seller_list);
                    shopDbContext.SaveChanges();
                }
            }
        }
}

这是我的 Program.cs 文件

using e_commerce.Data;
using Microsoft.EntityFrameworkCore;

var builder = WebApplication.CreateBuilder(args);

// Add services to the container.
var connectionString = builder.Configuration.GetConnectionString("DefaultConnectionString");
builder.Services.AddDbContext<ShopDbContext>(options => options.UseSqlServer(connectionString));
builder.Services.AddControllersWithViews();
builder.Services.AddTransient<DataSeeder>();
//can be placed among other "AddScoped" - above: var app = builder.Build();   

var app = builder.Build();

// Configure the HTTP request pipeline.
if (!app.Environment.IsDevelopment())
{
    app.UseExceptionHandler("/Home/Error");
    // The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
    app.UseHsts();
}

app.UseHttpsRedirection();
app.UseStaticFiles();

app.UseRouting();

app.UseAuthorization();

app.MapControllerRoute(
    name: "default",
    pattern: "{controller=Home}/{action=Index}/{id?}");

//seed 

app.Run();
if (args.Length == 1 && args[0].ToLower() == "seeddata")
    SeedData(app);

//Seed Data
void SeedData(IHost app)
{
    var scopedFactory = app.Services.GetService<IServiceScopeFactory>();

    using (var scope = scopedFactory.CreateScope())
    {
        var service = scope.ServiceProvider.GetService<DataSeeder>();
        service.Seed();
    }
}

感谢您的帮助。

Answer 1

我根据您的代码做了一些更改。我获取数据库中的数据。

卖家

public class Seller
    {
        public int SellerId { get; set; }

        public string SellerFirstName { get; set; }

        public string SellerLastName { get; set; }

        public string SellerEmail { get; set; }


        public string SellerPassword { get; set; }

        public int SellerPhone { get; set; }

        public int SellerReview { get; set; }

        //Relationships

        public List<Product_Seller> Products_Sellers { get; set; }
    }

产品

 public class Product
    {
        public int ProductID { get; set; }
        public string ProductName { get; set; }
        public string ProductImageUrl { get; set; }

        public double ProductPrice { get; set; }

        //Relationships

        public List<Product_Seller> Products_Sellers { get; set; }

    }

ShopDbContext

public class ShopDbContext : DbContext
    {
        public ShopDbContext(DbContextOptions<ShopDbContext> options) : base(options)
        {

        }
        public DbSet<Seller> Sellers { get; set; }

        public DbSet<Product> Products { get; set; }

        public DbSet<Product_Seller> Products_Sellers { get; set; }


        public DbSet<User> Users { get; set; }


        protected override void OnModelCreating(ModelBuilder builder)
        {
            base.OnModelCreating(builder);

            builder.Entity<Product_Seller>().HasKey(i => new { i.ProductID, i.SellerID });
        }
    }

数据播种器

 public class DataSeeder
    {
        public static void Initialize(IServiceProvider serviceProvider)
        {
            using (var shopDbContext = new ShopDbContext(
                serviceProvider.GetRequiredService<
                    DbContextOptions<ShopDbContext>>()))
            {

                if (!shopDbContext.Users.Any())
                {
                    var User_List = new List<User>()
                    {
                        new User()
                        {

                            FirstName = "David",
                            LastName = "D",
                            Email = "davidd.com",
                            Password = "1234"
                        },

                        new User()
                        {

                            FirstName = "Alex",
                            LastName = "S",
                            Email="<a href="https://stackoverflow.com/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="a2c3cec7dad1e2c5cfc3cbce8cc1cdcf" rel="noreferrer noopener nofollow">[email protected]</a>",
                            Password="1234"
                        }
                    };
                    shopDbContext.Users.AddRange(User_List);
                    shopDbContext.SaveChanges();
                }


                if (!shopDbContext.Products.Any() && !shopDbContext.Sellers.Any())
                {

                    var product1 = new Product()
                    {

                        ProductName = "Macbook Pro 2022",
                        ProductImageUrl = "https://i.ibb.co/7nWnHc7/macbookpro.jpg",
                        ProductPrice = 2000.00

                    };
                    var product2 = new Product()
                    {

                        ProductName = "Dell XPS",
                        ProductImageUrl = "https://i.ibb.co/KXxJsfM/dellxps.jpg",
                        ProductPrice = 1999.00

                    };
                    var seller1 = new Seller()
                    {

                        SellerFirstName = "Da",
                        SellerLastName = "Du",
                        SellerEmail = "<a href="https://stackoverflow.com/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="6405060700240309050d084a070b09" rel="noreferrer noopener nofollow">[email protected]</a>",
                        SellerPassword = "1234",
                        SellerPhone = 1900,
                        SellerReview = 5


                    };

                    var seller2 = new Seller()
                    {

                        SellerFirstName = "Ng",
                        SellerLastName = "Le",
                        SellerEmail = "<a href="https://stackoverflow.com/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="c6a4a5a2a3bc86a1aba7afaae8a5a9ab" rel="noreferrer noopener nofollow">[email protected]</a>",
                        SellerPassword = "1234",
                        SellerPhone = 1800,
                        SellerReview = 5

                    };


                    var pslist = new List<Product_Seller>()
            {
                new Product_Seller() { Product = product1, Seller = seller1 },
                new Product_Seller() { Product = product1, Seller = seller2 },

       
                new Product_Seller() { Product = product2, Seller = seller1 },

            };
                    shopDbContext.Products_Sellers.AddRange(pslist);

                    shopDbContext.SaveChanges();

                }
            }
        }
    }

程序

using Microsoft.EntityFrameworkCore;
using seed3Many.Data;

var builder = WebApplication.CreateBuilder(args);

// Add services to the container.
builder.Services.AddControllersWithViews();
var connectionString = builder.Configuration.GetConnectionString("DefaultConnectionString");
builder.Services.AddDbContext<ShopDbContext>(options => options.UseSqlServer(connectionString));
var app = builder.Build();
using (var scope = app.Services.CreateScope())
{
    var services = scope.ServiceProvider;

    DataSeeder.Initialize(services);
}

// Configure the HTTP request pipeline.
if (!app.Environment.IsDevelopment())
{
    app.UseExceptionHandler("/Home/Error");
    // The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
    app.UseHsts();
}

app.UseHttpsRedirection();
app.UseStaticFiles();

app.UseRouting();

app.UseAuthorization();

app.MapControllerRoute(
    name: "default",
    pattern: "{controller=Home}/{action=Index}/{id?}");

app.Run();

结果: