loferlContext.cs 3.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102
  1. using System;
  2. using System.Collections.Generic;
  3. using Microsoft.EntityFrameworkCore;
  4. using Microsoft.EntityFrameworkCore.Metadata;
  5. namespace Rkis29
  6. {
  7. public partial class loferlContext : DbContext
  8. {
  9. public loferlContext()
  10. {
  11. }
  12. public loferlContext(DbContextOptions<loferlContext> options)
  13. : base(options)
  14. {
  15. }
  16. public virtual DbSet<Status> Statuses { get; set; } = null!;
  17. public virtual DbSet<Task> Tasks { get; set; } = null!;
  18. public virtual DbSet<User> Users { get; set; } = null!;
  19. protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
  20. {
  21. if (!optionsBuilder.IsConfigured)
  22. {
  23. optionsBuilder.UseSqlServer("Data Source=(localdb)\\mssqllocaldb; Initial Catalog=loferl;Trusted_Connection=True;");
  24. optionsBuilder.UseLazyLoadingProxies();
  25. }
  26. }
  27. protected override void OnModelCreating(ModelBuilder modelBuilder)
  28. {
  29. modelBuilder.Entity<Status>(entity =>
  30. {
  31. entity.HasKey(e => e.StatusesTaskId);
  32. entity.Property(e => e.StatusesTaskId).HasColumnName("StatusesTaskID");
  33. entity.Property(e => e.Name).HasMaxLength(50);
  34. });
  35. modelBuilder.Entity<Task>(entity =>
  36. {
  37. entity.HasKey(e => e.TasksId);
  38. entity.Property(e => e.TasksId).HasColumnName("TasksID");
  39. entity.Property(e => e.Data).HasMaxLength(50);
  40. entity.Property(e => e.Description).HasMaxLength(50);
  41. entity.Property(e => e.Name).HasMaxLength(50);
  42. entity.Property(e => e.StatusTaskId).HasColumnName("StatusTaskID");
  43. entity.Property(e => e.UserCreaterId).HasColumnName("UserCreaterID");
  44. entity.Property(e => e.UserTakerId).HasColumnName("UserTakerID");
  45. entity.HasOne(d => d.StatusTask)
  46. .WithMany(p => p.Tasks)
  47. .HasForeignKey(d => d.StatusTaskId)
  48. .OnDelete(DeleteBehavior.ClientSetNull)
  49. .HasConstraintName("FK_Tasks_Statuses");
  50. entity.HasOne(d => d.UserCreater)
  51. .WithMany(p => p.TaskUserCreaters)
  52. .HasForeignKey(d => d.UserCreaterId)
  53. .HasConstraintName("FK_Tasks_Users1");
  54. entity.HasOne(d => d.UserTaker)
  55. .WithMany(p => p.TaskUserTakers)
  56. .HasForeignKey(d => d.UserTakerId)
  57. .HasConstraintName("FK_Tasks_Users");
  58. });
  59. modelBuilder.Entity<User>(entity =>
  60. {
  61. entity.HasKey(e => e.UsersId);
  62. entity.Property(e => e.UsersId).HasColumnName("UsersID");
  63. entity.Property(e => e.FirstName).HasMaxLength(50);
  64. entity.Property(e => e.LastName).HasMaxLength(50);
  65. entity.Property(e => e.Login).HasMaxLength(50);
  66. entity.Property(e => e.Name).HasMaxLength(50);
  67. entity.Property(e => e.Password).HasMaxLength(50);
  68. entity.Property(e => e.PhonNum).HasMaxLength(12);
  69. });
  70. OnModelCreatingPartial(modelBuilder);
  71. }
  72. partial void OnModelCreatingPartial(ModelBuilder modelBuilder);
  73. }
  74. }