solution on SP and EF & Ria Service
- by KentZhou
As EF 4.0 released, more support to SQL server Stored procedure.
Complex Type can be generated automatically for result dataset of SP.
But complex type not support by Ria Service.
When I try to use ria service combined with EF 4.0, I want to get dataset by SP. This result is not mapped to any entity/table.
Some sulutions suggested by community are:
1. Create view to map sp result. (but for EF, if there is no ID or primary, can't be map to any entity)
2. Create Entity to map sp result.(for this, you even need to map SP for CRUD even though I don't need CUD on this sp result)
Also above solution can't be automated. As Database objects maybe changed with the time, auto update edm will lost above solution.
So what's the solution? I want to put data operation back to DB as possible, so that many changes can be done in DB and no need to rebuild .net assemblies(this cause redeploy).