Entity Framework Patterns: Select Multiple Entities

using System;
using System.Collections.Generic;
using System.Linq;

namespace TestPatterns
{
	/// <summary>Here we select each entity one at the time.</summary>
	public static class SelectingEach
	{
		public static Order[] DoSelect(int[] ids)
		{
			using (var context = new EFDemoEntities())
			{
				var list = new List<Order>(3);

				foreach (var id in ids)
				{
					var query = from o in context.Order.Include("OrderDetail")
								where o.OrderID == id
								select o;
					var objectQuery = (System.Data.Objects.ObjectQuery)query;
					var sql = objectQuery.ToTraceString();

					list.AddRange(query);
				}

				return list.ToArray();
			}
		}
	}
}