Nevermind. I got it working by creating a Custom Type Handler for this particular datatype i.e. SqlDbType.Structured
Thanks -Srini ________________________________ From: Srinivas.Junnuru [mailto:srinivas.junn...@target.com] Sent: Saturday, July 11, 2009 12:49 PM To: user-cs@ibatis.apache.org; mich...@mccurrey.com Subject: Using SQL Server 2k8 - Table Value Parameters in iBatis .net Hello, Any example or input on how to pass Table Value Parameters (which are supported in Sql Server 2008) to a Stored Proc using IBatis.net Data Mapper? I am using Data Mapper 1.6.1 Here is a link on how to use TVPs using Sql ADO .net provider directly. Not able to get this to work thru iBatis. http://msdnrss.thecoderblogs.com/2009/03/20/table-value-parameter-used-in-net-simple-sample/ Thanks in advance -Srini ________________________________ From: regis.bru...@gmail.com [mailto:regis.bru...@gmail.com] On Behalf Of Régis BRULEY Sent: Friday, July 10, 2009 12:20 PM To: user-cs@ibatis.apache.org; mich...@mccurrey.com Subject: RE : Re: RE : Re: Reuse of statement in an other statement Ok thanks a lot ! I'll try it right on my return on my computer. have a nice week End. Bye Régis Le 10 juil. 2009, 7:07 PM, "Michael McCurrey" <mmccur...@gmail.com<mailto:mmccur...@gmail.com>> a écrit : You can't have your statement pass a dynamic parameter to that; however, you can 'catch' statement parameters in your sql fragment. For example: <sql id="Fragment"> insert into MySuperTable(Column1) values(#MyVariable,type=String,dbType=VarChar#) </sql> On Fri, Jul 10, 2009 at 9:57 AM, Régis BRULEY <re...@bruley.org<mailto:re...@bruley.org>> wrote: > > Hi, > > Test that's he...
