CODEWITHSUNDEEP
visual-studio-2010linqsql-server-2008linq-to-sql
Rahul Bansal
Rahul Bansal

Reputation: 23

User Defined Table Type not working with Linq

I have created some User Defined Table Types in database(SQL Server2008) and using that kind of types as parameter in some stored procedures, when i dragged that stored procedures in dbml file(visual studio 2010) via server explorer by which database has been connected and i have dragged all tables,it gives error 'UdtTypeName Property must be set for UDT parameters' might be because there is no type in server explorer...

Upvotes: 2

Views: 3842

Answers (1)

Ann L.
Ann L.

Reputation: 13965

Unfortunately, LINQ doesn't support User Defined Table Types. However, someone has written a workaround: http://blog.mikecouturier.com/2010/01/sql-2008-tvp-table-valued-parameters.html

Disclaimer: I have not used this method, so I can't personally vouch for it.

Upvotes: 3

Related Questions