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

54 lines
1.8 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 OrdersQry
{
[Column("OrderID")]
public int OrderId { get; set; }
[Column("CustomerID")]
[StringLength(5)]
public string? CustomerId { get; set; }
[Column("EmployeeID")]
public int? EmployeeId { 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; }
public int? ShipVia { get; set; }
[Column(TypeName = "money")]
public decimal? Freight { get; set; }
[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; }
[StringLength(40)]
public string CompanyName { 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; }
}
}