Return Tuple from EF select
How can I retrieve Tuples at Select using EF4?
var productCount = (from product in context.products
select new Tuple<Product, int>(product, products.Orders.Count));
Or
var productCount = (from product in context.products
select Tuple.Create(product, products.Orders.Count));
Entity framework says that cant use not empty construct开发者_Python百科or for first case, and not recognize Tuple.Create method for second.
How about switching to LINQ-to-Objects for the projection:
var productCount = from product in context.products
select new {Product = product, Count = products.Orders.Count };
var final = from item in productCount.AsEnumerable()
select Tuple.Create(item.Product, item.Count);
Try
var productCount = from product in context.products
select new { product, Count = products.Orders.Count };
This will return an anonymous type which is very close to a tuple http://msdn.microsoft.com/en-us/library/bb738512.aspx
精彩评论