DevForce Community Forum : Defining new navigation properties in code http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Defining new navigation properties in code Sun, 12 Apr 2026 13:46:05 -700 Mon, 30 Aug 2010 14:39:40 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2106 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Defining new navigation properties in code : You can write your own properties... http://www.ideablade.com/forum/forum_posts.asp?TID=2106&PID=8277#8277 Author: GregD
Subject: 2106
Posted: 30-Aug-2010 at 2:39pm

You can write your own properties in the developer partial classes.

In the Silverlight _MiniDemos app for Business Object Persistence, see the following demo methods:
  • DisplayAllEmployeesWithTotalOrderRevenuesSyncProperty()
  • GetEmployeeWithTotalOrderRevenueAsyncProperty()
  • DisplayAllEmployeesWithTotalOrderRevenuesAsyncProperty()
  • GetEmployeeWithTotalOrderRevenueAsyncMethod()
and the corresponding properties and methods defined in the Employee partial developer class.  These illustrate several different approaches to writing a property that requires data retrieval in an async environment.

You might also be able to add associations in the conceptual model and have DevForce generate the navigation properties for you. I haven't used that approach, but it might be worth looking into. 

]]> Mon, 30 Aug 2010 14:39:40 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2106&PID=8277#8277 Defining new navigation properties in code : My database has some foreign key... http://www.ideablade.com/forum/forum_posts.asp?TID=2106&PID=8269#8269 Author: kpozin
Subject: 2106
Posted: 30-Aug-2010 at 7:37am

My database has some foreign key relationships that exist in the tables but are not formally specified by SQL Server foreign key constraints, and are therefore not visible to the Entity Framework. The schema is somewhat inflexible, so I'd like to extend a DevForce-generated entity partial class in the shared code to provide access to these "navigation properties" on both the server and the client side.

For example, I might have Contact, Company, and Address tables. I would want to make a property that will return a Contact's Company's Address object.I would want to extend the Contact class and add a CompanyAddress { get; } property (a setter would be great, too). Or Contact might have a PersonId field, but be missing a foreign key constraint to the Person table.

What's the best way to expose such queries in new shared properties? Which attributes should I include? Which methods should I be calling to ensure that asynchronous access and DevForce interceptor actions continue to work?
]]> Mon, 30 Aug 2010 07:37:00 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2106&PID=8269#8269