New Posts New Posts RSS Feed: Store procedure returning multiple dataset
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Store procedure returning multiple dataset
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
pponzano View Drop Down
Senior Member
Senior Member
Avatar

Joined: 28-Apr-2011
Location: Italy
Posts: 165 		Post Options Post Options   Quote pponzano Quote  Post ReplyReply Direct Link To This Post Topic: Store procedure returning multiple dataset
    Posted: 28-Apr-2011 at 3:28am
Hello,
I'm evaluating your product and got a question about a store procedure I wish to use in a SL demo project... my stored procedure returns 8 dataset but mapping with EDMX a complex type only returns me the first... how can I resolve this?
 
Thanks
Paolo
Back to Top
robertg View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 15-Mar-2011
Location: California
Posts: 87 		Post Options Post Options   Quote robertg Quote  Post ReplyReply Direct Link To This Post Posted: 28-Apr-2011 at 3:59pm
Paolo,

Could you please post the code where you're using this stored procedure, and if it's not too long or sensitive, the stored procedure itself? That will be a good start for figuring out what's going on.

-- Robert
Back to Top
pponzano View Drop Down
Senior Member
Senior Member
Avatar

Joined: 28-Apr-2011
Location: Italy
Posts: 165 		Post Options Post Options   Quote pponzano Quote  Post ReplyReply Direct Link To This Post Posted: 29-Apr-2011 at 1:16am
Hello Robert,
consider a simple store that executes

SELECT

top 10* FROM TABLE1

SELECT

TOP 10* FROM TABLE2

when I generate the complex type I get only the column of the first Table1, am I doing something wrong?

Edited by pponzano - 29-Apr-2011 at 1:36am
Back to Top
robertg View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 15-Mar-2011
Location: California
Posts: 87 		Post Options Post Options   Quote robertg Quote  Post ReplyReply Direct Link To This Post Posted: 02-May-2011 at 3:00pm
Paolo,

Oh, I see what's going on here. The problem here is that EF itself doesn't support queries which return multiple resultsets like that; understanding how to organize unrelated data like that would likely be extremely difficult for an automated process. Because EF does not support this, neither does IdeaBlade.

Sorry,
Robert
Back to Top
pponzano View Drop Down
Senior Member
Senior Member
Avatar

Joined: 28-Apr-2011
Location: Italy
Posts: 165 		Post Options Post Options   Quote pponzano Quote  Post ReplyReply Direct Link To This Post Posted: 03-May-2011 at 12:34am
no problem Robert... I'll continue evaluating your product and if got other question will ask you... have u got a comparative with Telerik's OpenAccess?
Thanks
Back to Top
ting View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 27-Mar-2009
Location: San Francisco
Posts: 427 		Post Options Post Options   Quote ting Quote  Post ReplyReply Direct Link To This Post Posted: 05-May-2011 at 2:59pm
Hi Paolo,

The Entity Framework is now the standard for .NET data access, so OpenAccess is really competing against that. DevForce adds a lot to the Entity Framework like client-side caching, full n-tier LINQ, dynamic queries, multiple datasources, etc., but the fundamental decision is still whether you want to standardize on EF vs OpenAccess.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down