Need a help to setup Multi Tenant application with Hybrid way to store the data along with Versioning

[KothariDhrumil]

Hello @JonPSmith and @akema-trebla ,

I hope you're both doing well!

First off, thank you for your amazing contributions to the community — your solutions have been incredibly helpful in shaping the foundation of my application.

@akema-trebla - – I’m currently using your clean architecture template to build the Web API backend for the application.

@JonPSmith -I’m working on a SaaS product that will have both Free and Pro versions, and I’m planning to use AuthPermissions.AspNetCore to manage multi-tenancy and permissions.

Here’s what I’m aiming to achieve:

• Free version users will be hosted in a shared (sharded) database.
• Pro version users will have dedicated databases and the ability to create multiple tenants (e.g., based on location or branches).
• Users might initially sign up for the Free plan and later upgrade to the Pro plan. I want to make this transition smooth — including database migration if necessary.
• I’d also like to support roles and permission-based access control within each tenant.

Would really appreciate your guidance or suggestions on:

1. The best way to configure hybrid database sharding with multi tenant in this scenario.
2. Handling tenant upgrades from Free to Pro efficiently.
3. Setting up tenant hierarchy and permissions using AuthP.

Thanks again for your great work and looking forward to your suggestions!

can you please guid me here ?

[JonPSmith]

Hi @KothariDhrumil,

I assume you are using Blazor for your SaaS application - correct?. If so, then you need a very different way to handing the EF Core code from my AuthPermissions.AspNetCore code. Blazor can run many tasks at the same time, which means you have to extra code to ensure EF Core has a "unit of work" when accessing a database - see this section about EF Core and Blazor which shows way you can't use "normal" EF Core code.

Because my AuthPermissions.AspNetCore code doesn't support Blazor you can't it's code, BUT you can look at AuthP's Home Page which has a list of articles and a lot of documentation. The articles explains each main feature and why it is needed, and you could create new code to work with Blazor.

I have to say that creating a Blazor version of my AuthP app is a large job! It took me a long time to create the code (see Roadmap discussions for each version and date), but it found very interesting and I learnt a lot.

[KothariDhrumil]

Hi @JonPSmith, I am not using Blazor. I am using Angular.

[JonPSmith]

Hi @KothariDhrumil,

Ah, I assumed you were using Blazor because to mentions @akema-trebla who was looking at Blazor.

I haven't used Angular, or any front-end apps, for many years, but I assume you know how to use Angular with ASP.NET Core. My AuthPermissions.AspNetCore code is designed to work with ASP.NET Core so I assume can create a front-end that links to ASP.NET Core and AuthPermissions.AspNetCore.

Sorry that I can't give you any help on Angular.

[KothariDhrumil]

Hey @JonPSmith...

No worries, I have move forward. and able to construct application with customizing you code.

initally, I used your entire code as refrence in project and then on top of that updated the code. everything was working fine. I was able to login , and setup tenant and able to insert data based on tenant.

I am done in customizing authp library. and want to use as nuget package. so generated using your multiproject and able to refer it as well.

but now I got one change in ApplicationUser (which is inheriting IdentityUser). and I want to create migration for that. but library code does not have connection string. so its throwing exception of initalization.

if I am trying to use client solution (where authp is used), then I am not finding MigrationsAssembly("AuthPermissions.SqlServer") there.

so not sure how to move ahead here !

[JonPSmith]

Hi @KothariDhrumil,

Could you give me a more details on what isn't working for you. You say that you can't find the AuthPermissions.SqlServer, its here - I must have missed something.

[KothariDhrumil]

@JonPSmith - Sure. First of you are amazing.

Regarding details, let me share you what I did.

Took your code. and created local nuget package using multiproject tool.

now, in another solution (where authpermissions.sqlserver does not exist), installed this package. this solution uses auth permissions.

but now, when if you want to migration in authpermission context , then you can do it in library as it does not have connection string.

and if you are trying in your own solution then it is looking for AuthPermissions.SqlServer in that project.

[JonPSmith]

Hi @KothariDhrumil,

You say that your solution doesn't have the authpermissions.sqlserver project, but AuthP needs something to define the base database to hold the AuthP's data (NOTE: if you want a different database, e.g. Oracle, then see this article).

Also you must have a connection string to link to your database (see this article).