views:

398

answers:

1

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

A: 
tbreffni