Entity framework and SA 12 - have to delete foreign keys to create EDM

Hello,

We have a problem similar to this one.
We have a DB with ~400 tables and ~1300 foreign keys. All tables are empty. Generation of Entity Data Model succeeds only when foreign keys are deleted. When foreign keys are present, the process seems to never end (even when trying to map only one table with no relations to other tables). DB server CPU load is near 100% almost all the time (from beginning until killing the mapping process).

It works fine with a much lesser DB on the same server (only 40 foreign keys).

DB server - Win XP 64 bit (test server), SA 12.0.1.3436.
We tried the workaround mentioned in the link above (DB server on Win 7) but with no success.
We also have applied the latest EBF (3726) to the client side but that did not help too.

Is it a bug or are there some known restrictions?
Thanks.

entity-framework sa-12 visual-studio

asked 10 May '12, 03:52

Arthoor
1.3k●35●52●66
accept rate: 11%

edited 10 May '12, 03:57

Maybe you should give Sybase a sample db so that they can try to reproduce it.

(16 May '12, 02:55) Martin

Idem problem

(29 May '12, 03:48) Golem

I also have the same problem. I've even tried using Typed DataSet and DB server hangs with 100% CPU when I try to configure an existing TableAdapter. With Entity Framework I'm able to create a model based on views, but as soon as I try to add a table, the DB server hangs forever.

(07 Aug '12, 09:57) Eivind Gussi...

flat view

Be the first one to answer this question!

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

sa-12 ×438
entity-framework ×69
visual-studio ×25

question asked: 10 May '12, 03:52

question was seen: 2,252 times

last updated: 07 Aug '12, 09:57

SAP SQL Anywhere

Entity framework and SA 12 - have to delete foreign keys to create EDM

Follow this question

Related questions