mirror of
https://github.com/markjprice/cs11dotnet7.git
synced 2025-12-06 05:32:03 +01:00
65 lines
2.2 KiB
C#
65 lines
2.2 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.ComponentModel.DataAnnotations;
|
|
using System.ComponentModel.DataAnnotations.Schema;
|
|
using Microsoft.EntityFrameworkCore;
|
|
|
|
namespace Packt.Shared
|
|
{
|
|
[Keyless]
|
|
public partial class Invoice
|
|
{
|
|
[StringLength(40)]
|
|
public string? ShipName { get; set; }
|
|
[StringLength(60)]
|
|
public string? ShipAddress { get; set; }
|
|
[StringLength(15)]
|
|
public string? ShipCity { get; set; }
|
|
[StringLength(15)]
|
|
public string? ShipRegion { get; set; }
|
|
[StringLength(10)]
|
|
public string? ShipPostalCode { get; set; }
|
|
[StringLength(15)]
|
|
public string? ShipCountry { get; set; }
|
|
[Column("CustomerID")]
|
|
[StringLength(5)]
|
|
public string? CustomerId { get; set; }
|
|
[StringLength(40)]
|
|
public string CustomerName { get; set; } = null!;
|
|
[StringLength(60)]
|
|
public string? Address { get; set; }
|
|
[StringLength(15)]
|
|
public string? City { get; set; }
|
|
[StringLength(15)]
|
|
public string? Region { get; set; }
|
|
[StringLength(10)]
|
|
public string? PostalCode { get; set; }
|
|
[StringLength(15)]
|
|
public string? Country { get; set; }
|
|
[StringLength(31)]
|
|
public string Salesperson { get; set; } = null!;
|
|
[Column("OrderID")]
|
|
public int OrderId { get; set; }
|
|
[Column(TypeName = "datetime")]
|
|
public DateTime? OrderDate { get; set; }
|
|
[Column(TypeName = "datetime")]
|
|
public DateTime? RequiredDate { get; set; }
|
|
[Column(TypeName = "datetime")]
|
|
public DateTime? ShippedDate { get; set; }
|
|
[StringLength(40)]
|
|
public string ShipperName { get; set; } = null!;
|
|
[Column("ProductID")]
|
|
public int ProductId { get; set; }
|
|
[StringLength(40)]
|
|
public string ProductName { get; set; } = null!;
|
|
[Column(TypeName = "money")]
|
|
public decimal UnitPrice { get; set; }
|
|
public short Quantity { get; set; }
|
|
public float Discount { get; set; }
|
|
[Column(TypeName = "money")]
|
|
public decimal? ExtendedPrice { get; set; }
|
|
[Column(TypeName = "money")]
|
|
public decimal? Freight { get; set; }
|
|
}
|
|
}
|