Adding Tenants Table and TenantId Field

    So, we first need a Tenants table.

    As Northwind tables already have records, we’ll define a primary tenant with ID 1, and set all existing records TenantId to it.

    DefaultDB_20170430_134800_MultiTenant.cs:

    I have created Tenants table in Default database where user tables are. Here we add 3 predefined tenants. We actually only need first one with ID 1.

    Let’s write another migration for Nortwhind database to add TenantId column to required tables:

    NorthwindDB_20160110_093500_MultiTenant.cs:

    3. namespace MultiTenancy.Migrations.NorthwindDB
    4. {
    5.     [Migration(20170430194100)]
    6.     public class NorthwindDB_20170430_194100_MultiTenant
    7.         : AutoReversingMigration
    8.     {
    9.         public override void Up()
    10.         {
    11.             Alter.Table("Employees")
    12.                 .AddColumn("TenantId").AsInt32()
    13.                     .NotNullable().WithDefaultValue(1);
    15.             Alter.Table("Categories")
    18.             Alter.Table("Customers")
    19.                 .AddColumn("TenantId").AsInt32()
    20.                     .NotNullable().WithDefaultValue(1);
    22.             Alter.Table("Shippers")
    23.                 .AddColumn("TenantId").AsInt32()
    24.                     .NotNullable().WithDefaultValue(1);
    26.             Alter.Table("Suppliers")
    27.                 .AddColumn("TenantId").AsInt32()
    28.                     .NotNullable().WithDefaultValue(1);
    30.             Alter.Table("Orders")
    33.             Alter.Table("Products")
    34.                 .AddColumn("TenantId").AsInt32()
    35.                     .NotNullable().WithDefaultValue(1);
    37.             Alter.Table("Region")
    38.                 .AddColumn("TenantId").AsInt32()
    39.                     .NotNullable().WithDefaultValue(1);
    41.             Alter.Table("Territories")
    42.                 .AddColumn("TenantId").AsInt32()
    43.                     .NotNullable().WithDefaultValue(1);
    44.         }
    45.     }