2 // OdbcParameterCollectionTest.cs - NUnit Test Cases for testing the
3 // OdbcParameterCollection class
5 // Sureshkumar T (TSureshkumar@novell.com)
7 // Copyright (c) 2004 Novell Inc., and the individuals listed
8 // on the ChangeLog entries.
10 // Permission is hereby granted, free of charge, to any person obtaining
11 // a copy of this software and associated documentation files (the
12 // "Software"), to deal in the Software without restriction, including
13 // without limitation the rights to use, copy, modify, merge, publish,
14 // distribute, sublicense, and/or sell copies of the Software, and to
15 // permit persons to whom the Software is furnished to do so, subject to
16 // the following conditions:
18 // The above copyright notice and this permission notice shall be
19 // included in all copies or substantial portions of the Software.
21 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
22 // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
23 // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
24 // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
25 // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
26 // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
27 // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
33 using System.Data.Odbc;
35 using NUnit.Framework;
37 namespace MonoTests.System.Data.Odbc
41 public class OdbcParameterCollectionTest
44 /// This tests whether the value is trimmed to the
45 /// given length while passing parameters
48 public void ParameterLengthTrimTest ()
50 IDbConnection conn = ConnectionManager.Singleton.Connection;
52 ConnectionManager.Singleton.OpenConnection ();
53 OdbcCommand cmd = (OdbcCommand) conn.CreateCommand ();
54 cmd.CommandType = CommandType.Text;
55 cmd.CommandText = "SELECT count(*) FROM employee WHERE fname=?";
57 OdbcParameter param = cmd.Parameters.Add("@fname", OdbcType.Text, 15);
58 param.Value = DateTime.Now.ToString ();
59 Assert.AreEqual (15, param.Size, "#1");
60 Convert.ToInt32(cmd.ExecuteScalar());
62 ConnectionManager.Singleton.CloseConnection ();