blob: 40b2a427a5b00e862de51698e59b7141d48d64e9 (
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
|
using System;
using DevHive.Data.Models;
using DevHive.Data.RelationModels;
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<Comment> Comments { get; set; }
protected override void OnModelCreating(ModelBuilder builder)
{
/* User */
builder.Entity<User>()
.HasKey(x => x.Id);
builder.Entity<User>()
.HasIndex(x => x.UserName)
.IsUnique();
/* Roles */
builder.Entity<User>()
.HasMany(x => x.Roles)
.WithMany(x => x.Users);
/* Friends */
builder.Entity<UserFriends>()
.HasKey(uu => new { uu.UserId, uu.FriendId });
/* Languages */
builder.Entity<Language>()
.HasKey(x => x.Id);
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<Technology>()
.HasKey(x => x.Id);
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"));
base.OnModelCreating(builder);
}
}
}
|