Write to Data Store Entity with Non-Numeric Primary Key Field

I have an existing table in a SQL Server database with a varchar(GUID) primary key field with default values getting generated by the NEWID() function. I created a CDT mapping to this table and set the @Id and @GeneratedValue (with no other qualifiers) properties in the xsd and when I try to write to this table using the Write to Data Store Smart Service nothing is getting written to the DB. The node does not fail, it completes as if everything is fine with even AC!StoredValues getting populated but with the primary key field blank and there are no errors in the app server logs - does anybody know if this Smart Service supports INSERTING into entities with non-identity primary keys? I would like to avoid using the Query Database Node if I can help it.

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data