Stored procedure cannot create complex type in entity framework

Question

I have added this store procedure through phpmyadmin:

CREATE DEFINER=`root`@`localhost` PROCEDURE `SelectUser`()
LANGUAGE SQL
NOT DETERMINISTIC
NO SQL
SQL SECURITY DEFINER
COMMENT ''
Select * from User

In my edmx but when create a complex type and do the Get column information that gives

The store procedure returns no columns

Have you try to specify colums? i mean change your * to colunm enumeration? — teo van kot
– teo van kot, Commented Jan 13, 2016 at 14:21

facebook-100002133514545 · Accepted Answer · 2016-12-07 07:25:13Z

3

try add SET FMTONLY OFFin your sql statement

answered Dec 7, 2016 at 7:25

313 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Could you please explain a bit more in detail why this should help?