123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102 |
- using System;
- using System.Collections.Generic;
- using Microsoft.EntityFrameworkCore;
- using Microsoft.EntityFrameworkCore.Metadata;
- namespace Rkis29
- {
- public partial class loferlContext : DbContext
- {
- public loferlContext()
- {
- }
- public loferlContext(DbContextOptions<loferlContext> options)
- : base(options)
- {
- }
- public virtual DbSet<Status> Statuses { get; set; } = null!;
- public virtual DbSet<Task> Tasks { get; set; } = null!;
- public virtual DbSet<User> Users { get; set; } = null!;
- protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
- {
- if (!optionsBuilder.IsConfigured)
- {
- optionsBuilder.UseSqlServer("Data Source=(localdb)\\mssqllocaldb; Initial Catalog=loferl;Trusted_Connection=True;");
- optionsBuilder.UseLazyLoadingProxies();
- }
- }
- protected override void OnModelCreating(ModelBuilder modelBuilder)
- {
- modelBuilder.Entity<Status>(entity =>
- {
- entity.HasKey(e => e.StatusesTaskId);
- entity.Property(e => e.StatusesTaskId).HasColumnName("StatusesTaskID");
- entity.Property(e => e.Name).HasMaxLength(50);
- });
- modelBuilder.Entity<Task>(entity =>
- {
- entity.HasKey(e => e.TasksId);
- entity.Property(e => e.TasksId).HasColumnName("TasksID");
- entity.Property(e => e.Data).HasMaxLength(50);
- entity.Property(e => e.Description).HasMaxLength(50);
- entity.Property(e => e.Name).HasMaxLength(50);
- entity.Property(e => e.StatusTaskId).HasColumnName("StatusTaskID");
- entity.Property(e => e.UserCreaterId).HasColumnName("UserCreaterID");
- entity.Property(e => e.UserTakerId).HasColumnName("UserTakerID");
- entity.HasOne(d => d.StatusTask)
- .WithMany(p => p.Tasks)
- .HasForeignKey(d => d.StatusTaskId)
- .OnDelete(DeleteBehavior.ClientSetNull)
- .HasConstraintName("FK_Tasks_Statuses");
- entity.HasOne(d => d.UserCreater)
- .WithMany(p => p.TaskUserCreaters)
- .HasForeignKey(d => d.UserCreaterId)
- .HasConstraintName("FK_Tasks_Users1");
- entity.HasOne(d => d.UserTaker)
- .WithMany(p => p.TaskUserTakers)
- .HasForeignKey(d => d.UserTakerId)
- .HasConstraintName("FK_Tasks_Users");
- });
- modelBuilder.Entity<User>(entity =>
- {
- entity.HasKey(e => e.UsersId);
- entity.Property(e => e.UsersId).HasColumnName("UsersID");
- entity.Property(e => e.FirstName).HasMaxLength(50);
- entity.Property(e => e.LastName).HasMaxLength(50);
- entity.Property(e => e.Login).HasMaxLength(50);
- entity.Property(e => e.Name).HasMaxLength(50);
- entity.Property(e => e.Password).HasMaxLength(50);
- entity.Property(e => e.PhonNum).HasMaxLength(12);
- });
- OnModelCreatingPartial(modelBuilder);
- }
- partial void OnModelCreatingPartial(ModelBuilder modelBuilder);
- }
- }
|