blob: 621336f8892cdb60d1027af3528cf9c713b850e1 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
|
using System;
using DevHive.Data.Models;
using DevHive.Data.Models.Relational;
using Microsoft.AspNetCore.Identity.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore;
namespace DevHive.Data
{
public class DevHiveContext : IdentityDbContext<User, Role, Guid>
{
public DevHiveContext(DbContextOptions<DevHiveContext> options)
: base(options) { }
public DbSet<Technology> Technologies { get; set; }
public DbSet<Language> Languages { get; set; }
public DbSet<Post> Posts { get; set; }
public DbSet<PostAttachments> PostAttachments { get; set; }
public DbSet<Comment> Comments { get; set; }
public DbSet<Rating> Rating { get; set; }
protected override void OnModelCreating(ModelBuilder builder)
{
/* User */
builder.Entity<User>()
.HasIndex(x => x.UserName)
.IsUnique();
builder.Entity<User>()
.HasOne(x => x.ProfilePicture)
.WithOne(x => x.User)
.HasForeignKey<ProfilePicture>(x => x.UserId);
/* Roles */
builder.Entity<User>()
.HasMany(x => x.Roles)
.WithMany(x => x.Users);
/* Languages */
builder.Entity<User>()
.HasMany(x => x.Languages)
.WithMany(x => x.Users)
.UsingEntity(x => x.ToTable("LanguageUser"));
builder.Entity<Language>()
.HasMany(x => x.Users)
.WithMany(x => x.Languages)
.UsingEntity(x => x.ToTable("LanguageUser"));
/* Technologies */
builder.Entity<User>()
.HasMany(x => x.Technologies)
.WithMany(x => x.Users)
.UsingEntity(x => x.ToTable("TechnologyUser"));
builder.Entity<Technology>()
.HasMany(x => x.Users)
.WithMany(x => x.Technologies)
.UsingEntity(x => x.ToTable("TechnologyUser"));
/* Post */
builder.Entity<Post>()
.HasOne(x => x.Creator)
.WithMany(x => x.Posts);
builder.Entity<Post>()
.HasMany(x => x.Comments)
.WithOne(x => x.Post);
/* Post attachments */
builder.Entity<PostAttachments>()
.HasOne(x => x.Post)
.WithMany(x => x.Attachments);
/* Comment */
builder.Entity<Comment>()
.HasOne(x => x.Post)
.WithMany(x => x.Comments);
builder.Entity<Comment>()
.HasOne(x => x.Creator)
.WithMany(x => x.Comments);
/* Rating */
builder.Entity<Rating>()
.HasKey(x => x.Id);
builder.Entity<Rating>()
.HasOne(x => x.Post)
.WithMany(x => x.Ratings);
builder.Entity<Post>()
.HasMany(x => x.Ratings)
.WithOne(x => x.Post);
base.OnModelCreating(builder);
}
}
}
|
