Print Page | Close Window

Foreign Keys

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce 2010
Forum Discription: For .NET 4.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=2699
Printed Date: 13-Apr-2025 at 4:09am


Topic: Foreign Keys
Posted By: tooms
Subject: Foreign Keys
Date Posted: 17-May-2011 at 3:26pm

Does declaring foreign keys within the Object Mapper that are not in the Database (SQL Server in this case) cause a problem?

We had previously NOT delcared foreign keys within our database, but we notice when we add them there is a significant decrease in the performance and IdeaBlade queries.
 
Cheers,
Paul Twomey
MEX


Replies:
Posted By: sbelini
Date Posted: 19-May-2011 at 3:38pm
Hi Paul,
 
Declaring FKs in the Object Mapper will not cause problems even if the FKs are not set in the DB. (In fact, if you don't create the FK for the association, it won't compile)
 
You mentioned you noticed performance decrease when querying.
What kind of query are you experiencing this performance decrease with?
How significant is the performance loss?
 
Silvio.


Print Page | Close Window