Question 262310 in Azure Question posted in
The official documentation to get you started can be found here.

Azure – C# Entity Framework : update EDMX from model error 'EntityCommandExecutionException'

When I try to update my .EDMX with update model from database, I get the following error:

Query processor could not produce a query plan because of the hints defined in this query. Resubmit the query without specifying any hints and without using SET FORCEPLAN

Any help would be much appreciated.

We have multiple databases, I have tried connecting to all of these and still get the same error.

I have tried starting a new project and still get the same error.

Tags:

2

Answers


  1. 0

    Not an ideal solution until Microsoft fix whatever update they made to their Azure databases – but as a temporary work-around – you can copy your database schema to a local database on a local server and generate your EDMX model using that database while leaving your connection string on your application to the Azure database.

    Entity framework will still perform it’s CRUD functionality on Azure – the issue is just for modelling the database in it’s EDMX model from an Azure database.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search