开发者

SubSonic 2.x StoredProcedure parameter data types?

开发者 https://www.devze.com 2023-01-02 18:36 出处:网络
From what I can see, SubSonic 2.x stored procedure parameter data types can only be of type System.Data.DbType.

From what I can see, SubSonic 2.x stored procedure parameter data types can only be of type System.Data.DbType.

Is there a quick way to add System.Data.SqlDbType so we can use System.Dat开发者_运维百科a.SqlDbType.Structured to pass tables - ultimately to TVP's?

In this particular project, all data caller functions are accessed through StoredProcedures.cs. If we switched to 3.x, does it support SqlDbType.Structured, and if so, is it a seamless integration to retain the current StoredProcedures.cs methods?


You should take a look here. Some guy with the same username and an identical avatar image just implemented that ;)


So, I created my own solution for this - SubSonic 2.x now supports TVP's - SqlDbType.Structure / DataTables for SQL Server 2008

I'm somewhat surprised at the lack of response to TVP's, and seemingly low traction TVP's have in online communities.

0

精彩评论

暂无评论...
验证码 换一张
取 消