Information générale
Catégorie:
The Mere Mortals .NET Framework
Titre:
Updating many-to-many link table without primary key
Hi,
I am using the mmMoverControl to combine data from a many-to-many relationship in much the same way as the mm security tables Users/Roles. The problems is that there is no primary key column in our link table (think of the MM security table UserRoles but without the primary key column) so I am getting the error
"Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information."
How would I do a call to SaveDataSet() to save a dataset that is based on a table without a primary key? Unfortunately our datamodel is rather frozen so we want to avoid having to add a identity column to this link table.
Thank you in advance,
Andrew
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement