Hi guys,
I want to update this datatable into my DB but the table in the DB that I use, it doesn't use Primary Key and I really don't need it. Therefore I get this Exception error (System.Invalid OperationExcept ion: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information).
If I go to the DB and I add a new column into the table and assign it like PK it works but I really want to avoid this and keep the table like that.
Any suggestion please?
Thank you in advance
I want to update this datatable into my DB but the table in the DB that I use, it doesn't use Primary Key and I really don't need it. Therefore I get this Exception error (System.Invalid OperationExcept ion: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information).
If I go to the DB and I add a new column into the table and assign it like PK it works but I really want to avoid this and keep the table like that.
Any suggestion please?
Thank you in advance
Comment