Dear StackOverflow, I'm trying to do the following in the VS2008 Linq O/R designer, SQL 2005:
I have a table called "Entity" with an autoincrementing primary key named "PKey", and another field called "Parent"
I've made a View from this table, calling it vwEmployees, with a simple where clause.
Add both to O/R designer. in O/R, set the view's PKey to be PrimaryKey=true in properties in order to make the view updatable.
Added a one to many relation between them, from PKey in the table, to Parent in the view.
(A "parent" "entity" can have many "children" of the same record type)
Well, I get this error:
Incorrect AutoSync specification for member 'PKey'
I tried setting AutoSync to "Never", but still no dice.
If anyone has any clue as to why this occurs, I would greatly appreciate it.
Thanks, Roger