I have a child table that has two FK fields. When I tried to insert a record, I was getting the following error:
Message=Insert of '784836964-f14effd3-081b-e111-b467-a4badbf99a93' failed:
Telerik.OpenAccess.RT.sql.SQLException: Invalid column name 'ID2'. Invalid column name 'ID3'.
Columns ID2 and ID3 do not exist in my table. Those columns were generated by OA during the creation of RLINQ file. I have attached the following images that could help you understand the issue:
- DatabaseSchema.png - shows relationships between tables;
- CorrectColumnCount.png - shows correct metadata info about table. I was using debugger to inspect the OA Context object;
- IvalidColumnCount.png - shows incorrect metadata info. This screen shot is created on the same OA Context object.
- InvalidColumn_ID2.png and InvalidColumn_ID3.png - shows detailed info about columns generated by OA.
In my database all PK fields have the same name, which is "ID".
Thanks for your help.