Geek Answers Handbook

Sql server 2008 linq2sql parameter value table

Has anyone experimented with them. Is it supported?

+4
source share
2 answers

Table value options in LINQ to SQL are not yet supported. There are several posts about this on the Microsoft MSDN forums:

DbType.Structured not available

SQL Server 2k8.User A specific table type. Mapping between DbType 'Structured' and Type 'System.Object'

The second link refers to the Entity Framework, but the main problem is the same.

+4
source

I really had to try this myself .: 0

It does not seem to be supported. I get this error when adding a stored procedure using the tvp parameter to the dbml file

DBML1005: mapping between DbType 'Structured' and Type 'System.Object' in the 'TVP' parameter of the 'dbo.spTestTableTypeParm' function is not supported

Sad but true, I thought it could be a killer in sql 2008 and linq2sql

+3
source

More articles:


All Articles