Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updating many-to-many link table without primary key
Message
De
07/03/2005 16:49:57
 
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Titre:
Updating many-to-many link table without primary key
Divers
Thread ID:
00993430
Message ID:
00993430
Vues:
55
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
Fil
Voir

Click here to load this message in the networking platform