存储过程无法在实体框架中创建复杂类型

I have added this store procedure through phpmyadmin:

我通过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

在我的edmx中但是当创建一个复杂类型并执行Get列信息时

The store procedure returns no columns

存储过程不返回任何列

1 个解决方案

#1

try add SET FMTONLY OFFin your sql statement

尝试在sql语句中添加SET FMTONLY OFF