Manage tenant database script other than the entity for multi-database tenant specific #11759 | Support Center

kansoftware created one year ago

Currently our application is a multi tenant with single host database. But now we are switching to multi database i.e. tenant specific database. We use stored procedures, user defined functions, triggers, and so on in sql for our application.

I there a way I can manage this scripts for tenant database, so that I don't need do it manually in sql each time I create a new tenant. Also how can I maintain that for all tenant database whenever I create a new procedure.

1 Answer(s)

0

ismcagdas created one year ago
Support Team

Hi,

I think it is better to create those scripts using EF Core's Migrations. You can take a look at this blog post for a sample

https://dotnetthoughts.net/creating-stored-procs-in-efcore-migrations/

Have an answer to this question? Log in and write your answer.