Rayab.ApplicationDbContext 1.1.8

Rayab ApplicationDbContext Document

Installation:

To install a Rayab.ApplicationDbContext use

Search in Package Manager

Rayab.ApplicationDbContext

Package Manager Console

Install-Package Rayab.ApplicationDbContext -Version 1.0.4

.NET CLI

dotnet add package Rayab.ApplicationDbContext --version 1.0.4

PackageReference

<PackageReference Include="Rayab.ApplicationDbContext" Version="1.0.4" />

Paket CLI

paket add Rayab.ApplicationDbContext --version 1.0.4

Why do we need this library?

By using this library, you can put your tables in a Class Library project and import the DLL file into the main project, after that, you must import this library into the main project too.

Now, you can have a Class Library for Database Tables and Main Project to work with that. You can share your project with developers for separate development, without giving them the original project.

The idea started because we wanted to easily have all the Identity settings ready for each new project in advance. But then the other ideas we described above were added so that we could create a multi-part project by several developers, all of whom use the same library table.

How To Use:

For example, create an ApplicationDbContext like this:

using Microsoft.EntityFrameworkCore;
using RApplicationDbContext;

namespace Sample
{
    public class ApplicationDbContext : RDbContext
    {
        public ApplicationDbContext(DbContextOptions<ApplicationDbContext> oprions)
            : base(oprions)
        {
        }

        // public DbSet<SomeTable> SomeTable { get; set; }
        
        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            base.OnModelCreating(modelBuilder);
        }
        
        public override int SaveChanges()
        {
            var entities = from e in ChangeTracker.Entries()
                           where e.State == EntityState.Added
                                 || e.State == EntityState.Modified
                           select e.Entity;
            foreach (var entity in entities)
            {
                var validationContext = new ValidationContext(entity);
                Validator.ValidateObject(entity, validationContext);
            }

            return base.SaveChanges();
        }
    }
}

Add this code inside startup.cs after ConfigureServices

services.AddDbContext<ApplicationDbContext>(options =>
                options.UseSqlServer(
                    Configuration.GetConnectionString("DefaultConnection")));

All you need is that, extend your class to RDbContext.

You can see the Identity Table Diagram in this image: Identity Diagram

And the Tables in SQL Database:

If you need to Identity Tables library, Refer To This Link In NuGet.