i have project multiple ef databases; each ef model in own project, referenced other parts of database.
occasionally when use update model database... feature (right-clicking graphical .edmx view), visual studio gets state tries update .edmx file model database associated model b. example, shows "new tables" in db wants import (which in other db). exiting/restarting visual studio doesn't resolve problem.
this question seemed express problem i'm seeing, accepted answer doesn't address issue.
what visual studio using configure how connects db find updates? things have checked:
- my app.config connectionstring in db project points right place. file expect use.
- i have tried setting "current startup project" application doesn't reference "incorrect" db project, thinking perhaps other projects' app/web.config connectionstrings might interfere; no visible effect.
- server explorer shows data connection "correct" db, not "incorrect" one. red herring; showed disconnected until clicked on it, doubt being used anyway.
- there no string matching name of "incorrect" project/db in .csproj file. .sln file contains expected project references. there no .csproj.user file.
any ideas? visual studio bug?
update: other things tried:
- deleting .suo file doesn't affect problem.
- i found unexpected .datasource files visual studio added under properties @ point; moving these elsewhere hasn't had effect, , visual studio hasn't attempted recreate them. looked inside, there's nothing referencing other db/project, genericobjectdatasource element items referencing "correct" project. presence of file makes me suspicious i'm stumped how probe further. don't see equivalent files in of other projects in solution.
/facepalm
disregard. there lingering tables in "correct" database left on team's refactor of tables out other database. phantom tables there in db.
Comments
Post a Comment