However when I create views and try to update them to my data model, it simply asks me to save as a text file and never updates it.
Hi,
If you are using Model-first, please generate the model entities and then it will automatically generate entity models' SQL creation script, which you can create a whole db with empty tables.
I created a new project and tried again and got this error
Message 1 The table/view 'Gifts.dbo.delete' does not have a primary key defined and no valid primary key could be inferred. This table/view has been excluded. To use the entity, you will need to review your schema, add the correct keys, and uncomment it. d:\projects\delete\Model1.edmx 0 1 delete
Warning 4 Error 6013: The table/view 'Gifts.dbo.delete' does not have a primary key defined and no valid primary key could be inferred. This table/view has been excluded. To use the entity, you will need to review your schema, add the correct keys, and uncomment
it. d:\projects\delete\Model1.edmx 1 1 delete
Message 1 The table/view 'Gifts.dbo.delete' does not have a primary key defined and no valid primary key could be inferred. This table/view has been excluded. To use the entity, you will need to review your schema, add the correct keys, and uncomment it. d:\projects\delete\Model1.edmx 0 1 delete
Warning 4 Error 6013: The table/view 'Gifts.dbo.delete' does not have a primary key defined and no valid primary key could be inferred. This table/view has been excluded. To use the entity, you will need to review your schema, add the correct keys, and uncomment
it. d:\projects\delete\Model1.edmx 1 1 delete
Please make sure that there must be at least a primary key defined in your original table, and then with the help of such a table, you can create an entity model class by importing it into your edmx file.
very sorry i should have updated the forum last night, i found the problem also with this topic, although its oracle, i realized i had to do the same in sql server
afrika
Member
249 Points
887 Posts
My view is not saved or updated in my EF data model
Nov 08, 2012 04:21 PM|LINK
hi guys
I have a project and using EF as my data model.
However when I create views and try to update them to my data model, it simply asks me to save as a text file and never updates it.
The name it gives is -- Output-EntityDataModel ( which I have put here https://dl.dropbox.com/u/38489312/error%20list.txt )
Please advice
many thanks
Ehi
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: My view is not saved or updated in my EF data model
Nov 09, 2012 05:12 AM|LINK
Hi,
If you are using Model-first, please generate the model entities and then it will automatically generate entity models' SQL creation script, which you can create a whole db with empty tables.
Reguards!
afrika
Member
249 Points
887 Posts
Re: My view is not saved or updated in my EF data model
Nov 09, 2012 01:32 PM|LINK
no am using db 1st approach.
I created a new project and tried again and got this error
Message 1 The table/view 'Gifts.dbo.delete' does not have a primary key defined and no valid primary key could be inferred. This table/view has been excluded. To use the entity, you will need to review your schema, add the correct keys, and uncomment it. d:\projects\delete\Model1.edmx 0 1 delete
Warning 4 Error 6013: The table/view 'Gifts.dbo.delete' does not have a primary key defined and no valid primary key could be inferred. This table/view has been excluded. To use the entity, you will need to review your schema, add the correct keys, and uncomment it. d:\projects\delete\Model1.edmx 1 1 delete
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: My view is not saved or updated in my EF data model
Nov 10, 2012 12:58 AM|LINK
Please make sure that there must be at least a primary key defined in your original table, and then with the help of such a table, you can create an entity model class by importing it into your edmx file.
Reguards!
afrika
Member
249 Points
887 Posts
Re: My view is not saved or updated in my EF data model
Nov 10, 2012 07:44 AM|LINK
very sorry i should have updated the forum last night, i found the problem also with this topic, although its oracle, i realized i had to do the same in sql server
http://www.developerbarn.com/community/entries/entity-framework-why-i-cant-add-that-view.47/
many thanks
Ehi