Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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 constructor for first case, and not recognize Tuple.Create method for second.

like image 898
Felipe Pessoto Avatar asked Jan 22 '10 16:01

Felipe Pessoto


1 Answers

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);
like image 106
Marc Gravell Avatar answered Oct 21 '22 05:10

Marc Gravell