DevForce Community Forum : non null foreign keys http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : non null foreign keys Mon, 13 Apr 2026 16:14:12 -700 Wed, 23 Mar 2011 10:55:14 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2576 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ non null foreign keys : Thanks for your response, smi-mark.I'm... http://www.ideablade.com/forum/forum_posts.asp?TID=2576&PID=10260#10260 Author: DenisK
Subject: 2576
Posted: 23-Mar-2011 at 10:55am

Thanks for your response, smi-mark.

I'm adding a feature request to see if we can have this "RequiredEntityVerifier" to be a part DevForce validation.
]]> Wed, 23 Mar 2011 10:55:14 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2576&PID=10260#10260 non null foreign keys : This is the same issue that I... http://www.ideablade.com/forum/forum_posts.asp?TID=2576&PID=10258#10258 Author: smi-mark
Subject: 2576
Posted: 23-Mar-2011 at 6:42am

This is the same issue that I talked about in my thread. You need to perform validation on the navigation property, not the foreign key. So rather than InvoiceLine looking at InvoiceId, InvoiceLine needs to ensure that the Invoice navigation property is not a NullEntity.
]]> Wed, 23 Mar 2011 06:42:38 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2576&PID=10258#10258 non null foreign keys : I'm not sure if this is the... http://www.ideablade.com/forum/forum_posts.asp?TID=2576&PID=10243#10243 Author: hueha
Subject: 2576
Posted: 22-Mar-2011 at 6:02am

I'm not sure if this is the same thing that this thread is talking about
http://www.ideablade.com/forum/forum_posts.asp?TID=2540&title=navigation-property-verification

But I'll explain my problem.  In the database I have a table let's say invoice and invoicedetail

InvoiceDetail has a foreign key to Invoice called InvoiceID.  Since I don't want any orphan InvoiceDetail the InvoiceID field is not nullable in the database.

Devforce is creating the the key as an int and adds 
[IbVal.RequiredValueVerifier( ErrorMessageResourceName="InvoiceDetail_InvoiceID")]
 [IbEm.ForeignKey("Invoice")]
 
The problem I get is that since the field is an int the default value is 0.  Then when I go to validate the entity it passes without any validation errors.  I'm assuming this is because the RequiredValueVerifier is only looking for a null.  Is there a way that I can tell devforce to treat the 0 as if it were a null?  I could write my own verifier and then set up a metadata class to do my own validation but then I would have to do that for every foreign key in my database.  

Hue
]]> Tue, 22 Mar 2011 06:02:52 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2576&PID=10243#10243