Using: LLBLGen Pro v3.0 Final (June 28th, 2010) SQL 2005
(This is somewhat related to the bug I posted in http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=18189 but I have a different question now ...)
I have a table (Item) that has a PK ItemId. ItemId is generated via the SCOPE_IDENTITY sequence. I also have a SQL view, ItemView (defined as SELECT * FROM Item ...). I've used the designer to mark ItemId as the PK for ItemView, and also mark it as using SCOPE_IDENTITY.
Now, I'd like to add a 1:1 relationship between the view and the table so that I can easily use a Navigator in my code to get from one to the other. That's easily done, using the "New Normal Relationship" dialog. I choose Item's ItemId to be the PK and ItemView's ItemId to be the FK.
Now that I've added that relationship, the validator gives me the error that "SequenceToUse: The field "ItemId (FK)" is a foreign key field and foreign key fields can't have a sequence mapped, as they receive their value from the associated identifying field."
The error makes sense, but this working in v2.6, and I'd like to continue to use this relationship with as little change to my code as possible. Is there a better way I should be doing this?
Thanks.