Specifying a json or xml field as part of the table indeed triggers an error, but it's a backend 42804 error because npgsql sends values as text. However, it doesn't look like what you got, and moreover I can see no issue when inserting timestamps (with timezone or otherwise). Sorry that it took some time to write back - my internet connection was (is) down - I've got to work via mobile... Please look at my testcase and try to see if there's any real difference with your code. So - for the exception call stack - it only has external code - maybe I need to include the npgsql source for more information on this. Updating Row Status Errors(Row Updating Event Args row Updated Event, Data Row data Row) at System. Also, My SQL documentation still shows that this property is available and effective in obtaining auto-incremented columns. to repeat: Write a C# program utilizing the command builder object and setting the Return Generated Identifiers property to true. Suggested fix: Back out the code changes of the Return Generated Identifiers property in the Command program or provide another way to obtain "Generated Identifiers"/auto-incremented information. Alas, this is intentional and won't be supported any more... Command builder no longer attaches a "select last_inserted_id()" for you but you need to do it manually. How do we now obtain the last inserted id when using Command Builder?
I guess you're looking for a Save Data Changes() method which brings about a few design concerns.
When we edit a row in our Grid View and press the “Update” button, at some time it’s received in the Row Updating method.
But as I noted in the comments in that method, some collections that should contain the columns (names, old values and new values) are always empty. And the Row Updated method is never even touched!!! NET Forums that I need to use a Data Source control.
He mentions that 'We are now treating the command builder the same as Sql Client'. Like this: My Sql Data Adapter da = new My Sql Data Adapter("SELECT * FROM test", c); My Sql Command Builder cb = new My Sql Command Builder(da); My Sql Command insert Cmd = cb. Command Text = "; SELECT last_insert_id()"; insert Cmd.
But there is no indication of a workaround or another method in obtaining generated identifiers.