When I reverse engineer I now receive an error that I did not receive even a few days ago. I now get an Extension error and cannot proceed:
System.ArgumentException: Keyword not supported: 'multiple active result sets'.
at NameValuePair System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, string connectionString, bool buildChain, Hashtable synonyms, bool firstKey)
at new System.Data.Common.DbConnectionOptions(string connectionString, Hashtable synonyms, bool useOdbcRules)
at new System.Data.SqlClient.SqlConnectionString(string connectionString)
at DbConnectionOptions System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(string connectionString, DbConnectionOptions previous)
at DbConnectionPoolGroup System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, ref DbConnectionOptions userConnectionOptions)
at void System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key)
at void System.Data.SqlClient.SqlConnection.set_ConnectionString(string value)
at new System.Data.SqlClient.SqlConnection(string connectionString, SqlCredential credential)
at Tuple<bool, Version> EFCorePowerTools.Helpers.ReverseEngineerHelper.HasSqlServerViewDefinitionRightsAndVersion(string connectionString)
at void EFCorePowerTools.Handlers.ReverseEngineer.ReverseEngineerHandler.VerifySQLServerRightsAndVersion(ReverseEngineerOptions options)
at async Task EFCorePowerTools.Handlers.ReverseEngineer.ReverseEngineerHandler.ReverseEngineerCodeFirstAsync(Project project, string optionsPath, bool onlyGenerate, bool fromSqlProj)
Provide steps to reproduce
Right click on entities, select Reverse Engineer, click OK - this generates the error.
Please include a complete description or project that I can redo/run to reproduce the issue.
Provide technical details
I thought this could be addressed with the connection string but I don't seem to have visibility to that (this could totally be because I don't know power tools well enough).
EF Core version in use: (e.g. EF Core 7)
EF Core 6
Is Handlebars used: no/yes
no
Is T4 used: no/yes
no
Is .dacpac used: no/yes
no
EF Core Power Tools version: (found in About dialog - blue questionmark icon on context menu)
Describe what is not working as expected.
When I reverse engineer I now receive an error that I did not receive even a few days ago. I now get an Extension error and cannot proceed:
System.ArgumentException: Keyword not supported: 'multiple active result sets'.
at NameValuePair System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, string connectionString, bool buildChain, Hashtable synonyms, bool firstKey) at new System.Data.Common.DbConnectionOptions(string connectionString, Hashtable synonyms, bool useOdbcRules) at new System.Data.SqlClient.SqlConnectionString(string connectionString) at DbConnectionOptions System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(string connectionString, DbConnectionOptions previous) at DbConnectionPoolGroup System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, ref DbConnectionOptions userConnectionOptions) at void System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key) at void System.Data.SqlClient.SqlConnection.set_ConnectionString(string value) at new System.Data.SqlClient.SqlConnection(string connectionString, SqlCredential credential) at Tuple<bool, Version> EFCorePowerTools.Helpers.ReverseEngineerHelper.HasSqlServerViewDefinitionRightsAndVersion(string connectionString) at void EFCorePowerTools.Handlers.ReverseEngineer.ReverseEngineerHandler.VerifySQLServerRightsAndVersion(ReverseEngineerOptions options) at async Task EFCorePowerTools.Handlers.ReverseEngineer.ReverseEngineerHandler.ReverseEngineerCodeFirstAsync(Project project, string optionsPath, bool onlyGenerate, bool fromSqlProj)
Provide steps to reproduce
Right click on entities, select Reverse Engineer, click OK - this generates the error.
Please include a complete description or project that I can redo/run to reproduce the issue.
Provide technical details
I thought this could be addressed with the connection string but I don't seem to have visibility to that (this could totally be because I don't know power tools well enough).
EF Core 6
no
no
no
2.5.1316
SQL Server 2019
VS 2022