Added simple User and Role DB classes, added a simple DBContext and configured it for PostgreSQL

8 files changed, 63 insertions, 18 deletions

diff --git a/ExamTemplate/Data/Class1.cs b/ExamTemplate/Data/Class1.cs
deleted file mode 100644
index 78d17f8..0000000
--- a/ExamTemplate/Data/Class1.cs
+++ /dev/null
@@ -1,8 +0,0 @@
-using System;

-

-namespace Data

-{

-    public class Class1

-    {

-    }

-}

diff --git a/ExamTemplate/Data/Data.csproj b/ExamTemplate/Data/Data.csproj
index 7be2d32..909eb58 100644
--- a/ExamTemplate/Data/Data.csproj
+++ b/ExamTemplate/Data/Data.csproj
@@ -4,8 +4,13 @@
     <ProjectReference Include="..\Common\Common.csproj" />
   </ItemGroup>

 

+  <ItemGroup>
+    <PackageReference Include="Microsoft.AspNetCore.Identity.EntityFrameworkCore" Version="5.0.5" />
+    <PackageReference Include="Microsoft.EntityFrameworkCore" Version="5.0.5" />
+  </ItemGroup>

+

   <PropertyGroup>

-    <TargetFramework>netstandard2.0</TargetFramework>

+    <TargetFramework>net5.0</TargetFramework>

   </PropertyGroup>

 

 </Project>

diff --git a/ExamTemplate/Data/Models/Role.cs b/ExamTemplate/Data/Models/Role.cs
new file mode 100644
index 0000000..94e5c48
--- /dev/null
+++ b/ExamTemplate/Data/Models/Role.cs
@@ -0,0 +1,13 @@
+using System;
+using System.Collections.Generic;
+using Microsoft.AspNetCore.Identity;
+using System.ComponentModel.DataAnnotations.Schema;
+
+namespace ExamTemplate.Data.Models
+{
+	[Table("Roles")]
+	public class Role : IdentityRole<Guid>
+	{
+		public List<User> Users { get; set; } = new List<User>();
+	}
+}
diff --git a/ExamTemplate/Data/Models/User.cs b/ExamTemplate/Data/Models/User.cs
new file mode 100644
index 0000000..0c3f4c7
--- /dev/null
+++ b/ExamTemplate/Data/Models/User.cs
@@ -0,0 +1,15 @@
+using System;
+using System.Collections.Generic;
+using Microsoft.AspNetCore.Identity;
+using System.ComponentModel.DataAnnotations.Schema;
+
+namespace ExamTemplate.Data.Models
+{
+	[Table("Users")]
+	public class User : IdentityUser<Guid>
+	{
+		public string FirstName { get; set; }
+		public string LastName { get; set; }
+		public List<Role> Roles { get; set; }
+	}
+}
diff --git a/ExamTemplate/Data/TemplateContext.cs b/ExamTemplate/Data/TemplateContext.cs
new file mode 100644
index 0000000..3a682b0
--- /dev/null
+++ b/ExamTemplate/Data/TemplateContext.cs
@@ -0,0 +1,20 @@
+using System;

+using ExamTemplate.Data.Models;

+using Microsoft.AspNetCore.Identity.EntityFrameworkCore;

+using Microsoft.EntityFrameworkCore;

+

+namespace ExamTemplate.Data

+{

+	public class TemplateContext : IdentityDbContext<User, Role, Guid>

+	{

+		public TemplateContext(DbContextOptions<TemplateContext> options)

+			: base(options) { }

+

+		protected override void OnModelCreating(ModelBuilder builder)

+		{

+			/* Custom logic here! */

+

+			base.OnModelCreating(builder);

+		}

+	}

+}

diff --git a/ExamTemplate/Web/Startup.cs b/ExamTemplate/Web/Startup.cs
index 007f311..d6635b8 100644
--- a/ExamTemplate/Web/Startup.cs
+++ b/ExamTemplate/Web/Startup.cs
@@ -1,5 +1,7 @@
+using ExamTemplate.Data;

 using Microsoft.AspNetCore.Builder;

 using Microsoft.AspNetCore.Hosting;

+using Microsoft.EntityFrameworkCore;

 using Microsoft.Extensions.Configuration;

 using Microsoft.Extensions.DependencyInjection;

 using Microsoft.Extensions.Hosting;

@@ -19,6 +21,10 @@ namespace Web
 		public void ConfigureServices(IServiceCollection services)

 		{

 			services.AddControllersWithViews();

+

+			// Database configuration

+			services.AddDbContext<TemplateContext>(options =>

+					options.UseNpgsql(this.Configuration.GetConnectionString("LocalDBConnection")));

 		}

 

 		// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.

diff --git a/ExamTemplate/Web/appsettings.Development.json b/ExamTemplate/Web/appsettings.Development.json
deleted file mode 100644
index dba68eb..0000000
--- a/ExamTemplate/Web/appsettings.Development.json
+++ /dev/null
@@ -1,9 +0,0 @@
-{
-  "Logging": {
-    "LogLevel": {
-      "Default": "Information",

-      "Microsoft": "Warning",

-      "Microsoft.Hosting.Lifetime": "Information"

-    }
-  }
-}
diff --git a/ExamTemplate/Web/appsettings.json b/ExamTemplate/Web/appsettings.json
index 81ff877..f49d9ab 100644
--- a/ExamTemplate/Web/appsettings.json
+++ b/ExamTemplate/Web/appsettings.json
@@ -1,4 +1,7 @@
 {

+  "ConnectionStrings": {

+    "LocalDBConnection": "Server=localhost;Port=5432;Database=TemplateContext;User Id=;Password=;"

+  },

   "Logging": {

     "LogLevel": {

       "Default": "Information",