Cannot Add Views or Stored Procedure to the Model
Cannot Add Views or Stored Procedure to the Model
I am not able to Add View or Stored Procedure to the Model, even though i am able to select View, but after selecting it nothing happens and the dialog box closes. Upon opening the .edmx i don't see anything related to View
Are you using .edmx model and the Update Model from Database wizard?
If so, this is a known issue. Wizard performs an attempt to infer Entitiy Key using non-nullable columns. If it fails, view is added to the model as a commented XML. Open the model in the XML Editor you like, uncomment the view, and set the correct Entity Key.
Please provide us the steps to reproduce the problem if it's not the case.
If so, this is a known issue. Wizard performs an attempt to infer Entitiy Key using non-nullable columns. If it fails, view is added to the model as a commented XML. Open the model in the XML Editor you like, uncomment the view, and set the correct Entity Key.
Please provide us the steps to reproduce the problem if it's not the case.
-
- Posts: 2
- Joined: Tue 12 Jul 2011 23:08
I have extact same issue.
I posted a new thread in the forum before seeing this thread. I am having an identical issue.
Can you please list all the attributes that a view must have in ordedr to be added by the wizard properly.
Thanks
Mr Tripps
Can you please list all the attributes that a view must have in ordedr to be added by the wizard properly.
Thanks
Mr Tripps
CaptinTripps, generally, the view should contain some not null columns. However, there are no specific rules that guarantee that the view will definitely be added. Entity Data Model Wizard seeks for the Primary Key first, and if it doesn't find any, it attempts to infer the Entity Key from not null columns.