使用表类型的存储过程 [英] using store procedure with table type

问题描述

你好，
我在声明表类型变量的存储过程中创建了一个存储过程.当我在linq中拖动此过程时，它会显示类似此类型的错误错误必须为udt参数linq设置udttypename属性到sql" plz help me

Hello,
I have created one store procedure in a store procedure i declare table type variable . when i am draging this procdure in linq then it''s showing error like this type error ''udttypename property must be set for udt parameters linq to sql'' plz help me

推荐答案

LINQ to SQL不支持用户定义的表类型

检查此
http://stackoverflow.com/问题/1019414/linq-to-sql-with-stored-procedures-and-user-defined-table-type-parameter [www.microsofttranslator.com/bv.aspx?ref=Internal&from=&to=en&a=http://www.cnblogs.com/ryanding/archive/2010/04/18/1714854.html [

LINQ to SQL doesn''t support User-Defined Table Types

Check this
http://stackoverflow.com/questions/1019414/linq-to-sql-with-stored-procedures-and-user-defined-table-type-parameter[^]

But i tried for alternate way, and this might help you
www.microsofttranslator.com/bv.aspx?ref=Internal&from=&to=en&a=http://www.cnblogs.com/ryanding/archive/2010/04/18/1714854.html[^]

这篇关于使用表类型的存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！