1

Resolved

Unique Id included in generated sql for update

description

This statement:

DataBoy.ForTable("PersonDS.PassPhoto")
            .Row("dbObjectId", 1)
            .D("Person_Id", "B32F909A-A8EE-4EE3-BCD8-54392ACC6B06")
            .ForUpdate()
            .Commit();
Produces this SQL:
UPDATE PersonDS.PassPhoto SET DBOBJECTID = 1, PERSON_ID = 'B32F909A-A8EE-4EE3-BCD8-54392ACC6B06' WHERE dbObjectId = 1

Which crashes on SQLServer: System.Data.SqlClient.SqlException: Cannot update identity column 'dbObjectId'.

comments

wrote Jun 30, 2009 at 11:52 AM

Fixed on changeset 55737