Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BLG generating SelectPK SPs with wrong primary key.
Message
From
30/12/2008 10:52:15
Tegron Tegron
Platinum Technologies
Ohio, United States
 
 
To
All
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Title:
BLG generating SelectPK SPs with wrong primary key.
Environment versions
Environment:
ASP.NET
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01370173
Message ID:
01370173
Views:
57
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?
Reply
Map
View

Click here to load this message in the networking platform