All pastes #383454 Raw Edit

Untitled

public text v1 · immutable
·published 2007-03-06 11:07 UTC
rendered paste body
		[Test]
		public void AddWithValueNullTest ()
		{
			OdbcCommand cmd1 = new OdbcCommand ();
			OdbcParameter p1 = cmd1.Parameters.AddWithValue (null, 3);
			Assert.AreEqual ("Parameter1", p1.ParameterName, "#1");
			Assert.AreEqual (3, p1.Value, "#2");
			Assert.AreEqual (OdbcType.NVarChar, p1.OdbcType, "#3");
			
			OdbcParameter p2 = cmd1.Parameters.AddWithValue ("foo", null);
			Assert.AreEqual ("foo", p2.ParameterName, "#4");
			Assert.AreEqual (null, p2.Value, "#5");
			Assert.AreEqual (OdbcType.NVarChar, p2.OdbcType, "#6");
			
			OdbcParameter p3 = cmd1.Parameters.AddWithValue (null, null);
			Assert.AreEqual ("Parameter2", p3.ParameterName, "#10");
			Assert.AreEqual (null, p3.Value, "#11");
			Assert.AreEqual (OdbcType.NVarChar, p3.OdbcType, "#12");

		}