Entity Framework 6 - Knowledge Base (KB)

Multi-tenant SQL Server databases and parameter sniffing

I have a multi-tenant database in SQL Server 2012 where each tenant's rows are identified by a ...tenant_id... column (aka the ...Shared Database, Shared Schema... approach). Some tenants, particularly the newer ones, have very few rows, while others have...

How to filter DbContext in a multi-tenant application using Entity Framework with MVC4

I am developing a ...multi-tenant web application... using ...MVC4... and ...EF5.... I previously asked this question regarding filtering my DbContext: ...Is it bad practice to filter by ID within the repository pattern.......Apparently, my approach was s...

How to implement Multi-tenant User Login using ASP.NET Identity

I'm developing a Multi-tenant solution and I want to use the latest ...ASP.NET Identity... framework specifically the ...Entity Framework... implementation....Basically I need to allow two users to have the same username, though it must be unique within a...

Entity Framework 6 database migrations for isolated multi-tenant setup

I understand database migrations might not be the best method to deploy this solution, so any suggestions would be greatly appreciated....I have x identical database schemas, one per client....I also have models for each one of these databases and am able...

Multi Database for Multi Tenant with Code first EF 6 and ASP.Net MVC 4

I am building a SAAS application and planned for one database per client. I am using Code First EF6 with ASP.Net MVC 4....There will be 2 context i.e. MasterContext and TenantContext. User will first hit to MasterContext to authenticate user credentials a...

How to run code-first migrations to multiple tenants (separated by schemas)

We are developing a scholar system witch is a multi-tenant application using entity framework 6 MVC and ...CODE FIRST MIGRATIONS... and that's the problem, our multi tenant uses schemas (Sql server 2012+) to separate the data but all the migrations are be...