DevForce Community Forum : Problems querying associations http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Problems querying associations Tue, 21 Apr 2026 14:09:52 -700 Wed, 16 Jun 2010 10:19:36 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1895 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Problems querying associations : A property value compatibility... http://www.ideablade.com/forum/forum_posts.asp?TID=1895&PID=7336#7336 Author: kimj
Subject: 1895
Posted: 16-Jun-2010 at 10:19am

A property value compatibility check can be triggered as an object graph is materialized during a query.  The property it's complaining about could be on Closing, UserClosing, or even another type accessed via a navigation property on one of these types.  The likely trigger is logic in an entity constructor - so check these; and also if you've overridden any UpdateNullEntity methods in your entities. 
 
If neither of the above looks like the culprit, please send us your EDMX.
]]> Wed, 16 Jun 2010 10:19:36 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1895&PID=7336#7336 Problems querying associations : I have tried the following 2 queries... http://www.ideablade.com/forum/forum_posts.asp?TID=1895&PID=7317#7317 Author: jmarbutt
Subject: 1895
Posted: 14-Jun-2010 at 7:30am

I have tried the following 2 queries and get the same error:

   var query = from c in Context.Closings
                        where c.UserClosings.FirstOrDefault().UserId == CurrentUser.Id
                        select c;
            
            query.ExecuteAsync(op => op.Results.ForEach(Closings.Add));

            var query2 = from uc in Context.UserClosings
                         where uc.UserId == CurrentUser.Id
                         select uc;
            query2 = query2.Include("Closing");
            var op2 = query2.ExecuteAsync();


--------

The error I get is:

Value is not compatible with property: Id DataType: System.Int32


I have checked my model and my data and they both look good. Any other ideas?


]]> Mon, 14 Jun 2010 07:30:47 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1895&PID=7317#7317