Entity Framework Core - Knowledge Base (KB)

Entity Framework 7 Interceptor

I Have a Multi-Tenant application and how can I use Interception in Entity Framework 7?...In Entity Framework 6, exists Interception using System.Data.Entity.Infrastructure.Interception, but don't find in version 7 of the Entity Framework....Here's an exa...

Dynamically add route value parameter from database in Asp.Net Core

I'm creating multi-tenancy application, with single database per library, for example....I want to dynamically add library name to route, for example, when user trying to get all books .../Books/GetAllBooks..., I must add library name, which could be retr...

How to change connection string on command line to update database on migration to a new database in Entity Framework Core

In ASP.NET Core and EF Core Code First, I have a multi-tenant webapp. When I create a new tenant, I want to change connection string, add migration on it and then update. ...From command line, add migration can't get connection string dinamically on tenan...

EF Core 2.0.0 Query Filter is Caching TenantId (Updated for 2.0.1+)

I'm building a multi-tenant application, and am running into difficulties with what I think is EF Core caching the tenant id across requests. The only thing that seems to help is constantly rebuilding the application as I sign in and out of tenants....I t...

Multi-tenant authentication, IMustHaveTenant entity in ASP.NET Boilerplate Module Zero

Multi-Tenant Authentication...I have created a new tenant from the swagger UI as an admin and I can check in the data ...the tenant created successfully together with admin account.......Now how do I login as the admin of the newly created tenant?...Cos I...

Autofac Multitenant Database Configuration

I have a base abstract context which has a couple hundred shared objects, and then 2 "implementation" contexts which both inherit from the base and are designed to be used by different tenants in a .net core application. A tenant object is injected into ...

ef core - update composite primary key

I have several tables with composite key { Id + OrgId }. Id is provided by the user of the application, OrgId is handled by the system. I would like to set OrgId for all instances of these tables, without having to go to each repo then set OrgId manually ...

How to execute database migrations on startup when using Autofac.AspNetCore.Multitenant in .NET Core 3.x?

In single-tenanted .NET Core apps, EF Core database migrations (and DB seeding) can be executed immediately after the IHost has been built (typically in Program.cs):...await BuildHost(args) .MigrateDbContext<I.MyDbContext>() .RunAsync(); } ...sinc...

Set search_path dynamically for schema-based multi tenancy in ASP.NET Core

I'm writing a new ASP.NET Core application (.NET Core 3.1) using EF Core for database access. This application should interface with an existing PostgreSQL database that has a PostgreSQL schema for each tenant. From what I read so far, this is not the way...