CODEWITHSUNDEEP
linq-to-sql
DevUser
DevUser

Reputation: 751

Select all customers and their last order Linq to SQL

hei,

Using Linq to SQL (ala NorthWind database for example): How to select all customers and the latest order for each of them. The customers who have not placed order should be also in the result. The last order could be by ID (ID is incremental) or Timestamp (DateTime field).

similar to this SQL Statement Help - Select latest Order for each Customer but done in LINQ.

thanks

Upvotes: 0

Views: 1206

Answers (1)

James Curran
James Curran

Reputation: 103505

Assuming there's a foreign-key relationship between Customers & Orders, something like this sghould work:

from c in db.Customers
select new 
       { 
         Customer = c,
         LastOrder = c.Orders.OrderByDescending(o=>o.Timestamp).First();
       };

Upvotes: 2

Related Questions