MyMoviesDBContext.cs 7.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203
  1. using System;
  2. using System.Collections.Generic;
  3. using Microsoft.EntityFrameworkCore;
  4. using Microsoft.EntityFrameworkCore.Metadata;
  5. namespace MyMoviesWPF.Models
  6. {
  7. public partial class MyMoviesDBContext : DbContext
  8. {
  9. public MyMoviesDBContext()
  10. {
  11. }
  12. public MyMoviesDBContext(DbContextOptions<MyMoviesDBContext> options)
  13. : base(options)
  14. {
  15. }
  16. public virtual DbSet<Actor> Actors { get; set; } = null!;
  17. public virtual DbSet<ActorList> ActorLists { get; set; } = null!;
  18. public virtual DbSet<Genre> Genres { get; set; } = null!;
  19. public virtual DbSet<Movie> Movies { get; set; } = null!;
  20. public virtual DbSet<Order> Orders { get; set; } = null!;
  21. public virtual DbSet<Payment> Payments { get; set; } = null!;
  22. public virtual DbSet<User> Users { get; set; } = null!;
  23. protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
  24. {
  25. if (!optionsBuilder.IsConfigured)
  26. {
  27. #warning To protect potentially sensitive information in your connection string, you should move it out of source code. You can avoid scaffolding the connection string by using the Name= syntax to read it from configuration - see https://go.microsoft.com/fwlink/?linkid=2131148. For more guidance on storing connection strings, see http://go.microsoft.com/fwlink/?LinkId=723263.
  28. //optionsBuilder.UseSqlServer("Data Source=(localdb)\\MSSQLLocalDB;Database=MyMoviesDB; Integrated Security=True;");
  29. optionsBuilder.UseSqlServer("Server = mssql; Database = gr602_horse; Trusted_Connection = True;");
  30. }
  31. }
  32. protected override void OnModelCreating(ModelBuilder modelBuilder)
  33. {
  34. modelBuilder.Entity<Actor>(entity =>
  35. {
  36. entity.HasKey(e => e.Idactor);
  37. entity.Property(e => e.Idactor).HasColumnName("IDActor");
  38. entity.Property(e => e.BirthDate).HasColumnType("date");
  39. entity.Property(e => e.Country).HasMaxLength(50);
  40. entity.Property(e => e.Name).HasMaxLength(50);
  41. });
  42. modelBuilder.Entity<ActorList>(entity =>
  43. {
  44. entity.HasKey(e => e.IdactorList);
  45. entity.ToTable("ActorList");
  46. entity.Property(e => e.IdactorList)
  47. .ValueGeneratedNever()
  48. .HasColumnName("IDActorList");
  49. entity.Property(e => e.Idactor).HasColumnName("IDActor");
  50. entity.HasOne(d => d.IdactorNavigation)
  51. .WithMany(p => p.ActorLists)
  52. .HasForeignKey(d => d.Idactor)
  53. .OnDelete(DeleteBehavior.ClientSetNull)
  54. .HasConstraintName("FK_ActorList_Actors1");
  55. });
  56. modelBuilder.Entity<Genre>(entity =>
  57. {
  58. entity.HasKey(e => e.Idgenre);
  59. entity.Property(e => e.Idgenre).HasColumnName("IDGenre");
  60. entity.Property(e => e.Name).HasMaxLength(50);
  61. });
  62. modelBuilder.Entity<Movie>(entity =>
  63. {
  64. entity.HasKey(e => e.Idmovie);
  65. entity.ToTable("Movie");
  66. entity.Property(e => e.Idmovie).HasColumnName("IDMovie");
  67. entity.Property(e => e.Description).HasMaxLength(200);
  68. entity.Property(e => e.IdactorList).HasColumnName("IDActorList");
  69. entity.Property(e => e.Idgenre).HasColumnName("IDGenre");
  70. entity.Property(e => e.Idorder).HasColumnName("IDOrder");
  71. entity.Property(e => e.Languages).HasMaxLength(100);
  72. entity.Property(e => e.Name).HasMaxLength(50);
  73. entity.Property(e => e.Price).HasColumnType("money");
  74. entity.Property(e => e.ProductYear).HasColumnType("date");
  75. entity.Property(e => e.Trailer)
  76. .HasMaxLength(200)
  77. .IsFixedLength();
  78. entity.Property(e => e.Image)
  79. .HasMaxLength(200)
  80. .IsFixedLength();
  81. entity.HasOne(d => d.IdactorListNavigation)
  82. .WithMany(p => p.Movies)
  83. .HasForeignKey(d => d.IdactorList)
  84. .HasConstraintName("FK_Movie_ActorList1");
  85. entity.HasOne(d => d.IdgenreNavigation)
  86. .WithMany(p => p.Movies)
  87. .HasForeignKey(d => d.Idgenre)
  88. .HasConstraintName("FK_Movie_Genres1");
  89. entity.HasOne(d => d.IdorderNavigation)
  90. .WithMany(p => p.Movies)
  91. .HasForeignKey(d => d.Idorder)
  92. .HasConstraintName("FK_Movie_Order");
  93. });
  94. modelBuilder.Entity<Order>(entity =>
  95. {
  96. entity.HasKey(e => e.Idorder);
  97. entity.ToTable("Order");
  98. entity.Property(e => e.Idorder).HasColumnName("IDOrder");
  99. entity.Property(e => e.Date).HasColumnType("date");
  100. entity.Property(e => e.Idpayment).HasColumnName("IDPayment");
  101. entity.Property(e => e.Iduser).HasColumnName("IDUser");
  102. entity.Property(e => e.Price).HasColumnType("money");
  103. entity.Property(e => e.Status).HasMaxLength(50);
  104. entity.HasOne(d => d.IdpaymentNavigation)
  105. .WithMany(p => p.Orders)
  106. .HasForeignKey(d => d.Idpayment)
  107. .HasConstraintName("FK_Order_Payment1");
  108. entity.HasOne(d => d.IduserNavigation)
  109. .WithMany(p => p.Orders)
  110. .HasForeignKey(d => d.Iduser)
  111. .OnDelete(DeleteBehavior.ClientSetNull)
  112. .HasConstraintName("FK_Order_Users1");
  113. });
  114. modelBuilder.Entity<Payment>(entity =>
  115. {
  116. entity.HasKey(e => e.Idpayment);
  117. entity.ToTable("Payment");
  118. entity.Property(e => e.Idpayment).HasColumnName("IDPayment");
  119. entity.Property(e => e.Date).HasColumnType("date");
  120. entity.Property(e => e.PaymentType).HasMaxLength(20);
  121. entity.Property(e => e.Status).HasMaxLength(20);
  122. entity.Property(e => e.Sum).HasColumnType("money");
  123. });
  124. modelBuilder.Entity<User>(entity =>
  125. {
  126. entity.HasKey(e => e.Iduser);
  127. entity.Property(e => e.Iduser).HasColumnName("IDUser");
  128. entity.Property(e => e.EMail)
  129. .HasMaxLength(20)
  130. .IsUnicode(false)
  131. .HasColumnName("eMail");
  132. entity.Property(e => e.Login)
  133. .HasMaxLength(20)
  134. .IsUnicode(false);
  135. entity.Property(e => e.Password)
  136. .HasMaxLength(20)
  137. .IsUnicode(false);
  138. entity.Property(e => e.PhoneNumber)
  139. .HasMaxLength(15)
  140. .IsUnicode(false);
  141. });
  142. OnModelCreatingPartial(modelBuilder);
  143. }
  144. partial void OnModelCreatingPartial(ModelBuilder modelBuilder);
  145. }
  146. }