Thanks Mike.

The custom type handler for the SqlDbType.Structured that worked for me is as 
simple as this:

    /// <summary>
    /// Custom Type Handler class for iBatis to support the Structured 
SqlDbType in .NET which is
    /// needed to support the Table Value Parameter (TVP) type in SQL2k8
    /// </summary>
    public class SQLStructuredTypeHandler : ITypeHandlerCallback
    {

        /// <summary>
        /// Return the same value from the current getter
        /// </summary>
        /// <param name="getter"></param>
        /// <returns></returns>
        public object GetResult(IResultGetter getter)
        {
            return getter.Value;
        }

        /// <summary>
        /// Return the nullable equivalent as null;
        /// </summary>
        public object NullValue
        {
            get { return null; }
        }

        /// <summary>
        /// Set the SqlDbType to Structured and set the setter's value to the 
parameter value
        /// </summary>
        /// <param name="setter"></param>
        /// <param name="parameter"></param>
        public void SetParameter(IParameterSetter setter, object parameter)
        {
            SqlParameter sqlp = (SqlParameter)setter.DataParameter;
            sqlp.SqlDbType = SqlDbType.Structured;
            setter.Value = parameter;
        }

        /// <summary>
        /// Return the parsed value of this type from a string
        /// </summary>
        /// <param name="s"></param>
        /// <returns></returns>
        public object ValueOf(string s)
        {
            return s;
        }
    }

Srini Junnuru | Sr. Technical Consultant l *TARGET Stores Development l 
612.304.8167(office) | 612.304.6300(fax)
From: Michael McCurrey [mailto:mmccur...@gmail.com]
Sent: Sunday, July 12, 2009 10:39 AM
To: user-cs@ibatis.apache.org
Subject: Re: Using SQL Server 2k8 - Table Value Parameters in iBatis .net

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<mailto: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<mailto:srinivas.junn...@target.com>]
Sent: Saturday, July 11, 2009 5:09 PM

To: user-cs@ibatis.apache.org<mailto:user-cs@ibatis.apache.org>; 
mich...@mccurrey.com<mailto: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<mailto:srinivas.junn...@target.com>]
Sent: Saturday, July 11, 2009 12:49 PM
To: user-cs@ibatis.apache.org<mailto:user-cs@ibatis.apache.org>; 
mich...@mccurrey.com<mailto: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> 
[mailto: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<mailto:user-cs@ibatis.apache.org>; 
mich...@mccurrey.com<mailto: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...



--
Michael J. McCurrey
Read with me at http://www.mccurrey.com
http://chaoticmindramblings.blogspot.com/

Reply via email to