123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105 |
- using System;
- using System.ComponentModel.DataAnnotations.Schema;
- using System.Data.Entity;
- using System.Linq;
- namespace praktika_2
- {
- public partial class praktiksss : DbContext
- {
- public praktiksss()
- : base("name=praktiksss")
- {
- }
- public virtual DbSet<act_repair> act_repair { get; set; }
- public virtual DbSet<building> building { get; set; }
- public virtual DbSet<category> category { get; set; }
- public virtual DbSet<employye> employye { get; set; }
- public virtual DbSet<equipment> equipment { get; set; }
- public virtual DbSet<ind_characteristic> ind_characteristic { get; set; }
- public virtual DbSet<info_move> info_move { get; set; }
- public virtual DbSet<material_value> material_value { get; set; }
- public virtual DbSet<material_value_accounting> material_value_accounting { get; set; }
- public virtual DbSet<material_value_pod_pechat> material_value_pod_pechat { get; set; }
- public virtual DbSet<organizations> organizations { get; set; }
- public virtual DbSet<repair> repair { get; set; }
- public virtual DbSet<sysdiagrams> sysdiagrams { get; set; }
- public virtual DbSet<tape_work> tape_work { get; set; }
- protected override void OnModelCreating(DbModelBuilder modelBuilder)
- {
- modelBuilder.Entity<building>()
- .HasMany(e => e.employye)
- .WithOptional(e => e.building)
- .HasForeignKey(e => e.id_build);
- modelBuilder.Entity<building>()
- .HasMany(e => e.info_move)
- .WithOptional(e => e.building)
- .HasForeignKey(e => e.id_build);
- modelBuilder.Entity<category>()
- .HasMany(e => e.material_value)
- .WithOptional(e => e.category)
- .HasForeignKey(e => e.id_category);
- modelBuilder.Entity<category>()
- .HasMany(e => e.material_value_pod_pechat)
- .WithOptional(e => e.category)
- .HasForeignKey(e => e.id_category);
- modelBuilder.Entity<employye>()
- .HasMany(e => e.info_move)
- .WithOptional(e => e.employye)
- .HasForeignKey(e => e.id_employye);
- modelBuilder.Entity<employye>()
- .HasMany(e => e.material_value_pod_pechat)
- .WithOptional(e => e.employye)
- .HasForeignKey(e => e.id_employye);
- modelBuilder.Entity<equipment>()
- .HasMany(e => e.material_value_pod_pechat)
- .WithOptional(e => e.equipment)
- .HasForeignKey(e => e.id_equipment);
- modelBuilder.Entity<info_move>()
- .Property(e => e.price)
- .HasPrecision(19, 4);
- modelBuilder.Entity<material_value>()
- .HasMany(e => e.ind_characteristic)
- .WithOptional(e => e.material_value)
- .HasForeignKey(e => e.id_material_value);
- modelBuilder.Entity<material_value>()
- .HasMany(e => e.material_value_accounting)
- .WithOptional(e => e.material_value)
- .HasForeignKey(e => e.id_material_value);
- modelBuilder.Entity<material_value>()
- .HasMany(e => e.material_value_pod_pechat)
- .WithOptional(e => e.material_value)
- .HasForeignKey(e => e.id_material_value);
- modelBuilder.Entity<material_value_accounting>()
- .Property(e => e.price)
- .HasPrecision(19, 4);
- modelBuilder.Entity<material_value_pod_pechat>()
- .Property(e => e.price)
- .HasPrecision(19, 4);
- modelBuilder.Entity<organizations>()
- .HasMany(e => e.material_value_accounting)
- .WithOptional(e => e.organizations)
- .HasForeignKey(e => e.id_organization);
- modelBuilder.Entity<tape_work>()
- .HasMany(e => e.repair)
- .WithOptional(e => e.tape_work)
- .HasForeignKey(e => e.id_type_repair);
- }
- }
- }
|