cs11dotnet7/vscode/PracticalApps/Northwind.Common.EntityModels.Sqlite/OrderDetail.cs

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using Microsoft.EntityFrameworkCore;

namespace Packt.Shared
{
  [Table("Order Details")]
  [Index("OrderId", Name = "OrderId")]
  [Index("OrderId", Name = "OrdersOrder_Details")]
  [Index("ProductId", Name = "ProductId")]
  [Index("ProductId", Name = "ProductsOrder_Details")]
  public partial class OrderDetail
  {
    [Key]
    [Column(TypeName = "int")]
    public int OrderId { get; set; }

    [Key]
    [Column(TypeName = "int")]
    public int ProductId { get; set; }

    [Column(TypeName = "money")]
    public decimal? UnitPrice { get; set; } = null!;

    [Column(TypeName = "smallint")]
    public short Quantity { get; set; }

    [Column(TypeName = "real")]
    public double Discount { get; set; }

    [ForeignKey("OrderId")]
    [InverseProperty("OrderDetails")]
    public virtual Order Order { get; set; } = null!;

    [ForeignKey("ProductId")]
    [InverseProperty("OrderDetails")]
    public virtual Product Product { get; set; } = null!;
  }
}