Updating model from database throws an exception

Question

User-1693238866 posted

Hi,

I've recently updated Visual Studio to version 15.7.1

Now, when trying to update model 

I get this message

Output window:

Unable to generate the model because of the following exception: 'System.MissingMethodException: Method not found: 'Boolean System.Data.Entity.Core.Common.DbProviderManifest.SupportsParameterOptimizationInSchemaQueries()'.
at Microsoft.Data.Entity.Design.VersioningFacade.ReverseEngineerDb.SchemaDiscovery.EntityStoreSchemaGeneratorDatabaseSchemaLoader.CreateFilteredCommand(String sql, String orderByClause, EntityStoreSchemaFilterObjectTypes queryTypes, List`1 filters, String[] filterAliases)
at Microsoft.Data.Entity.Design.VersioningFacade.ReverseEngineerDb.SchemaDiscovery.EntityStoreSchemaGeneratorDatabaseSchemaLoader.LoadDataTable[T](String sql, Func`2 orderByFunc, DataTable table, EntityStoreSchemaFilterObjectTypes queryTypes, IEnumerable`1 filters, String[] filterAliases)
at Microsoft.Data.Entity.Design.VersioningFacade.ReverseEngineerDb.SchemaDiscovery.EntityStoreSchemaGeneratorDatabaseSchemaLoader.LoadTableDetails(IEnumerable`1 filters)
at Microsoft.Data.Entity.Design.VersioningFacade.ReverseEngineerDb.SchemaDiscovery.EntityStoreSchemaGeneratorDatabaseSchemaLoader.LoadStoreSchemaDetails(IList`1 filters)
at Microsoft.Data.Entity.Design.VisualStudio.ModelWizard.Engine.ModelGenerator.GetStoreSchemaDetails(StoreSchemaConnectionFactory connectionFactory)
at Microsoft.Data.Entity.Design.VisualStudio.ModelWizard.Engine.ModelGenerator.CreateStoreModel()
at Microsoft.Data.Entity.Design.VisualStudio.ModelWizard.Engine.ModelGenerator.GenerateModel(List`1 errors)
at Microsoft.Data.Entity.Design.VisualStudio.ModelWizard.Engine.ModelBuilderEngine.GenerateModels(String storeModelNamespace, ModelBuilderSettings settings, List`1 errors)
at Microsoft.Data.Entity.Design.VisualStudio.ModelWizard.Engine.ModelBuilderEngine.GenerateModel(ModelBuilderSettings settings, IVsUtils vsUtils, ModelBuilderEngineHostContext hostContext)'.

In this project:

• The EntityFramework version is 6.2.0
• The .Net version is 4.7.1

What I've tried:

• Clean
• Rebuild
• Reinstall EntityFramework (with removing leftover DLLs from the project)
• Change .Net version to earlier and back

Any help would be appreciated.

Thank you in advance.

Answer 1

User1120430333 posted

System.MissingMethodException: Method not found: 'Boolean System.Data.Entity.Core.Common.DbProviderManifest.SupportsParameterOptimizationInSchemaQueries()'.

The method seems to be depreciated and is no longer viable.

Maybe, you should post the MSDN EF forum for advise on how to proceed.

http://social.msdn.microsoft.com/Forums/en-US/home?forum=adodotnetentityframework

Answer 2

User-1693238866 posted

Thanks.
Will do.

Update:

Unfortunately they are not there anymore.

The first topmost thread is "### EF TEAM NO LONGER USES THIS FORUM ###" 

Answer 3

User1724605321 posted

Hi never_again ,

You can asked on Stack Overflow for further support using the entity-framework tag.

Best Regards

Nan Yu

Answer 4

User1120430333 posted

Thanks.
Will do.

Update:

Unfortunately they are not there anymore.

The first topmost thread is "### EF TEAM NO LONGER USES THIS FORUM ###" 

There was one poster that asked for more  info that you have not supplied.

Answer 5

User1120430333 posted

One other thing, top guns service the forum I pointed you to make no mistake about that, which they will ask the EF team for a solution.

Answer 6

User1120430333 posted

Replies from posters.

https://social.msdn.microsoft.com/Forums/en-US/1ffb7e61-9fbf-42f0-b37f-e04e578de2de/updating-model-from-database-throws-an-exception?forum=adodotnetentityframework