0

How to get multiple result sets using Entity Data Framework from SQL Server?

For example, I need to get the Customer's personal and account details from a Stored Procedure that contains following queries

SELECT CustomerID,Name,Address FROM Customers
go
SELECT CustomerID,AccountCode FROM CustomerAccounts

But when I create ComplexType, only the first statement is executed.

Please help.......

Soner Gönül
  • 97,193
  • 102
  • 206
  • 364
Anoop
  • 379
  • 4
  • 14
  • 1
    what have you tried, have you seen post like this and tried out? http://msdn.microsoft.com/en-us/data/jj691402.aspx – Imran Rizvi Nov 20 '13 at 08:48
  • Dear Imran thanks for your quick reply. But its not easy as creating a normal Complex Type. I want to handle this in so many scenarios so I need a much more interactive way rather than writing so much of code everytime. – Anoop Nov 21 '13 at 07:06

0 Answers0