Loading

Not Responding When Updating Model edmx in MVC

Not Responding When Updating Model edmx in MVC

Dr.Ajay Kashyap

Dr.Ajay Kashyap

9y1.1k.NET

Hello ....

after change in all table of database i am updating edmx but it show not responding ...

i change all primary key int to bigint ...

what is should do

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nilesh Shah9y ago
Can you update SQL Server 2014 with service pack 1
http://www.microsoft.com/en-US/download/details.aspx?id=46694
+1
Dr.Ajay Kashyap9y ago
Nilesh sir I am using SQL 2014
0
Nilesh Shah9y ago
Dr. Ajay wrote:
"But I want to Know Why this will happen"

My answer:
Actually it can be multiple things, but not possible to answer sitting here.

Which version of SQL Server you are using?

It may be a compatibility issue and your SQL Server may need update like some service pack.
+1
Dr.Ajay Kashyap9y ago
Nilesh Shah Sir If i Update 5 or 10 Table And then update edmx it work good but at a time if i update all table it will not work ...
thks Nilesh Sir and Sekar ..But I want to Know Why this will happen
0
Dr.Ajay Kashyap9y ago
Sekar stop others process. Which kind Of Process
0
Dr.Ajay Kashyap9y ago
Nilesh Sir Total table is 65 And I am Update all Table primary key From Int To BigInt
0
Gnanavel Sekar9y ago
Yes it's memory issue only. so you better to stop others process.
+1
Nilesh Shah9y ago
Seems to be a memory related issue

did you alter so many tables, what is the number of table you altered?

can you revert to original version and try with a set of tables, like 10 first then next 10 and like that?

Are you running short on memory on your development machine? Try to close other applications except VS and then see.

as a last resort, try following:
alter database <YOUR_DB_NAME> set compatibility_level = 110
+1