[Firebird-checkins] CVS: NETProvider/NETProvider_17/source/FirebirdSql.Data.Firebird.UnitTest GuidTest.cs,1.4,1.5

[<car...@us...>]

Update of /cvsroot/firebird/NETProvider/NETProvider_17/source/FirebirdSql.Data.Firebird.UnitTest
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv32539

Modified Files:
	GuidTest.cs 
Log Message:
Added a new test case for null guids.

Index: GuidTest.cs
===================================================================
RCS file: /cvsroot/firebird/NETProvider/NETProvider_17/source/FirebirdSql.Data.Firebird.UnitTest/GuidTest.cs,v
retrieving revision 1.4
retrieving revision 1.5
diff -b -U3 -r1.4 -r1.5
--- GuidTest.cs	27 Jan 2005 22:13:50 -0000	1.4
+++ GuidTest.cs	5 Feb 2005 10:14:33 -0000	1.5
@@ -59,5 +59,36 @@
 
 			Assert.AreEqual(guidValue, newGuid);
 		}
+
+		[Test]
+		public void InsertNullGuidTest()
+		{
+			FbCommand createTable = new FbCommand("CREATE TABLE GUID_TEST (INT_FIELD, GUID_FIELD CHAR(16) CHARACTER SET OCTETS)", Connection);
+			createTable.ExecuteNonQuery();
+			createTable.Dispose();
+
+			Guid newGuid = Guid.Empty;
+			Guid guidValue = Guid.NewGuid();
+
+			// Insert the Guid
+			FbCommand insert = new FbCommand("INSERT INTO GUID_TEST (INT_FIELD, GUID_FIELD) VALUES (@Int_Field, @GuidValue)", Connection);
+			insert.Parameters.Add("@IntField", FbDbType.Guid).Value = this.GetId();
+			insert.Parameters.Add("@GuidValue", FbDbType.Guid).Value = DBNull.Value;
+			insert.ExecuteNonQuery();
+			insert.Dispose();
+
+			// Select the value
+			FbCommand select = new FbCommand("SELECT * FROM GUID_TEST", Connection);
+			FbDataReader r = select.ExecuteReader();
+			if (r.Read())
+			{
+				if (!r.IsDBNull(1))
+				{
+					throw new Exception();
+				}
+			}
+
+			Assert.AreEqual(guidValue, newGuid);
+		}
 	}
 }