DevForce Community Forum : Multiple Model Query http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Multiple Model Query Sun, 12 Apr 2026 08:51:08 -700 Mon, 23 Jan 2012 16:25:38 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3227 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Multiple Model Query : Hi Vincent,While you can... http://www.ideablade.com/forum/forum_posts.asp?TID=3227&PID=12532#12532 Author: sbelini
Subject: 3227
Posted: 23-Jan-2012 at 4:25pm

Hi Vincent,
 
While you can have an EntityManager with multiple models pointing to different datasources, you can only query one database at the time. (You can, however, save multiple entities to multiple databases in one single transaction)
 
So, you will need to first retrieve the customers and then query for the orders. (or vice versa)
 
i.e
 
var aCustomer = mgr.Customers.First();
var aCustomerOrders = mgr.Orders.Where(ord => ord.CustomerID == aCustomer.Id)
  .ToList();
 
or
 
var myOrder = mgr.Orders.First();
var CustomerName = mgr.Customers.Where(cust => cust.Id == myOrder.CustomerID)
  .Select(cust => cust.CompanyName)
  .Distinct();
 
You might want to take a look at the DevForce Resource Center for more information.
I've also attached a simple solution showing one EntityManager with multiple models. (uploads/892/T11435.zip)
 
 
Regards,
   Silvio.
]]> Mon, 23 Jan 2012 16:25:38 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3227&PID=12532#12532 Multiple Model Query : In my application I have two models.... http://www.ideablade.com/forum/forum_posts.asp?TID=3227&PID=12517#12517 Author: Vincent
Subject: 3227
Posted: 21-Jan-2012 at 8:56am

In my application I have two models. One model contains customer entity and another contains order entity. These models are coming from different databases. Can you please give me a sample linq query of how I can retrieve particulars of an order showing its customer name?
 
 
Best Regards,
Vincent
]]> Sat, 21 Jan 2012 08:56:35 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3227&PID=12517#12517