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

Answers (1)