.NET\10_01_MVC_RMS\BLL\DAL\Db.cs

                
                    using Microsoft.EntityFrameworkCore;

namespace BLL.DAL
{
    public class Db : DbContext // Db is-an Entity Framework DbContext which will add
                                // database operations functionality to this class
    {
        // DbSet typed properties are related to the database tables for CRUD operations
        public DbSet<User> Users { get; set; } // Users table

        public DbSet<Role> Roles { get; set; } // Roles table

        public DbSet<Resource> Resources { get; set; } // Resources table

        public DbSet<UserResource> UserResources { get; set; } // UserResources table

        // Dependency (Constructor) Injection:
        // In the Program.cs file of the MVC Web Application project we will manage
        // the initialization operations of the objects of type Db which are injected
        // in other classes through their constructors (such as Service classes)
        // in the IoC (Inversion of Control) Container.
        // options parameter which for example contains the database connection string is provided
        // from the IoC Container in the Program.cs file through a delegate (options) for the AddDbContext
        // method of the builder object's services collection. Therefore the options parameter
        // is sent to the constructor of the base (parent, super in Java) class (DbContext)
        // so that we can manage database operations through our sub (child) class (Db) using the
        // connetion string provided.
        public Db(DbContextOptions options) : base(options)
        {
        }

        // We can configure about anything related to the database structure under this method if needed,
        // but for easier development we configured some in the entities using data annotations for learning purposes.
        // Our way is not recommended by SOLID Principles.
        //protected override void OnModelCreating(ModelBuilder modelBuilder)
        //{
        //}
    }
}