Database

public indigoDBContext() : base("DefaultConnection")
{
    // Enable the Intializer
    Database.SetInitializer(new indigoIntializer());
}

class indigoIntializer : CreateDatabaseIfNotExists<indigoDBContext>
{
    protected override void Seed(indigoDBContext context)
    {
        base.Seed(context);

<pre>
    // Seed the Website Adminsitrator Table
    siteAdministrators.seed(context);

    // Seed the Website Countries and States
    countries.seed(context);
    states_Provinces.seed(context);
    salesTax.seed(context);
    avatars.seed(context);
    themes.seed(context);
    paymentGateways.seed(context);
    paymentBrands.seed(context);

}

internal sealed class Configuration : DbMigrationsConfiguration<Indigo.DataAccessLayer.indigoDBContext>
{
    public Configuration()
    {
        AutomaticMigrationsEnabled = true;
    }

    protected override void Seed(Indigo.DataAccessLayer.indigoDBContext context)
    {
        base.Seed(context);

        // Seed the Website Adminsitrator Table
        siteAdministrators.seed(context);

        // Seed the Website Countries and States
        countries.seed(context);
        states_Provinces.seed(context);
        salesTax.seed(context);
        avatars.seed(context);
        themes.seed(context);
        paymentGateways.seed(context);
        paymentBrands.seed(context);
    }
}

SET @sql =N'INSERT INTO #TrackUpdatedColumnNamesFlatTable_ForTemp (TableName, ColumnName, PrimaryKeyColumnName, PrimaryKeyValue, ChangeSetId
    , TransactionId, TransactionType, CreatedBy, ModifiedBy, CreatedDate, ModifiedDate, IsSoftDelete, IsCmsActive, ColumnValueAfter)
    select ''' + @TblName + ''', ''' +  @ColName + ''', ''' +  @PKColName + '''
    , CASE WHEN ' +  @PKColName + ' IS NULL THEN '''' ELSE ' +  @PKColName + ' END, ChangeSetId, $start_lsn, CASE WHEN ($operation=1) THEN ''Delete''
    WHEN $operation=2 THEN ''Insert''
    WHEN __$operation=4 THEN ''Update''
    END TransactionType, ' + @CreatedBy + ', '+ @ModifiedBy + ', '+ @CreatedDate + ', '+ @ModifiedDate + '
    , ' + CAST(@IsDeleted AS varchar(max)) + '
    , ' + CAST(@IsCmsActive AS varchar(max)) + '
    , CASE WHEN __$operation=1 THEN NULL ELSE CAST(' + @ColName + ' AS nvarchar(max)) END<br />
    FROM [cdc].' + @cdcinstancename
    + ' WHERE CAST(sys.fn_cdc_map_lsn_to_time($start_lsn) AS DATE)=CAST(''' + @DateToTrack + ''' AS DATE)
    AND sys.fn_cdc_is_bit_set(sys.fn_cdc_get_column_ordinal(''' + @captureinstance +
    ''',''' + '' + @ColName + '''), __$update_mask) = 1
    AND __$operation IN (1, 2, 4) OPTION(OPTIMIZE FOR UNKNOWN)';

    exec sp_executesql @sql, N'@IsColumnModified int out', @IsColumnModified out

IF (@ChangeSetId IS NOT NULL)
        BEGIN           
            IF NOT EXISTS (select top 1 * from TrackUpdatedColumnNamesFlatTable where 
            ChangeSetId=@ChangeSetId AND TransactionType=@TransactionType and TableName=@TableName
            AND ColumnName=@ColumnName and PrimaryKeyColumnName=@PrimaryKeyColumnName and 
            PrimaryKeyValue=@PrimaryKeyValue)
            begin           
                INSERT INTO TrackUpdatedColumnNamesFlatTable
                   (
                   ApplicationId
                    ,ApplicationComponentId
                    ,ApplicationName
                    ,ApplicationFriendlyName
                    ,SubApplicationName
                    ,SubApplicationFriendlyName
                    ,UserId
                    ,SamAccountName
                    ,FullName
                    ,DefaultDisplayValue                
                   ,ChangeSetId
                   ,TransactionType
                   ,TableName
                   ,ColumnName
                   ,ColumnNameForDisplayValue
                   ,FriendlyColumnName
                   ,ColumnValueBefore
                   ,ColumnDisplayValueBefore
                   ,ColumnValueAfter
                   ,ColumnDisplayValueAfter
                   ,PrimaryKeyColumnName
                   ,PrimaryKeyValue
                   ,ImageBefore
                   ,ImageAfter
                   ,ChangedBy              
                   ,ChangedDate
                   ,IsSoftDelete               
                   )
                select             
                   @ApplicationId,
                    @ApplicationComponentId,
                    @ApplicationName,
                    @ApplicationFriendlyName,
                    @SubApplicationName,
                    @SubApplicationFriendlyName,
                    @UserId,
                    @SamAccountName,
                    @FullName,
                    @DefaultDisplayValue,               
                   @ChangeSetId,
                   TransactionType,
                   TableName,
                   ColumnName,
                   @ColumnNameForDisplayValue,
                   @FriendlyColumnName,
                   ColumnValueBefore,
                   @ColumnDisplayValueBefore,
                   ColumnValueAfter,
                   @ColumnDisplayValueAfter,
                   PrimaryKeyColumnName,
                   PrimaryKeyValue,
                   ImageBefore,
                   ImageAfter,
                   @FullName,
                   @AuditDate,
                   IsSoftDelete
                from #TrackUpdatedColumnNamesFlatTable where ID=@MinId 
            end
        END