cs11dotnet7/vscode/PracticalApps/Northwind.Common.EntityModels.SqlServer/Invoice.cs
2022-03-13 16:17:01 +00:00

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; }
}
}