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

Answer 1

try add SET FMTONLY OFFin your sql statement