Join two lists

Question

Hi i have thee lists sharepoint2010,

but i want to know how can join these list and populate data in gried by linq.

give me easy example so that i can understant easily.

my m unable to write caml query.

pls help asap.

thanks in advance..

Answer 1

Hi,

Suppose if you have two list like order and customer and want to retrieve data from both list based on ID then you can use below joins using LINQ

var orderDetails = from order in orders
join customer in customersItems on order.CustomerID equals customer.CustomerID
select new
{
customer.ContactName,
customer.CompanyName,
order.OrderDate,
order.ShipCity,
};

Check this similar thread for more info:

http://social.technet.microsoft.com/Forums/en-US/sharepoint2010programming/thread/bba1c07e-646f-4033-a175-97f7f6be11af/

Let us know your have any doubt

---

Cheers, Hemendra-MCTS "Yesterday is just a memory,Tomorrow we may never see"