It seems that the inserts work using parameter maps... Where is the actual insert for a new Order using "InsertOrderViaParameterMap"? I don't see it anywhere in the tests.
Is there a way to insert it without creating an insert parameter map? Rahul <parameterMap id="insert-params"> <parameter property="Id" dbType="Int"/> <!-- Int for SqlClient, Obdc; Integer for Oledb --> <parameter property="Account.Id"/> <parameter property="Date" nullValue="01/01/0001 00:00:00" /> <parameter property="CardExpiry" /> <parameter property="CardType" /> <parameter property="CardNumber" /> <parameter property="Street" /> <parameter property="City" /> <parameter property="Province" /> <parameter property="PostalCode" /> </parameterMap> On Thu, 30 Dec 2004 15:16:17 +0100, gilles bayon <[EMAIL PROTECTED]> wrote: > The type datetime is supported by iBATISNET, see Nunit test for usage. > > Example, class IBatisNet.Test\Domain\Order.cs, > IBatisNet.Test\Maps\MSSQL\SqlClient\order.xml > > -Gilles > > > On Wed, 29 Dec 2004 17:17:49 -0500, Rahul Singh wrote: > > >?"The statement has been terminated. Arithmetic overflow error > > >?converting expression to data type datetime. " > > > > > >?How do you guys deal with DateTime values as your object > > >?properties? I'm getting this error when I try to insert the object. > > > > > >?Rahul > > > > At the moment, I have the model object convert the value back and forth > between a string representation and a binary representation. The model > object has a separate property for the string representation that do the > conversion and pass the binary to the actual Date property. (So there is no > private string field, just the binary.) The data access methods use the > binary property. The controls use the string property. The string methods > also watch for the magic null strings, and return blanks to the controls. > > > > Next, I'm going to refactor for the Spring Framework, which I believe has > a lot of conversion utilities built in. Spring is widely used by the Java > community, and I expect we'll find the same on the .NET side soon. > > > > [http://www.springframework.net/] > > > > -Ted. > > > > > > > Accédez au courrier électronique de La Poste : www.laposte.net ; > 3615 LAPOSTENET (0,34 /mn) ; tél : 08 92 68 13 50 (0,34/mn)