This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 93%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
Hello,
I'd like to know what are my options for such scenario:
Let's say I have a multitenant application. I want to onboard new tenants from my admin GUI. Each tenant will needs it's own SQL Database deployed in Azure. After specifying things like tenant name, id, etc. and submitting the process, I want to programmatically deploy an Azure SQL Database (single or possibly in already existing elastic pool), also add some records to the Azure App Configuration (which would already exist).
What would be the best way to achieve that and what are some alternatives? I would most likely have some .NET application for handling the onboarding process.
Thanks!
Hi @Jakub Pernica
You might need to look at the Azure Resource Manager SDK for .NET.
you can find the sample here.
Regards
Geetha
Hello @GeethaThatipatri-MSFT
The .NET SDK was something I was looking at but I found the documentation for Azure .NET SDK very confusing, the documentation I found only had an API reference without any examples or anything. This GitHub link you provided might be more helpful for me with the samples, so thank you!
In your opinion, do you think using the .NET SDK would be the optimal way for my scenario? I was also thinking about using the REST API directly, as it had more examples directly in the documentation.
Jakub Pernica Thanks for your response, I would say .NET SDK. Optimal would be based on your strengths and implementation patterns:
If you are used to testing and writing for RESTful API endpoints, then the REST API is a great option.
If you are focused on using .NET libraries, then the .NET SDK is a great option.
Both should support your request, but as you mentioned the .NET SDK docs and samples are quite light.
If this answers your question, please consider accepting the answer by hitting the Accept answer as it helps the community look for answers to similar questions.
Regards
Geetha
Jakub Pernica Thank you for marking this answer as accepted. I would like to thank you for the feedback provided on the previous survey. We found that your recent engagement on this question was rated low. However, as we were able to share a good resolution to your concerns in the later answer, would you be kind to re-evaluate your feedback, rate the overall experience by taking the survey again, and provide your experience on this thread?
Regards
Geetha
Here you will find a sample multitenant SaaS application using a database per tenant model, built on Azure SQL Database. On the source code and management scripts shared on the URL, you will find that the application creates a catalog database that holds the mapping between tenants and their databases. This mapping is managed using the shard map management features of the Elastic Database Client Library, which also provides efficient connection management to the application. That is the recommended approach on a database per tenant model.
If you want, the databases can be hosted in elastic pools to provide cost-efficient and easy performance management, which leverages the unpredictable usage patterns of the tenants.
Here you will find more information about multi-tenant SaaS apps.
Thanks Alberto for your input! If I understand correctly, the provided sample application can provision new tenant DB by running PowerShell scripts, which then uses the ARM JSON Template to provision the DB, am I right?
I've come across Bicep, which should be a more simple, recommended, Azure native approach for creating templates. Would you recommend going with the Bicep for provisioning new tenants in multitenant SaaS application?
Update:
I guess Bicep might not be suitable for my use case, this guy describes basically the scenario I need:
Try that then. I hope that in the end is what you really need.