Print Page | Close Window

Creating a complex type from different stored procedures

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce 2010
Forum Discription: For .NET 4.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=3493
Printed Date: 27-Apr-2025 at 1:39pm


Topic: Creating a complex type from different stored procedures
Posted By: pponzano
Subject: Creating a complex type from different stored procedures
Date Posted: 12-Jun-2012 at 4:12am
Hello,
I'm writing a batch report generator that will call some different storeprocedure to obtain all the data it needs, then I'll use that source data for generating the report..

I don't want each subreport to call a storeprocedure and I can't access the data directly....

Consider this meta-language store

SP_USER_DETAILS
SP_ORDER_INFORMATION
SP_PRODUCT_INFORMATION

I wish to create a complex object (or a POCO object but this would have complex object derived from the mapping of devforce)

What's the best approach for doing so?

If in my console application I'll add a reference to the server assembly (I usually develop a server and a client dll) can I avoid the access to the web server? so it can run even if the web server is down?

Thanks


Replies:
Posted By: sbelini
Date Posted: 12-Jun-2012 at 5:05pm
Hi Paolo,
 
You can take a look at the DevForce Resource Center topics about stored procedures. (at http://drc.ideablade.com/xwiki/bin/view/Documentation/stored-procedure-queries - http://drc.ideablade.com/xwiki/bin/view/Documentation/stored-procedure-queries  and http://drc.ideablade.com/xwiki/bin/view/Documentation/code-sample-stored-procedure-queries-silverlight - http://drc.ideablade.com/xwiki/bin/view/Documentation/code-sample-stored-procedure-queries-silverlight ).
In the DRC you will also find information about http://drc.ideablade.com/xwiki/bin/view/Documentation/model-complextype - Complex Types .
 
As for the best approach for your problem, our Professional Services team would be able to better assist you. Let me know if you would like me to get you in touch with them.
 
As for your last question, yes, you can have an n-tier and a 2-tier EntityManager. You can always set IdeaBladeConfig.Instance.ObjectServer.ClientSettings.IsDistributed dynamically.
Note that you will need to have connectionString set in the client's app.config (or resolve it dynamically)
 
Regards,
   Silvio.
 


Print Page | Close Window