Entity Framework only with stored procedures

Question

i have a question about the reasonableness of using entity framework only with stored procedures in our scenario.

We plan to have an N-tier architecutre, with UI, BusinessLayer (BLL), DataAccessLayer(DAL) and a BusinessObjectDefinitions(BOD) layer. The BOD layer is known by all other layers and the results from executes queries in the DAL should be transformed into Objects (definied in the BOD) before passing into the BLL.

We will only use stored procedures for all CRUD methods. So in case of a select stored procedure, we would add a function import, create a complex type and when we execute the function, we tranform the values of the complex type into a class of BOD and pass that to the BLL. So basicly, we have no Entities in the Model, just Complex types, that are transformed into Business Objects.

I'm not sure if that all makes sense, since in my opinion, we lose a lot of the benefit, EF offers.

Or am i totally wrong?

Answer 1

I would not use EF if all I was just using was stored procs.

Personally, I'd look at something like PetaPoco, Massive or even just straight Ado.Net

EDIT

Here's an example of PetaPoco consuming SPs and outputting custom types

http://weblogs.asp.net/jalpeshpvadgama/archive/2011/06/20/petapoco-with-stored-procedures.aspx