ASP.NET Community Standup - Multi-tenant ASP.NET Core Apps

Jon P. Smith, author of Entity Framework Core in Action, explains what a multi-tenant app is and then digs into the things you need to do to make a multi-tenant app using ASP.NET Core with EF Core.


00:00 Countdown
02:19 Introduction and Community Links
18:25 What are multi-tenant web applications?
21:14 Single level multi-tenant demo
29:00 Partitioning tenants with EF Core QueryFilter
38:00 Admin features: creating users and tenants
43:00 Q&A
43:00 Hierarchical multi-tenant
59:00 How to get started
1:06:30 Database sharding and connection string management
1:16:30 Scaling with Azure SQL Elastic Pools
1:19:00 Conclusion


#AspNetCore #Dotnet #EFCore

[irtazaahmedqureshi]

Great Jon P, this was really amazing to learn about the multi-tenant and how it can be an important and easy way to get started with this concept so it can add value to the SaaS product since day one.

[prlgix]

This is awesome. learned a lot. I really appreciate the intent to use framework provided essentials rather than inventing new framework. I am Sr Software Engineer and lot of times the Pull Review gets in the battle mode why not to use things that are out of the box. I will be forking the repo. Thanks for the valuable information.

[ferdyferdy]

Great content. Especially the connection string management. Really helpful.

[specex]

I've implemented a few multi-tenant apps just using Identity (and the old Membership provider). My worst nightmare was an app that allowed individual users and individual companies to co-exist, but allowed individual users to be attached as contractors to multiple companies, and the company admin had to be able to assign what I called "sub-roles" to the attached employees that gave them permissions within that specific company only, and further still, within specific assigned projects. I look forward to playing with your library!

[readerman]

What to do with lookup tables/general tables that are used in all tenants like countries/currencies?
in minute 35, the answer was to add the tables in the "else" section of the code,
but i think, if you don't make the model inherit from the interface "IDataKeyFilterReadWrite", is enough to do the requirement.

[jonchicoine]

The description at the beginning of “multi-tenant” is not that good. “Shared code” used by “multiple users” describes every app. Perhaps, in the future it would make sense to say something like “used my multiple groups of users”?

[jonchicoine]

Great informative, but damn, Jon is hard to listen too, imo. Write a new book! I’ll buy it!

[ICanSeeSharp]

Can you recommend AuthP for a blazor application?

[dotnetdevni]

Sorry but the single database per customer is best approach that way data leeks is not a issue