Keyvan Comments - Answer Overflow

Keyvan

•Created by Keyvan on 3/5/2025 in #help

How far should i normalize my DB?

namespace Server.Models {
    public class User {
        public Guid Id { get; set; }      // UUID
        public string FirstName { get; set; }
        public string LastName { get; set; }
        public string? Password { get; set; }
        public string Email { get; set; }
        public int Verified { get; set; }
        public string Role { get; set; }
        public DateTime LastOnline { get; set; }
        public DateTime JoinedDate { get; set; }
    }
}

namespace Server.Models {
    public class User {
        public Guid Id { get; set; }      // UUID
        public string FirstName { get; set; }
        public string LastName { get; set; }
        public string? Password { get; set; }
        public string Email { get; set; }
        public int Verified { get; set; }
        public string Role { get; set; }
        public DateTime LastOnline { get; set; }
        public DateTime JoinedDate { get; set; }
    }
}

9 replies

CC#

•Created by Keyvan on 3/5/2025 in #help

How far should i normalize my DB?

using System.ComponentModel.DataAnnotations;

namespace Server.Models
{
    public sealed class Exam
    {
        public Guid ExamId { get; set; } = Guid.NewGuid();
        public string Institute { get; set; }
        public string Course { get; set; }
        public string CourseManager { get; set; }
        public int Year { get; set; }
        public string Path { get; set; }
        public string? PublicId { get; set; }

        public DateTime CreatedAt { get; set; } = DateTime.UtcNow;
        public DateTime UpdatedAt { get; set; } = DateTime.UtcNow;
        public ICollection<ExamSubmission> Submissions { get; set; } = new List<ExamSubmission>(); // one exam can have multiple submissions.
    }
}

using System.ComponentModel.DataAnnotations;

namespace Server.Models
{
    public sealed class Exam
    {
        public Guid ExamId { get; set; } = Guid.NewGuid();
        public string Institute { get; set; }
        public string Course { get; set; }
        public string CourseManager { get; set; }
        public int Year { get; set; }
        public string Path { get; set; }
        public string? PublicId { get; set; }

        public DateTime CreatedAt { get; set; } = DateTime.UtcNow;
        public DateTime UpdatedAt { get; set; } = DateTime.UtcNow;
        public ICollection<ExamSubmission> Submissions { get; set; } = new List<ExamSubmission>(); // one exam can have multiple submissions.
    }
}

9 replies

CC#

•Created by Keyvan on 3/5/2025 in #help

How far should i normalize my DB?

Here are the schemas:

namespace Server.Models
{
    public sealed class ExamAnswer
    {
        public Guid Id { get; set; } = 
Guid.NewGuid();       // UUID
        public string UserId { get; set; }      // Foreign key to user who this belongs to
        public DateTime CompletionDate { get; set; } = DateTime.UtcNow;
        public string Answer { get; set; }
        public Guid ExamId { get; set; }      // Foreign key to exam
    }
}

namespace Server.Models
{
    public sealed class ExamAnswer
    {
        public Guid Id { get; set; } = 
Guid.NewGuid();       // UUID
        public string UserId { get; set; }      // Foreign key to user who this belongs to
        public DateTime CompletionDate { get; set; } = DateTime.UtcNow;
        public string Answer { get; set; }
        public Guid ExamId { get; set; }      // Foreign key to exam
    }
}

9 replies

CC#

•Created by Keyvan on 2/17/2025 in #help

✅ Why is it common practice to reroute users to login after registering?

Thanks

27 replies

CC#

•Created by Keyvan on 2/17/2025 in #help

✅ Why is it common practice to reroute users to login after registering?

I see

27 replies

CC#

•Created by Keyvan on 2/17/2025 in #help

✅ Why is it common practice to reroute users to login after registering?

Cant i just create a session if the register is successful and proceed with the user logged in? In this way the user is logged it automatically without any redirect.

27 replies

CC#