Building Multitenant SaaS Applications with Tenant Isolation and Unlimited Scale on Azure SQL Database

Sign in to queue


If you are a SaaS application developer writing multitenant applications, you often face tradeoffs between development efficiency, manageability, as well as tenant performance and security. With Azure SQL Database Elastic Database Pools and its Elastic Database capabilities, you no longer have to make that compromise. In this session, we will explore how Elastic Database Pools help you build, manage and monitor multitenant applications with tenant isolation and minimal TCO by placing each tenant in its own database.
For more information, check out this course on Microsoft Virtual Academy:


Azure, Data



Session Type:






The Discussion

  • User profile image

    Can this be used by Code-First via Entity Framework? (how would that work, or is there information you can link us to?)

  • User profile image



    I was thinking the same thing. Great question. 


  • User profile image


    there are two parts to answer your question:

    1) Connections for individual tenants use regular SQL database connections and you can use EF Code First for this and it can create the database schema for you as you connect to a new database.

    2) The external tables for cross-database querying (for horizontal or vertical partitioning) need to be created and maintained manually. But, you can query them using EF when you connect to the head node that has your external table definitions.

Add Your 2 Cents