Can I create tenant DB using ASP.NET MVC application in azure ?

Question

0.00/5 (No votes)

See more:

I have done a Multi-tenancy application with a Separate database for separate Tenants. I have a problem with DB creation. 
If we get a new client, how do we create the DB? 
will we create DB Manually?
How do we alter the scripts? execute the script for all tenant DB manually? 

can we automate this? 

Please, anybody, have solutions or ideas for this Please share with me.

What I have tried:

I tried this using ado.net for Dynamic DB  creation. This concept did not work in the azure servers.   we can create dynamically only in Development system.

Posted 23-Sep-21 0:41am

Member 13093203

Updated 23-Sep-21 20:27pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

lmoelleb · Answer 1 · 2021-09-23T20:27:00

There is a REST API available for Azure. For the database specific part, look here:
Azure SQL Database REST API reference | Microsoft Docs[^]

You also have a dotnet sdk. I found this example with a quick google search, so I do not know if it is up to date:
‘How to create an Azure SQL Database programmatically’ with less frustration · GitHub[^] - the namespaces etc in the sample should provide a starting point to find more information.

You will have to make sure your service is authenticated to create databases. I would look into Managed Identity: Managed identities for Azure resources | Microsoft Docs[^]
Then you avoid having to deal with keys that expire and other mess - but it will only work from a deployed azure service, not your dev-box. So as with everything security, it is complicated to find the least annoying way for your specific setup.