joining stored proc result with a query linq to entities


joining stored proc result with a query linq to entities



I am working with linq to entities where I have a stored proc which returns an enetity based on some parameters. I can get this result in program. Now I want to join this resultset with similar entity on a common field.

my entity

Books { BookId, Title } 

Stored Proc

GetFilterBooks(someparam) (    Select * from books where somefield = someparam  ) 

now I am trying to join both

var books = context.Books; var filterBooks = context.GetFilterBooks(aaa);  var xx = (from b in books                     join bl in filterBooks                      on b.BookId equals bl.BookId                     select b).ToList() 

This gives me error Unable to create a constant value of type 'System.Collections.Generic.IEnumerable`1'.
Only primitive types ('such as Int32, String, and Guid') are supported in this context.




91 out of 100 based on 41 user ratings 391 reviews

@