This is good. But it can be hectic if we have lots of tenants. Can we extend this example to store tenant data in different schemas of the same database? And How?
You would have to create a copy of every table required for your application for every new schema and be able to generate the schema/tables dynamically. That would be even more hectic.
first off all thks a lot for these tutorial... i have just one question: when i tried to POST a new product, an Microsoft.Data.SqlClient.SqlException was thrown saying that it can't insert a NULL value to TenantId Column, on Product table.... Should we add this information ( by claims for example) on Create endpoint/service? i watched your tutorial twice and could not find any diferences on our code... thanks alot!!!!
Hi, hopefully this helps... you need to have a header called tenant and provide a value, otherwise you should get an Invalid Tenant error. Set a breakpoint in the constructor of your applicationdbcontext and see if a TenantId id being set in the currentTenantService - if not your problem is in the middleware or that service. Last place the issue could be is in your SaveChanges override in dbcontext. In the video (I didnt explain this detail) save changes loops over any entity that implements IMustHaveTenant interface. Make sure your product entity is implementing that interface otherwise it wont get included in the save changes process.
If anyone still getting this error on .NET Core 8, I found the solution. When we implemented interface IMustHaveTenant on Entity, it automatically added Column in database. When we added TenantId separately, it was confused because it found two column named TenantId. I simply removed TenantId property from entity class and it saved as expected.
The only time you would resolve the tenant from a header or subdomain, is in an unauthenticated request like login. Once the user is authenticated and issued a token, the tenant key would always be read from that token (or cookie) which are imposible to modify. So in the tenant resolver middleware, you would first check to see if there is a token present and if so, obtain the tenant value from a claim in that token.
![[UNCUT] The Loyal Pin ปิ่นภักดิ์ EP.7 (1/4)](http://i.ytimg.com/vi/2rPGOyKs0VE/mqdefault.jpg)
Thank you soo much for the awesome video about Multi-Tenant.
Clear and crisp explanation.
Loved it!
Thanks everyone for learning from these videos! Your comments and feedback are very appreciated
Thanks a lot for the awesome video 👍
waiting to learn more about SaaS and Multi-Tenant.
멀티 테넌트에 대한 좋은 접근 방식에 대한 강좌. 좋은 설명입니다.
Thank you so much!!!
Deep dive tutorial 🎉 thanks efforts dude
I will just say .... wow 🤟🤟
Excellent Tutorial😊
Awesome content.. Thanks man!💯
Awesome, thanks a lot. It would be nice if there was a video for another example as well (Build a Multi-Tenant App With Multiple Databases)
There is a part 2 where multiple databases are covered, I just added the link in the description.
Thanks a lot. Best regards@@aspnano
Thanks very much
NIcee!!! Thanks for the video.
8:24 dotnet ef migrations add Initial
Great stuff - if we can see how to do this using Identity for the authentication, sign up, etc., if would make this thing AWSOME!
Thats done in the Nano boilerplate, check it out!
Thanks for the video 😊
Very nice video !
6:21 SQLServer is way slower working with a string as a primary key instead of an int.
Does this integrate with Azure AD (Entra ID) tenants?
This is good. But it can be hectic if we have lots of tenants. Can we extend this example to store tenant data in different schemas of the same database? And How?
You would have to create a copy of every table required for your application for every new schema and be able to generate the schema/tables dynamically. That would be even more hectic.
💯Thank you
first off all thks a lot for these tutorial...
i have just one question:
when i tried to POST a new product, an Microsoft.Data.SqlClient.SqlException was thrown saying that it can't insert a NULL value to TenantId Column, on Product table....
Should we add this information ( by claims for example) on Create endpoint/service?
i watched your tutorial twice and could not find any diferences on our code...
thanks alot!!!!
Hi, hopefully this helps... you need to have a header called tenant and provide a value, otherwise you should get an Invalid Tenant error. Set a breakpoint in the constructor of your applicationdbcontext and see if a TenantId id being set in the currentTenantService - if not your problem is in the middleware or that service. Last place the issue could be is in your SaveChanges override in dbcontext. In the video (I didnt explain this detail) save changes loops over any entity that implements IMustHaveTenant interface. Make sure your product entity is implementing that interface otherwise it wont get included in the save changes process.
@@aspnano i found where i made a mistake hehehehe... i left a little "break" at saveChanges switch...
tks again and waiting for more 😃
If anyone still getting this error on .NET Core 8, I found the solution. When we implemented interface IMustHaveTenant on Entity, it automatically added Column in database. When we added TenantId separately, it was confused because it found two column named TenantId.
I simply removed TenantId property from entity class and it saved as expected.
good video, but that part of creating a second db context only for resolving the tenant of the request is pretty ugly to be honest.
ngl... that second DBContext feels like a hack.
nice video! how do you prevent another tenant to use the key of someone else? are they supposed to be very difficult to find or is this a non issue?
The only time you would resolve the tenant from a header or subdomain, is in an unauthenticated request like login. Once the user is authenticated and issued a token, the tenant key would always be read from that token (or cookie) which are imposible to modify. So in the tenant resolver middleware, you would first check to see if there is a token present and if so, obtain the tenant value from a claim in that token.
@@aspnano you are right, i'm so dumb
Here is me, asking myself what the fk is a Tenant. Good vid non the less tho.