5

.NET 4.0, Visual Studio 2010.

In MSSQL 2008, I have a simple table Type, a stored proc that takes the TVP as a parameter. It works fine in management studio.

I created a new Linq-to-SQL designer, drug my tables and procs onto the design surface, everything worked fine.

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

UdtTypeName property must be set for UDT parameters.

What did I miss?

Brian Tompsett - 汤莱恩
  • 5,753
  • 72
  • 57
  • 129
Snowy
  • 5,942
  • 19
  • 65
  • 119

1 Answers1

4

LINQ to SQL doesn't support User-Defined Table Types. See LINQ to SQL with stored procedures and user defined table type parameter.

Unfortunately, according to Damien [Guard], this feature isn't supported in .NET 3.5, and will not be supported in .NET 4.0 either :-(

Community
  • 1
  • 1
Lee Richardson
  • 8,331
  • 6
  • 42
  • 65