Derived Model from RetrievalProcedures?

Posts   
 
    
hotmail
User
Posts: 47
Joined: 06-Feb-2013
# Posted on: 08-Sep-2016 07:51:51   

In V5 is there a way to project Derived Model from RetrievalProcedures? If not, is this something we can expect in future updates? Thanks

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39614
Joined: 17-Aug-2003
# Posted on: 08-Sep-2016 09:50:26   

derived models are meant for hierarchical projections on entity models. You can't map an entity onto stored procedure resultsets, only typed views, which don't have relationships so it's kind of moot: it would be just another typed view mapped on the typed view.

If you're looking at mapping a poco class on a stored proc resultset, you can, just map a typedview on it and set its 'Output type' in code generation info to 'PocoWithQuerySpecQuery'.

In v5.1 an easier way to do custom projections will be introduced, including a way to call a stored procedure in a micro-orm way using raw SQL. This will help with doing projections of stored procedure resultsets to custom classes without needing a lot of code.

Frans Bouma | Lead developer LLBLGen Pro