0

Visual studio get stuck when I update my Entity Data Model from database and it takes long time to update the EDM from local DB. What should I do to avoid this problem ? I use VS 2013

Ravi Rajindu
  • 380
  • 2
  • 6
  • 23

1 Answers1

1

this might happen with your SQL Server compatibility. You can possibly try following things:

  1. Set the compatibility level of the database to 110.

To check the compatibility level, run this command:

select compatibility_level from sys.databases where name = '<YOUR_DATABASE_NAME>'

Now, to set the compatibility level, use this script:

alter database <YOUR_DATABASE_NAME> set compatibility_level = 110.

or 2. Install Service Packs available for visual studio 2013.(Not guarantees solution)

Hope this will help you out.

error_handler
  • 1,191
  • 11
  • 19