2 // SqlParameterCollectionTest.cs - NUnit Test Cases for testing the
3 // SqlParameterCollection class
5 // Amit Biswas (amit@amitbiswas.com)
7 // Copyright (c) 2007 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.
32 using System.Data.Common;
33 using System.Data.SqlClient;
35 using NUnit.Framework;
37 namespace MonoTests.System.Data.SqlClient
40 [Category ("sqlserver")]
42 public class SqlParameterCollectionTest
46 public void CopyToTest ()
48 SqlCommand cmd = new SqlCommand ();
49 cmd.CommandText = "SELECT fname FROM employee WHERE fname=@fname AND lname=@lname";
50 SqlParameter p1Fname = cmd.Parameters.Add ("@fname", SqlDbType.VarChar, 15);
51 SqlParameter p1Lname = cmd.Parameters.Add ("@lname", SqlDbType.VarChar, 15);
53 Assert.AreEqual (2, cmd.Parameters.Count, "#1 Initialization error, parameter collection must contain 2 elements");
55 SqlParameter [] destinationArray = new SqlParameter [4];
56 cmd.Parameters.CopyTo (destinationArray, 1);
57 Assert.AreEqual (4, destinationArray.Length, "#2 The length of destination array should not change");
58 Assert.AreEqual (null, destinationArray[0], "#3 The parameter collection is copied at index 1, so the first element should not change");
59 Assert.AreEqual (p1Fname, destinationArray[1], "#4 The parameter at index 1 must be p1Fname");
60 Assert.AreEqual (p1Lname, destinationArray[2], "#5 The parameter at index 2 must be p1Lname");
61 Assert.AreEqual (null, destinationArray[3], "#6 The parameter at index 3 must not change");