Unfortunately, you will have to create the complex types for your stored procedures. 

The good news is that the Entity Designer can create the complex types for you.

When importing the stored procedure (Add Function Import) follow the steps below:

 

1. Select the Stored Procedure name;

2. Select Complex for return type;

3. Click on 'Get Column Information';

4. Click on 'Create New Complex Type'

You can also find more information about Stored Procedure Queries in the DevForce Resource Center. There you will also find a detailed walkthrough.

 

Note that if your Stored Proc return all columns (i.e. SELECT * ...) you might want to use the Entity itself instead.

 

Regards,

   Silvio.