Guest User

Untitled

a guest
Mar 13th, 2018
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.28 KB | None | 0 0
  1. CreateTable(
  2. "dbo.User",
  3. c => new
  4. {
  5. Id = c.Int(nullable: false, identity: true),
  6. FirstName = c.String(),
  7. LastName = c.String(),
  8. DateOfBirth = c.DateTime(),
  9. Username = c.String(nullable: false),
  10. Username1 = c.String(),
  11. Password = c.String(nullable: false),
  12. LastTimeLogedIn = c.DateTime(),
  13. RoleId = c.Int(nullable: false),
  14. UserGenderId = c.Int(),
  15. ChoosenTeamId = c.Int(),
  16. AdministratorTeamId = c.Int(),
  17. })
  18. .PrimaryKey(t => t.Id)
  19. .ForeignKey("dbo.UserRole", t => t.RoleId)
  20. .ForeignKey("dbo.Team", t => t.ChoosenTeamId)
  21. .ForeignKey("dbo.UserGender", t => t.UserGenderId)
  22. .Index(t => t.RoleId)
  23. .Index(t => t.UserGenderId)
  24. .Index(t => t.ChoosenTeamId);
  25.  
  26. public class UserMap : EntityTypeConfiguration<User>
  27. {
  28. public UserMap()
  29. {
  30. // Table Mappings
  31. ToTable("User");
  32.  
  33. // Primary Key
  34. HasKey(t => t.Id);
  35.  
  36. // Relationships
  37. HasRequired(t => t.Role)
  38. .WithMany(t => t.Users)
  39. .HasForeignKey(d => d.RoleId);
  40. HasOptional(t => t.UserGender)
  41. .WithMany(t => t.Users)
  42. .HasForeignKey(d => d.UserGenderId);
  43. HasOptional(t => t.Team)
  44. .WithMany(t => t.Users)
  45. .HasForeignKey(d => d.ChoosenTeamId);
  46.  
  47. // Properties
  48. Property(t => t.Id)
  49. .HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity)
  50. .HasColumnName("Id");
  51.  
  52. Property(t => t.FirstName)
  53. .HasColumnName("FirstName");
  54.  
  55. Property(t => t.LastName)
  56. .HasColumnName("LastName");
  57.  
  58. Property(t => t.DateOfBirth)
  59. .HasColumnName("DateOfBirth");
  60.  
  61. Property(t => t.Email)
  62. .IsRequired()
  63. .HasColumnName("Email");
  64.  
  65. Property(t => t.Email)
  66. .IsRequired()
  67. .HasColumnName("Username");
  68.  
  69. Property(t => t.Password)
  70. .IsRequired()
  71. .HasColumnName("Password");
  72.  
  73. Property(t => t.LastTimeLogedIn)
  74. .HasColumnName("LastTimeLogedIn");
  75.  
  76. Property(t => t.RoleId)
  77. .IsRequired()
  78. .HasColumnName("RoleId");
  79.  
  80. Property(t => t.UserGenderId)
  81. .HasColumnName("UserGenderId");
  82.  
  83. Property(t => t.ChoosenTeamId)
  84. .HasColumnName("ChoosenTeamId");
  85.  
  86. Property(t => t.AdministratorTeamId)
  87. .HasColumnName("AdministratorTeamId");
  88. }
  89. }
  90.  
  91. public class User : IUser
  92. {
  93. public int Id { get; set; }
  94. public string FirstName { get; set; }
  95. public string LastName { get; set; }
  96. public DateTime? DateOfBirth { get; set; }
  97. public string Email { get; set; }
  98. public string Username { get; set; }
  99. public string Password { get; set; }
  100. public DateTime? LastTimeLogedIn { get; set; }
  101. public int RoleId { get; set; }
  102. public virtual UserRole Role { get; set; }
  103. public int? UserGenderId { get; set; }
  104. public virtual UserGender UserGender { get; set; }
  105. public int? ChoosenTeamId { get; set; }
  106. public int? AdministratorTeamId { get; set; }
  107. public virtual Team Team { get; set; }
  108. }
Add Comment
Please, Sign In to add comment