Using an edmx version of EF. My returned data is a join between tables that has a COMPOUND filter on the primary table. In essence this query is going to return a SEGMENT of Law codes and descriptions that a user can tie to a Sex Offender report.

I have a complex SP because Linq2SQL cannot pass in a between statement, or at least that is how I understand the error.

The Code itself is broken up by '-' marks. 39-13-504 "Aggravated Sexual Battery"

User wants to have a query with 4 parmas 39, 13, 500, 599. Get all codes from Title 39 and Chapter 13 with parts between 500 and 599. I have the SP in place to do the work, is there are way to consume the SP within the EF?

I find many blogs about SPs with CRUD operations as their use of an SP. That doesn't fit this need at all. I do not have a single table but a join to the "prior selections" table that maps the key for the code.

Any pointers on how to get a READ with an SP?

TIA