creation des clé etrangere dans models dans framwork .net mvc

Question

I want to create a foreign key in the x model and how to declare?(in asp.net c#)

Muhammad Imran Ansari · Answer

Hello Samia, In ASP.NET Core (using Entity Framework Core), you can create a foreign key relationship between two models by defining the relationship in your entity classes and configuring it in the DbContext . Below is a step-by-step guide on how to declare a foreign key in your model. Example Scenario: Let's say you have two models: Order (Parent Model) OrderItem (Child Model) Each OrderItem belongs to an Order, so there is a one-to-many relationship between Order and OrderItem. Step 1: Define the Models Order Model (Parent) public class Order { public int OrderId { get; set; } // Primary Key public string OrderNumber { get; set; } public DateTime OrderDate { get; set; } // Navigation property for the related OrderItems public ICollection OrderItems { get; set; } } OrderItem Model (Child) public class OrderItem { public int OrderItemId { get; set; } // Primary Key public string ProductName { get; set; } public int Quantity { get; set; } // Foreign Key Property public int OrderId { get; set; } // Navigation property for the related Order public Order Order { get; set; } } Step 2: Configure the Foreign Key in the DbContext In your DbContext class (e.g., ApplicationDbContext), you can configure the relationship using the Fluent API in the OnModelCreating method. public class ApplicationDbContext : DbContext { public DbSet Orders { get; set; } public DbSet OrderItems { get; set; } protected override void OnModelCreating(ModelBuilder modelBuilder) { // Configure the one-to-many relationship modelBuilder.Entity () .HasMany(o => o.OrderItems) // Order has many OrderItems .WithOne(oi => oi.Order) // OrderItem belongs to one Order .HasForeignKey(oi => oi.OrderId); // Foreign key in OrderItem base.OnModelCreating(modelBuilder); } } Step 3: Migrate the Changes to the Database After defining the models and configuring the relationship, you need to create and apply a migration to update the database schema. Open the Package Manager Console (in Visual Studio). Run the following commands: Add-Migration AddOrderAndOrderItemTables Update-Database This will create the Orders and OrderItems tables in your database with the appropriate foreign key relationship. Step 4: Use the Models in Your Application You can now use the models in your application. For example, to add an Order with OrderItems: using (var context = new ApplicationDbContext()) { var order = new Order { OrderNumber = "ORD123", OrderDate = DateTime.Now, OrderItems = new List { new OrderItem { ProductName = "Product A", Quantity = 2 }, new OrderItem { ProductName = "Product B", Quantity = 1 } } }; context.Orders.Add(order); context.SaveChanges(); } Key Points: Foreign Key Property: In the OrderItem model, the OrderId property is the foreign key. Navigation Properties: The Order model has a collection of OrderItems, and the OrderItem model has a reference to its Order. Fluent API Configuration: The OnModelCreating method in the DbContext is used to configure the relationship explicitly.

creation des clé etrangere dans models dans framwork .net mvc

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (1)