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

Sign in to queue

Description

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:

Tags:

Azure, Data

Day:

0

Session Type:

Pre-recorded

Code:

P522

Embed

Download

The Discussion

  • User profile image
    Mike

    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
    Paybackman

    @Mike:

     

    I was thinking the same thing. Great question. 

     

  • User profile image
    TorstenG

    @Mike:

    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