spellingwords/Model.cs at master · Jackson-Henry/spellingwords · GitHub

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
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
using Microsoft.EntityFrameworkCore;
using System.Collections.Generic;

namespace ConsoleApp.SQLite
{
    public class BloggingContext : DbContext
    {
        public DbSet<Blog> Blogs { get; set; }
        public DbSet<Post> Posts { get; set; }

        public DbSet<SpellingList> SpellingLists { get; set; }
        public DbSet<SpellingTest> SpellingTests { get; set; }
        public DbSet<Answer> Answers { get; set; }
        public DbSet<SpellingWord> SpellingWords { get; set; }

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            optionsBuilder.UseSqlite("Data Source=blogging3.db");
        }
    }

    public class Blog
    {
        public int BlogId { get; set; }
        public string Url { get; set; }

        public List<Post> Posts { get; set; }
    }

    public class Post
    {
        public int PostId { get; set; }
        public string Title { get; set; }
        public string Content { get; set; }

        public int BlogId { get; set; }
        public Blog Blog { get; set; }
    }

    public class SpellingList
    {
        public int SpellingListID { get; set; }
        public string Name { get; set; }

    }

    //made a change
    public class SpellingWord
    {
        public int SpellingWordID { get; set; }
        public string Word { get; set; }
        public int SpellingListID { get; set; }

    }

    public class SpellingTest
    {
        public int SpellingTestID { get; set; }
        public string User { get; set; }
        public int SpellingListID { get; set; }
        public int Grade { get; set; }
    }


    public class Answer
    {
        public int AnswerID { get; set; }
        public string Word { get; set; }
        public int SpellingTestID { get; set; }
        public int SpellingWordID { get; set; }
        public bool Correct { get; set; }
    }


}