Our SQL server database does not use auto increment fields for the primary keys, rather it uses a sequence table much like Oracle and Postgres. On insert I need to insert and query a sequence table before to retrieve the primary key before insert.
Set Name = "TEST";
Insert Customer using EntitySession
Before the insert I need to retrieve the Customer Id, Example:
INSERT INTO SEQ_CUSTOMER (comm) VALUES ('IQToolKit');
I've created an Column Attribute called SequenceTable which specifies a sequence table for any given column.
I'm unable to figure out where to slide in the insert statement. I've read the blog posts and have set a considerable amount of breakpoint and event ran a code coverage test.