Finbuckle with multitenant crashes suddenly in .Net Aspire

[aafzal84]

I've a project using the Finbuckle with .Net Aspire and all of a sudden it crashed and threw the error The ConnectionString property has not been initialized
The exception actually being thrown from the EfCoreStore specifically from this line function =>

public virtual async Task<TTenantInfo?> TryGetByIdentifierAsync(string identifier)
  {
      try
      {
         
          return await dbContext.TenantInfo.AsNoTracking() // This line throw the error
                  .Where(ti => ti.Identifier == identifier)
                  .SingleOrDefaultAsync();
      }
      catch (Exception ex)
      {
          var message = ex.ToString();
       
          throw;
      }
     
  }

The stack trace is showing this:

System.InvalidOperationException: The ConnectionString property has not been initialized. at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions)
at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1 retry, SqlConnectionOverrides overrides) at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(CancellationToken cancellationToken) --- End of stack trace from previous location --- at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(Boolean errorsExpected, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(Boolean errorsExpected, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenAsync(CancellationToken cancellationToken, Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.<>c__DisplayClass30_02.<<ExecuteAsync>b__0>d.MoveNext() --- End of stack trace from previous location --- at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func4 operation, Func4 verifySucceeded, TState state, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func4 operation, Func4 verifySucceeded, TState state, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func4 operation, Func4 verifySucceeded, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.AsyncEnumerator.MoveNextAsync()
at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable1 asyncEnumerable, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable1 asyncEnumerable, CancellationToken cancellationToken)
at Finbuckle.MultiTenant.EntityFrameworkCore.Stores.EFCoreStore.EFCoreStore2.TryGetByIdentifierAsync(String identifier) at Finbuckle.MultiTenant.Stores.MultiTenantStoreWrapper1.TryGetByIdentifierAsync(String identifier)`

This is how I'm using the Multitenant in my program.cs

builder.Services.AddMultiTenant<Tenant>()
.WithStore<MFPEFCoreStore<TenantContext, Tenant>>(ServiceLifetime.Scoped)
.WithStrategy<MFPHostStrategy>(ServiceLifetime.Singleton, "__tenant__")
.WithPerTenantAuthentication();

Most commonly it throws the error when there are two or more tenants opened in the browser and the page refreshed

[AndrewTriesToCode]

Hi, are you still fighting this issue? I’m not an aspire expert so I don’t know if it is having any impact but generally each request would get its own dbcontext which would initialize the same each time.

Are you using context pooling or anything like that?