iammukeshm / multitenancy-aspnet-core Goto Github PK

{
  "Logging": {
	  "LogLevel": {
      "Default": "Information",
      "Microsoft.AspNetCore": "Warning"
    }
  },
  "AllowedHosts": "*",
  "TenantSettings": {
    "Defaults": {
      "DBProvider": "mssql",
      "ConnectionString": "Server=192.168.0.78,1435;Database=tenant_SharedDB;User Id=sa;Password=***;"
    },
    "Tenants": [
      {
        "Name": "bronze",
        "TenantId": "bronze",
        "ConnectionString": "Server=192.168.0.78,1435;Database=tenant_BronzeTenantDB;User Id=sa;Password=***;"
      },
      {
        "Name": "silver",
        "TenantId": "silver",
        "ConnectionString": "Server=192.168.0.78,1435;Database=tenant_SilverTenantDB;User Id=sa;Password=***;"
      },
      {
        "Name": "gold",
        "TenantId": "gold",
        "ConnectionString": "Server=192.168.0.78,1435;Database=tenant_GoldTenantDB;User Id=sa;Password=***;"
      }
    ]
  }
}

var builder = WebApplication.CreateBuilder(args);
builder.Services.AddControllers();
builder.Services.AddEndpointsApiExplorer();
builder.Services.AddHttpContextAccessor();
builder.Services.Configure<TenantSettings>(builder.Configuration.GetSection("TenantSettings"));
builder.Services.AddInfrastructureService();

await builder.Services.AddPersistenceService();

builder.Services.AddSwaggerGen();
var app = builder.Build();

if (app.Environment.IsDevelopment())
{
    app.UseSwagger();
    app.UseSwaggerUI(c =>
    {
        c.SwaggerEndpoint("/swagger/UserControllers/swagger.json", "MultiTenantWebApi - User Tables");
        c.SwaggerEndpoint("/swagger/ProductControllers/swagger.json", "MultiTenantWebApi - Product Tables");
    });
}

//app.UseHttpsRedirection();

app.UseAuthorization();

app.MapControllers();

app.Run();

public static class ServiceRegistration
{
    public static void AddInfrastructureService(this IServiceCollection collection)
    {
        collection.AddTransient<ITenantService, TenantService>();
    }

    public static async Task AddPersistenceService(this IServiceCollection collection)
    {
        collection.AddScoped<IUserService, UserService>();
        collection.AddScoped<IProductService, ProductService>();

        using var provider = collection.BuildServiceProvider();
        var configuration = provider.GetRequiredService<IConfiguration>();
        var tenantSettings = configuration.GetSection("TenantSettings").Get<TenantSettings>();

        var defaultConnectionString = tenantSettings.Defaults?.ConnectionString;
        var defaultDbProvider = tenantSettings.Defaults?.DbProvider;
        
        if (defaultDbProvider.ToLower() == "mssql")
        {
            collection.AddDbContext<SharedDbContext>(option => option.UseSqlServer(e => e.MigrationsAssembly(typeof(SharedDbContext).Assembly.FullName)));
        }

        using IServiceScope scope = collection.BuildServiceProvider().CreateScope();
        // SharedDb Migration
        var dbContext = scope.ServiceProvider.GetRequiredService<SharedDbContext>();
        dbContext.Database.SetConnectionString(defaultConnectionString);
        if (dbContext.Database.GetMigrations().Count() > 0)
            await dbContext.Database.MigrateAsync();

        if (defaultDbProvider.ToLower() == "mssql")
        {
            collection.AddDbContext<TenantDbContext>(option => option.UseSqlServer(e => e.MigrationsAssembly(typeof(TenantDbContext).Assembly.FullName)));
        }

        using IServiceScope scope2 = collection.BuildServiceProvider().CreateScope();
        foreach (var tenant in tenantSettings.Tenants)
        {
            string connectionString = tenant.ConnectionString switch
            {
                null => defaultConnectionString,
                not null => tenant.ConnectionString
            };
            var dbContext2 = scope2.ServiceProvider.GetRequiredService<TenantDbContext>();
            dbContext2.Database.SetConnectionString(connectionString);
            if (dbContext2.Database.GetMigrations().Count() > 0)
                await dbContext2.Database.MigrateAsync();
        }
    }
}

PM> Remove-Migration
Build started...
Build succeeded.
System.InvalidOperationException: A relational store has been configured without specifying either the DbConnection or connection string to use.
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.get_DbConnection()
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerDatabaseCreator.<>c__DisplayClass18_0.<Exists>b__0(DateTime giveUp)
   at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.<>c__DisplayClass12_0`2.<Execute>b__0(DbContext c, TState s)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
   at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.Execute[TState,TResult](IExecutionStrategy strategy, TState state, Func`2 operation, Func`2 verifySucceeded)
   at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.Execute[TState,TResult](IExecutionStrategy strategy, TState state, Func`2 operation)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerDatabaseCreator.Exists(Boolean retryOnNotExists)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerDatabaseCreator.Exists()
   at Microsoft.EntityFrameworkCore.Migrations.HistoryRepository.Exists()
   at Microsoft.EntityFrameworkCore.Migrations.HistoryRepository.GetAppliedMigrations()
   at Microsoft.EntityFrameworkCore.Migrations.Design.MigrationsScaffolder.RemoveMigration(String projectDir, String rootNamespace, Boolean force, String language)
   at Microsoft.EntityFrameworkCore.Design.Internal.MigrationsOperations.RemoveMigration(String contextType, Boolean force)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.RemoveMigrationImpl(String contextType, Boolean force)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.RemoveMigration.<>c__DisplayClass0_0.<.ctor>b__0()
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.<>c__DisplayClass3_0`1.<Execute>b__0()
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)
**A relational store has been configured without specifying either the DbConnection or connection string to use.**

It was not possible to find any compatible framework version
The framework 'Microsoft.AspNetCore.App', version '5.0.0' (x64) was not found.
  - The following frameworks were found:
      6.0.3 at [C:\Program Files\dotnet\shared\Microsoft.AspNetCore.App]
      7.0.0-preview.3.22178.4 at [C:\Program Files\dotnet\shared\Microsoft.AspNetCore.App]

You can resolve the problem by installing the specified framework and/or SDK.

The specified framework can be found at:
  - https://aka.ms/dotnet-core-applaunch?framework=Microsoft.AspNetCore.App&framework_version=5.0.0&arch=x64&rid=win10-x64

D:\github\multitenancy-aspnet-core\Multitenant.Api\bin\Debug\net5.0\Multitenant.Api.exe (process 12484) exited with code -2147450730.
To automatically close the console when debugging stops, enable Tools->Options->Debugging->Automatically close the console when debugging stops.
Press any key to close this window . . .