Error on another converted project:
SqlException: Invalid object name 'dbo.[Application.UserLevels]'.
Microsoft.Data.SqlClient.SqlCommand+<>c.<ExecuteDbDataReaderAsync>b__208_0(Task<SqlDataReader> result)
...
Dapper.SqlMapper.QueryAsync<T>(IDbConnection cnn, Type effectiveType, CommandDefinition command) in SqlMapper.Async.cs
SqlKata.Execution.QueryFactory.GetAsync<T>(Query query, IDbTransaction transaction, Nullable<int> timeout, CancellationToken cancellationToken)
SqlKata.Execution.QueryExtensions.GetAsync<T>(Query query, IDbTransaction transaction, Nullable<int> timeout, CancellationToken cancellationToken)
ASPNETMaker2023.Models.IQVIAeLearning+AdvancedSecurityBase.SetupUserLevels() in AdvancedSecurityBase.cs
+
UserLevel = (await tbl.GetQueryBuilder().Select($"{Config.UserLevelIdField} as Id", $"{Config.UserLevelNameField} as Name").GetAsync<UserLevel>()).ToList();
ASPNETMaker2023.Models.IQVIAeLearning+AdvancedSecurityBase.SetupUserLevel() in AdvancedSecurityBase.cs
This query is run against the DB and it fails, obviously:
SELECT [apul_in_level_id] AS [Id], [apul_vc_level_name] AS [Name] FROM [dbo].[[Application].[UserLevels]]]
We have multiple projects where we use dots in the name of the tables in order to group them logically