0
kansoftware created
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
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.