I have the latest version of LLBLGen 2.6. To test out new feature support for table valued parameters in stored procs, I create a stored proc in SQL2008 with table value parameter.

When I regenerated the LLBLGen, I noticied that that the parameter is shown as string instead of Datatable. When I looked at the genereated code for the proc, it infact generated the code for the parameter type as SQLDBType.String instead of Sqldbtype.Structured

Let me know if you have any questions reagarding this. I would like to use this feature badly.

File Version of ORMSupportClass : 2.6.9.331 Version : 2.6.0.0

I would like to use this feature badly.

Wouldn't it be better to use it well??

Just kidding.

Don't think they are supported.

Sorry, Table parameters arent supported.

Any plans to support it in the future? This would be very useful.

pls2917 wrote:

Any plans to support it in the future? This would be very useful.

We currently don't have plans to support this in the near future (so v3.0 won't have these parameter types)

I was wondering about this, too. It's too bad to hear they're not on the horizon. It would be pretty cool to have it available in the somewhat rare occasions when you have to perform high-data-volume-dependent logic on a set of records before inserting/updating. Although probably not a small task to add this. And how would it work? a new set of UDTT (user defined table type) collection classes, each with their own typed entities, but where the entities themselves don't map to anything.. weird.

Does v3.0 or v3.1 support SQL 2008 Table Valued Parameters yet?

If not, any updates on support in future versions?

Thanks!

Hi there. AFAIK, It seams there is no plan to support this in the near future. (http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=19589)

No plans at the moment to support them.