| | | 1 | | using Infrastructure.Entity; |
| | | 2 | | using Microsoft.EntityFrameworkCore; |
| | | 3 | | using Microsoft.Extensions.Logging; |
| | | 4 | | |
| | | 5 | | namespace Infrastructure.Context; |
| | | 6 | | public partial class NorthwindContext : DbContext { |
| | | 7 | | private readonly ILogger<NorthwindContext> _logger; |
| | | 8 | | public NorthwindContext(ILogger<NorthwindContext> logger, DbContextOptions<NorthwindContext> options) |
| | 8 | 9 | | : base(options) { |
| | 4 | 10 | | _logger = logger; |
| | 4 | 11 | | } |
| | | 12 | | |
| | | 13 | | #pragma warning disable IDE1006 // Naming Styles |
| | 4 | 14 | | public virtual DbSet<category> categories { get; set; } |
| | | 15 | | #pragma warning restore IDE1006 // Naming Styles |
| | | 16 | | |
| | | 17 | | #pragma warning disable IDE1006 // Naming Styles |
| | 6 | 18 | | public virtual DbSet<customer> customers { get; set; } |
| | | 19 | | #pragma warning restore IDE1006 // Naming Styles |
| | | 20 | | |
| | | 21 | | #pragma warning disable IDE1006 // Naming Styles |
| | 4 | 22 | | public virtual DbSet<customer_demographic> customer_demographics { get; set; } |
| | | 23 | | #pragma warning restore IDE1006 // Naming Styles |
| | | 24 | | |
| | | 25 | | #pragma warning disable IDE1006 // Naming Styles |
| | 6 | 26 | | public virtual DbSet<employee> employees { get; set; } |
| | | 27 | | #pragma warning restore IDE1006 // Naming Styles |
| | | 28 | | |
| | | 29 | | #pragma warning disable IDE1006 // Naming Styles |
| | 4 | 30 | | public virtual DbSet<order> orders { get; set; } |
| | | 31 | | #pragma warning restore IDE1006 // Naming Styles |
| | | 32 | | |
| | | 33 | | #pragma warning disable IDE1006 // Naming Styles |
| | 4 | 34 | | public virtual DbSet<order_detail> order_details { get; set; } |
| | | 35 | | #pragma warning restore IDE1006 // Naming Styles |
| | | 36 | | |
| | | 37 | | #pragma warning disable IDE1006 // Naming Styles |
| | 4 | 38 | | public virtual DbSet<product> products { get; set; } |
| | | 39 | | #pragma warning restore IDE1006 // Naming Styles |
| | | 40 | | |
| | | 41 | | #pragma warning disable IDE1006 // Naming Styles |
| | 4 | 42 | | public virtual DbSet<region> regions { get; set; } |
| | | 43 | | #pragma warning restore IDE1006 // Naming Styles |
| | | 44 | | |
| | | 45 | | #pragma warning disable IDE1006 // Naming Styles |
| | 4 | 46 | | public virtual DbSet<shipper> shippers { get; set; } |
| | | 47 | | #pragma warning restore IDE1006 // Naming Styles |
| | | 48 | | |
| | | 49 | | #pragma warning disable IDE1006 // Naming Styles |
| | 4 | 50 | | public virtual DbSet<supplier> suppliers { get; set; } |
| | | 51 | | #pragma warning restore IDE1006 // Naming Styles |
| | | 52 | | |
| | | 53 | | #pragma warning disable IDE1006 // Naming Styles |
| | 4 | 54 | | public virtual DbSet<territory> territories { get; set; } |
| | | 55 | | #pragma warning restore IDE1006 // Naming Styles |
| | | 56 | | |
| | | 57 | | #pragma warning disable IDE1006 // Naming Styles |
| | 4 | 58 | | public virtual DbSet<us_state> us_states { get; set; } |
| | | 59 | | #pragma warning restore IDE1006 // Naming Styles |
| | | 60 | | |
| | 1 | 61 | | protected override void OnModelCreating(ModelBuilder modelBuilder) { |
| | 2 | 62 | | modelBuilder.Entity<category>(entity => { |
| | 1 | 63 | | entity.HasKey(e => e.category_id).HasName("pk_categories"); |
| | 1 | 64 | | |
| | 1 | 65 | | entity.ToTable("categories", "northwind"); |
| | 1 | 66 | | |
| | 1 | 67 | | entity.Property(e => e.category_id).ValueGeneratedNever(); |
| | 1 | 68 | | entity.Property(e => e.category_name).HasMaxLength(15); |
| | 2 | 69 | | }); |
| | | 70 | | |
| | 2 | 71 | | modelBuilder.Entity<customer>(entity => { |
| | 1 | 72 | | entity.HasKey(e => e.customer_id).HasName("pk_customers"); |
| | 1 | 73 | | |
| | 1 | 74 | | entity.ToTable("customers", "northwind"); |
| | 1 | 75 | | |
| | 1 | 76 | | entity.Property(e => e.customer_id).HasMaxLength(5); |
| | 1 | 77 | | entity.Property(e => e.address).HasMaxLength(60); |
| | 1 | 78 | | entity.Property(e => e.city).HasMaxLength(15); |
| | 1 | 79 | | entity.Property(e => e.company_name).HasMaxLength(40); |
| | 1 | 80 | | entity.Property(e => e.contact_name).HasMaxLength(30); |
| | 1 | 81 | | entity.Property(e => e.contact_title).HasMaxLength(30); |
| | 1 | 82 | | entity.Property(e => e.country).HasMaxLength(15); |
| | 1 | 83 | | entity.Property(e => e.fax).HasMaxLength(24); |
| | 1 | 84 | | entity.Property(e => e.phone).HasMaxLength(24); |
| | 1 | 85 | | entity.Property(e => e.postal_code).HasMaxLength(10); |
| | 1 | 86 | | entity.Property(e => e.region).HasMaxLength(15); |
| | 1 | 87 | | |
| | 1 | 88 | | entity.HasMany(d => d.customer_types).WithMany(p => p.customers) |
| | 1 | 89 | | .UsingEntity<Dictionary<string, object>>( |
| | 1 | 90 | | "customer_customer_demo", |
| | 1 | 91 | | r => r.HasOne<customer_demographic>().WithMany() |
| | 1 | 92 | | .HasForeignKey("customer_type_id") |
| | 1 | 93 | | .OnDelete(DeleteBehavior.ClientSetNull) |
| | 1 | 94 | | .HasConstraintName("fk_customer_customer_demo_customer_demographics"), |
| | 1 | 95 | | l => l.HasOne<customer>().WithMany() |
| | 1 | 96 | | .HasForeignKey("customer_id") |
| | 1 | 97 | | .OnDelete(DeleteBehavior.ClientSetNull) |
| | 1 | 98 | | .HasConstraintName("fk_customer_customer_demo_customers"), |
| | 1 | 99 | | j => { |
| | 1 | 100 | | j.HasKey("customer_id", "customer_type_id").HasName("pk_customer_customer_demo"); |
| | 1 | 101 | | j.ToTable("customer_customer_demo", "northwind"); |
| | 1 | 102 | | j.IndexerProperty<string>("customer_id").HasMaxLength(5); |
| | 1 | 103 | | j.IndexerProperty<string>("customer_type_id").HasMaxLength(5); |
| | 2 | 104 | | }); |
| | 2 | 105 | | }); |
| | | 106 | | |
| | 2 | 107 | | modelBuilder.Entity<customer_demographic>(entity => { |
| | 1 | 108 | | entity.HasKey(e => e.customer_type_id).HasName("pk_customer_demographics"); |
| | 1 | 109 | | |
| | 1 | 110 | | entity.ToTable("customer_demographics", "northwind"); |
| | 1 | 111 | | |
| | 1 | 112 | | entity.Property(e => e.customer_type_id).HasMaxLength(5); |
| | 2 | 113 | | }); |
| | | 114 | | |
| | 2 | 115 | | modelBuilder.Entity<employee>(entity => { |
| | 1 | 116 | | entity.HasKey(e => e.employee_id).HasName("pk_employees"); |
| | 1 | 117 | | |
| | 1 | 118 | | entity.ToTable("employees", "northwind"); |
| | 1 | 119 | | |
| | 1 | 120 | | entity.Property(e => e.employee_id).ValueGeneratedNever(); |
| | 1 | 121 | | entity.Property(e => e.address).HasMaxLength(60); |
| | 1 | 122 | | entity.Property(e => e.city).HasMaxLength(15); |
| | 1 | 123 | | entity.Property(e => e.country).HasMaxLength(15); |
| | 1 | 124 | | entity.Property(e => e.extension).HasMaxLength(4); |
| | 1 | 125 | | entity.Property(e => e.first_name).HasMaxLength(10); |
| | 1 | 126 | | entity.Property(e => e.home_phone).HasMaxLength(24); |
| | 1 | 127 | | entity.Property(e => e.last_name).HasMaxLength(20); |
| | 1 | 128 | | entity.Property(e => e.photo_path).HasMaxLength(255); |
| | 1 | 129 | | entity.Property(e => e.postal_code).HasMaxLength(10); |
| | 1 | 130 | | entity.Property(e => e.region).HasMaxLength(15); |
| | 1 | 131 | | entity.Property(e => e.title).HasMaxLength(30); |
| | 1 | 132 | | entity.Property(e => e.title_of_courtesy).HasMaxLength(25); |
| | 1 | 133 | | |
| | 1 | 134 | | entity.HasOne(d => d.reports_toNavigation).WithMany(p => p.Inversereports_toNavigation) |
| | 1 | 135 | | .HasForeignKey(d => d.reports_to) |
| | 1 | 136 | | .HasConstraintName("fk_employees_employees"); |
| | 1 | 137 | | |
| | 1 | 138 | | entity.HasMany(d => d.territories).WithMany(p => p.employees) |
| | 1 | 139 | | .UsingEntity<Dictionary<string, object>>( |
| | 1 | 140 | | "employee_territory", |
| | 1 | 141 | | r => r.HasOne<territory>().WithMany() |
| | 1 | 142 | | .HasForeignKey("territory_id") |
| | 1 | 143 | | .OnDelete(DeleteBehavior.ClientSetNull) |
| | 1 | 144 | | .HasConstraintName("fk_employee_territories_territories"), |
| | 1 | 145 | | l => l.HasOne<employee>().WithMany() |
| | 1 | 146 | | .HasForeignKey("employee_id") |
| | 1 | 147 | | .OnDelete(DeleteBehavior.ClientSetNull) |
| | 1 | 148 | | .HasConstraintName("fk_employee_territories_employees"), |
| | 1 | 149 | | j => { |
| | 1 | 150 | | j.HasKey("employee_id", "territory_id").HasName("pk_employee_territories"); |
| | 1 | 151 | | j.ToTable("employee_territories", "northwind"); |
| | 1 | 152 | | j.IndexerProperty<string>("territory_id").HasMaxLength(20); |
| | 2 | 153 | | }); |
| | 2 | 154 | | }); |
| | | 155 | | |
| | 2 | 156 | | modelBuilder.Entity<order>(entity => { |
| | 1 | 157 | | entity.HasKey(e => e.order_id).HasName("pk_orders"); |
| | 1 | 158 | | |
| | 1 | 159 | | entity.ToTable("orders", "northwind"); |
| | 1 | 160 | | |
| | 1 | 161 | | entity.Property(e => e.order_id).ValueGeneratedNever(); |
| | 1 | 162 | | entity.Property(e => e.customer_id).HasMaxLength(5); |
| | 1 | 163 | | entity.Property(e => e.ship_address).HasMaxLength(60); |
| | 1 | 164 | | entity.Property(e => e.ship_city).HasMaxLength(15); |
| | 1 | 165 | | entity.Property(e => e.ship_country).HasMaxLength(15); |
| | 1 | 166 | | entity.Property(e => e.ship_name).HasMaxLength(40); |
| | 1 | 167 | | entity.Property(e => e.ship_postal_code).HasMaxLength(10); |
| | 1 | 168 | | entity.Property(e => e.ship_region).HasMaxLength(15); |
| | 1 | 169 | | |
| | 1 | 170 | | entity.HasOne(d => d.customer).WithMany(p => p.orders) |
| | 1 | 171 | | .HasForeignKey(d => d.customer_id) |
| | 1 | 172 | | .HasConstraintName("fk_orders_customers"); |
| | 1 | 173 | | |
| | 1 | 174 | | entity.HasOne(d => d.employee).WithMany(p => p.orders) |
| | 1 | 175 | | .HasForeignKey(d => d.employee_id) |
| | 1 | 176 | | .HasConstraintName("fk_orders_employees"); |
| | 1 | 177 | | |
| | 1 | 178 | | entity.HasOne(d => d.ship_viaNavigation).WithMany(p => p.orders) |
| | 1 | 179 | | .HasForeignKey(d => d.ship_via) |
| | 1 | 180 | | .HasConstraintName("fk_orders_shippers"); |
| | 2 | 181 | | }); |
| | | 182 | | |
| | 2 | 183 | | modelBuilder.Entity<order_detail>(entity => { |
| | 1 | 184 | | entity.HasKey(e => new { e.order_id, e.product_id }).HasName("pk_order_details"); |
| | 1 | 185 | | |
| | 1 | 186 | | entity.ToTable("order_details", "northwind"); |
| | 1 | 187 | | |
| | 1 | 188 | | entity.HasOne(d => d.order).WithMany(p => p.order_details) |
| | 1 | 189 | | .HasForeignKey(d => d.order_id) |
| | 1 | 190 | | .OnDelete(DeleteBehavior.ClientSetNull) |
| | 1 | 191 | | .HasConstraintName("fk_order_details_orders"); |
| | 1 | 192 | | |
| | 1 | 193 | | entity.HasOne(d => d.product).WithMany(p => p.order_details) |
| | 1 | 194 | | .HasForeignKey(d => d.product_id) |
| | 1 | 195 | | .OnDelete(DeleteBehavior.ClientSetNull) |
| | 1 | 196 | | .HasConstraintName("fk_order_details_products"); |
| | 2 | 197 | | }); |
| | | 198 | | |
| | 2 | 199 | | modelBuilder.Entity<product>(entity => { |
| | 1 | 200 | | entity.HasKey(e => e.product_id).HasName("pk_products"); |
| | 1 | 201 | | |
| | 1 | 202 | | entity.ToTable("products", "northwind"); |
| | 1 | 203 | | |
| | 1 | 204 | | entity.Property(e => e.product_id).ValueGeneratedNever(); |
| | 1 | 205 | | entity.Property(e => e.product_name).HasMaxLength(40); |
| | 1 | 206 | | entity.Property(e => e.quantity_per_unit).HasMaxLength(20); |
| | 1 | 207 | | |
| | 1 | 208 | | entity.HasOne(d => d.category).WithMany(p => p.products) |
| | 1 | 209 | | .HasForeignKey(d => d.category_id) |
| | 1 | 210 | | .HasConstraintName("fk_products_categories"); |
| | 1 | 211 | | |
| | 1 | 212 | | entity.HasOne(d => d.supplier).WithMany(p => p.products) |
| | 1 | 213 | | .HasForeignKey(d => d.supplier_id) |
| | 1 | 214 | | .HasConstraintName("fk_products_suppliers"); |
| | 2 | 215 | | }); |
| | | 216 | | |
| | 2 | 217 | | modelBuilder.Entity<region>(entity => { |
| | 1 | 218 | | entity.HasKey(e => e.region_id).HasName("pk_region"); |
| | 1 | 219 | | |
| | 1 | 220 | | entity.ToTable("region", "northwind"); |
| | 1 | 221 | | |
| | 1 | 222 | | entity.Property(e => e.region_id).ValueGeneratedNever(); |
| | 1 | 223 | | entity.Property(e => e.region_description).HasMaxLength(60); |
| | 2 | 224 | | }); |
| | | 225 | | |
| | 2 | 226 | | modelBuilder.Entity<shipper>(entity => { |
| | 1 | 227 | | entity.HasKey(e => e.shipper_id).HasName("pk_shippers"); |
| | 1 | 228 | | |
| | 1 | 229 | | entity.ToTable("shippers", "northwind"); |
| | 1 | 230 | | |
| | 1 | 231 | | entity.Property(e => e.shipper_id).ValueGeneratedNever(); |
| | 1 | 232 | | entity.Property(e => e.company_name).HasMaxLength(40); |
| | 1 | 233 | | entity.Property(e => e.phone).HasMaxLength(24); |
| | 2 | 234 | | }); |
| | | 235 | | |
| | 2 | 236 | | modelBuilder.Entity<supplier>(entity => { |
| | 1 | 237 | | entity.HasKey(e => e.supplier_id).HasName("pk_suppliers"); |
| | 1 | 238 | | |
| | 1 | 239 | | entity.ToTable("suppliers", "northwind"); |
| | 1 | 240 | | |
| | 1 | 241 | | entity.Property(e => e.supplier_id).ValueGeneratedNever(); |
| | 1 | 242 | | entity.Property(e => e.address).HasMaxLength(60); |
| | 1 | 243 | | entity.Property(e => e.city).HasMaxLength(15); |
| | 1 | 244 | | entity.Property(e => e.company_name).HasMaxLength(40); |
| | 1 | 245 | | entity.Property(e => e.contact_name).HasMaxLength(30); |
| | 1 | 246 | | entity.Property(e => e.contact_title).HasMaxLength(30); |
| | 1 | 247 | | entity.Property(e => e.country).HasMaxLength(15); |
| | 1 | 248 | | entity.Property(e => e.fax).HasMaxLength(24); |
| | 1 | 249 | | entity.Property(e => e.phone).HasMaxLength(24); |
| | 1 | 250 | | entity.Property(e => e.postal_code).HasMaxLength(10); |
| | 1 | 251 | | entity.Property(e => e.region).HasMaxLength(15); |
| | 2 | 252 | | }); |
| | | 253 | | |
| | 2 | 254 | | modelBuilder.Entity<territory>(entity => { |
| | 1 | 255 | | entity.HasKey(e => e.territory_id).HasName("pk_territories"); |
| | 1 | 256 | | |
| | 1 | 257 | | entity.ToTable("territories", "northwind"); |
| | 1 | 258 | | |
| | 1 | 259 | | entity.Property(e => e.territory_id).HasMaxLength(20); |
| | 1 | 260 | | entity.Property(e => e.territory_description).HasMaxLength(60); |
| | 1 | 261 | | |
| | 1 | 262 | | entity.HasOne(d => d.region).WithMany(p => p.territories) |
| | 1 | 263 | | .HasForeignKey(d => d.region_id) |
| | 1 | 264 | | .OnDelete(DeleteBehavior.ClientSetNull) |
| | 1 | 265 | | .HasConstraintName("fk_territories_region"); |
| | 2 | 266 | | }); |
| | | 267 | | |
| | 2 | 268 | | modelBuilder.Entity<us_state>(entity => { |
| | 1 | 269 | | entity.HasKey(e => e.state_id).HasName("pk_usstates"); |
| | 1 | 270 | | |
| | 1 | 271 | | entity.ToTable("us_states", "northwind"); |
| | 1 | 272 | | |
| | 1 | 273 | | entity.Property(e => e.state_id).ValueGeneratedNever(); |
| | 1 | 274 | | entity.Property(e => e.state_abbr).HasMaxLength(2); |
| | 1 | 275 | | entity.Property(e => e.state_name).HasMaxLength(100); |
| | 1 | 276 | | entity.Property(e => e.state_region).HasMaxLength(50); |
| | 2 | 277 | | }); |
| | | 278 | | |
| | | 279 | | OnModelCreatingPartial(modelBuilder); |
| | 1 | 280 | | } |
| | | 281 | | |
| | | 282 | | partial void OnModelCreatingPartial(ModelBuilder modelBuilder); |
| | | 283 | | } |