I'm looking into it Srini. I'm more of a non-sql server guy myself so I'm trying to get a handle on it.
On Sat, Jul 11, 2009 at 3:12 PM, Srinivas.Junnuru < srinivas.junn...@target.com> wrote: > Just a followup. > > Hoping that this feature will be supported out of the box in the next > version of DataMapper that targets .NET 3.5 and later. > > > > Thanks > > -Srini > > > ------------------------------ > > *From:* Srinivas.Junnuru [mailto:srinivas.junn...@target.com] > *Sent:* Saturday, July 11, 2009 5:09 PM > *To:* user-cs@ibatis.apache.org; mich...@mccurrey.com > *Subject:* RE: Using SQL Server 2k8 - Table Value Parameters in iBatis > .net > > > > 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> 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> wrote: > > > Hi, > > Test that's he... > > -- Michael J. McCurrey Read with me at http://www.mccurrey.com http://chaoticmindramblings.blogspot.com/
