Mixing local list operations with linq to entities database operations?
I think this should work var model = (from c in cart. Entires // The small local cart collection let cpid = cart.Entires. Select(c2 => c2.
ProjectId) // from p in productService.GetAllProducts() // Query all Products used in cart . Where(queryp => cpid. Contains(queryp.
ProjectId)).ToList() where p. ProductId == c. ProductId select new CartViewItem { p.
Price, p. ProductId, p. Brand, p.
ProductName, Discount = p. DiscountPercent * c. Quantity}).ToList().
I think this should work... var model = (from c in cart. Entires // The small local cart collection let cpid = cart.Entires. Select(c2 => c2.
ProjectId) // from p in productService.GetAllProducts() // Query all Products used in cart . Where(queryp => cpid. Contains(queryp.
ProjectId)).ToList() where p. ProductId == c. ProductId select new CartViewItem { p.
Price, p. ProductId, p. Brand, p.
ProductName, Discount = p. DiscountPercent * c. Quantity}).ToList().
The problem with this where-in linq is that cart. Entries is not coming from a repository. ProductService.GetAllProducts() returns an entityframework IQueryable – Lol coder May 18 at 16:52 This now gives: Unable to process the type 'SampleApp.WebUI.Models.
ShoppingCartEntry', because it has no known mapping to the value layer. – Lol coder May 18 at 17:06 GetAllProjects is Queryable and cart. Entries is a collection?
– ben dotnet May 18 at 17:09 @Benjamin Müller yes, both of these threw the same error. – Lol coder May 18 at 17:12 2 yes, how does that work? I'm trying to profile it to see if its 1 database call or it loops the calls.
– Lol coder May 18 at 17:44.
Take a look at the ROLLUP operation within Oracle and perform these operations in a single SQL statement. The Row_Number() Function in SQL Server 2005: Part 2 Learn how to delete multiple duplicate rows using the new Row_Number() function feature, common table expression and the ANSI co-related subquery. Date and Time in MySQL 5 MySQL 5 has significantly improved the flexibility of its date handling.
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.
Related Questions
LINQ to Entities Qyery Syntax: “IN” set operations?
Dynamic LINQ Query in LINQ to Entities , problem with WHERE clause?
Linq linq-to-entities add join if condition is met?
Is there a DataContext in LINQ-to-Entities (NOT Linq-to-SQL)?
Linq-to-entities: Easy to find max value in SQL, but difficult in LINQ?
Linq To Entites error: The entity or complex type … cannot be constructed in a LINQ to Entities query?