Re: DBConcurrencyException - Update problem (PROBLEM BACK IN 5.0.1 BETA)

[James Pearson]

I'm having the same problem. Prior to .NET 2.0 and the new .NET/Connector 5.0 the CommandBuilder was not causing me a problem; it would create the following SQL:

INSERT INTO `db`.`table` (`TableID`, `OtherField`) VALUES (NULL, '100'); SELECT `TableID`, `OtherField` FROM `dbtest`.`table` WHERE (`TableID`=last_insert_id())

Everything was running nicely. But, something has changed and my exact same code (using .NET 2.0 and .NET/Connector 5.0) creates the following SQL:

INSERT INTO `db`.`table` (`OtherField`) VALUES ('100')

A few differences there, in particular the lack of a SELECT command. Is this now an optional extra, if so how do we reinstate it?