VS2008 EF and non crud SP usage.
- by SteveO
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