Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BLG generating SelectPK SPs with wrong primary key.
Message
De
30/12/2008 10:52:15
Tegron Tegron
Platinum Technologies
Ohio, États-Unis
 
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Titre:
BLG generating SelectPK SPs with wrong primary key.
Versions des environnements
Environment:
ASP.NET
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01370173
Message ID:
01370173
Vues:
59
Can anyone tell me why the BLG would be generating the wrong primary key for certain tables? It seems to be happening only on my code tables that are using the @Name for the description that can't be null. When I look at the design of the database, the primary key is correct in the database with the @StatusID (for e.g.) being the listed primary key. I noticed this also on another table that I generated over a month ago.

It appears to be using the clustered index in order to generate the SelectPK stored procs. Is there a way to override this behavior?
Répondre
Fil
Voir

Click here to load this message in the networking platform