praktiksss.cs 4.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105
  1. using System;
  2. using System.ComponentModel.DataAnnotations.Schema;
  3. using System.Data.Entity;
  4. using System.Linq;
  5. namespace praktika_2
  6. {
  7. public partial class praktiksss : DbContext
  8. {
  9. public praktiksss()
  10. : base("name=praktiksss")
  11. {
  12. }
  13. public virtual DbSet<act_repair> act_repair { get; set; }
  14. public virtual DbSet<building> building { get; set; }
  15. public virtual DbSet<category> category { get; set; }
  16. public virtual DbSet<employye> employye { get; set; }
  17. public virtual DbSet<equipment> equipment { get; set; }
  18. public virtual DbSet<ind_characteristic> ind_characteristic { get; set; }
  19. public virtual DbSet<info_move> info_move { get; set; }
  20. public virtual DbSet<material_value> material_value { get; set; }
  21. public virtual DbSet<material_value_accounting> material_value_accounting { get; set; }
  22. public virtual DbSet<material_value_pod_pechat> material_value_pod_pechat { get; set; }
  23. public virtual DbSet<organizations> organizations { get; set; }
  24. public virtual DbSet<repair> repair { get; set; }
  25. public virtual DbSet<sysdiagrams> sysdiagrams { get; set; }
  26. public virtual DbSet<tape_work> tape_work { get; set; }
  27. protected override void OnModelCreating(DbModelBuilder modelBuilder)
  28. {
  29. modelBuilder.Entity<building>()
  30. .HasMany(e => e.employye)
  31. .WithOptional(e => e.building)
  32. .HasForeignKey(e => e.id_build);
  33. modelBuilder.Entity<building>()
  34. .HasMany(e => e.info_move)
  35. .WithOptional(e => e.building)
  36. .HasForeignKey(e => e.id_build);
  37. modelBuilder.Entity<category>()
  38. .HasMany(e => e.material_value)
  39. .WithOptional(e => e.category)
  40. .HasForeignKey(e => e.id_category);
  41. modelBuilder.Entity<category>()
  42. .HasMany(e => e.material_value_pod_pechat)
  43. .WithOptional(e => e.category)
  44. .HasForeignKey(e => e.id_category);
  45. modelBuilder.Entity<employye>()
  46. .HasMany(e => e.info_move)
  47. .WithOptional(e => e.employye)
  48. .HasForeignKey(e => e.id_employye);
  49. modelBuilder.Entity<employye>()
  50. .HasMany(e => e.material_value_pod_pechat)
  51. .WithOptional(e => e.employye)
  52. .HasForeignKey(e => e.id_employye);
  53. modelBuilder.Entity<equipment>()
  54. .HasMany(e => e.material_value_pod_pechat)
  55. .WithOptional(e => e.equipment)
  56. .HasForeignKey(e => e.id_equipment);
  57. modelBuilder.Entity<info_move>()
  58. .Property(e => e.price)
  59. .HasPrecision(19, 4);
  60. modelBuilder.Entity<material_value>()
  61. .HasMany(e => e.ind_characteristic)
  62. .WithOptional(e => e.material_value)
  63. .HasForeignKey(e => e.id_material_value);
  64. modelBuilder.Entity<material_value>()
  65. .HasMany(e => e.material_value_accounting)
  66. .WithOptional(e => e.material_value)
  67. .HasForeignKey(e => e.id_material_value);
  68. modelBuilder.Entity<material_value>()
  69. .HasMany(e => e.material_value_pod_pechat)
  70. .WithOptional(e => e.material_value)
  71. .HasForeignKey(e => e.id_material_value);
  72. modelBuilder.Entity<material_value_accounting>()
  73. .Property(e => e.price)
  74. .HasPrecision(19, 4);
  75. modelBuilder.Entity<material_value_pod_pechat>()
  76. .Property(e => e.price)
  77. .HasPrecision(19, 4);
  78. modelBuilder.Entity<organizations>()
  79. .HasMany(e => e.material_value_accounting)
  80. .WithOptional(e => e.organizations)
  81. .HasForeignKey(e => e.id_organization);
  82. modelBuilder.Entity<tape_work>()
  83. .HasMany(e => e.repair)
  84. .WithOptional(e => e.tape_work)
  85. .HasForeignKey(e => e.id_type_repair);
  86. }
  87. }
  88. }