Hi All
I am trying to insert data into SLX tables using Microsoft entity framework 3.5.
However since the SLX tables do not have a real primary key, inserts do not work this way.
I have a few solutions in mind, but would like to discuss those, and if someone has done the same in the past, would appreciate if you share the experience.
Approach #1 - create primary keys on the backend DB. This is the simplest approach. However not sure if this has any negative implications or side effects. Seeking some opinions on this.
Approach #2 - use stored procedure mappings to the entities for insert - surely to work, but involves extra overhead for the developers.
Approach #3 - use LINQtoSQL
Thanks in advance.
Yuban |