Geek Answers Handbook

Valued Param UdtTypeName Table

.NET 4.0, Visual Studio 2010.

In MSSQL 2008, I have a simple Type table - a stored proc that takes TVP as a parameter. He works great in a management studio.

I created a new Linq-to-SQL constructor, earned my tables and processed on the design surface, everything worked fine.

Then I tried to drag the stored procedure with the table parameter to the design surface and got this red-X error:

UdtTypeName property must be set for UDT parameters.

What did I miss?

+5
source share
1 answer

LINQ to SQL does not support custom table types. See LINQ to SQL with stored procedures and a table type custom parameter .

, Damien [Guard], .NET 3.5 .NET 4.0: - (

+4

More articles:


All Articles