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

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.