Author: anagappan
Date: 2006-12-07 06:37:11 -0500 (Thu, 07 Dec 2006)
New Revision: 69171
Added:
trunk/mcs/class/System.Data/Test/Mono.Data.SqlExpressions/
trunk/mcs/class/System.Data/Test/Mono.Data.SqlExpressions/ChangeLog
trunk/mcs/class/System.Data/Test/Mono.Data.SqlExpressions/DataColumnExpressionTest.cs
Modified:
trunk/mcs/class/System.Data/Test/ChangeLog
Log:
2006-12-07 Nagappan A <[EMAIL PROTECTED]>
* Mono.Data.SqlExpressions: Created directory.
2006-12-07 Nagappan A <[EMAIL PROTECTED]>
* Mono.Data.SqlExpressions/DataColumnExpressionTest.cs
(TestDataColumnExpr1, TestDataColumnExpr2): Added two functions to
test Data Column Expression.
Modified: trunk/mcs/class/System.Data/Test/ChangeLog
===================================================================
--- trunk/mcs/class/System.Data/Test/ChangeLog 2006-12-07 11:34:30 UTC (rev
69170)
+++ trunk/mcs/class/System.Data/Test/ChangeLog 2006-12-07 11:37:11 UTC (rev
69171)
@@ -1,3 +1,7 @@
+2006-12-07 Nagappan A <[EMAIL PROTECTED]>
+
+ * Mono.Data.SqlExpressions: Created directory.
+
2006-07-18 Dean Brettle <[EMAIL PROTECTED]>
* SqlTest.cs: Added test for inserting zero-length varbinary.
Added: trunk/mcs/class/System.Data/Test/Mono.Data.SqlExpressions/ChangeLog
===================================================================
--- trunk/mcs/class/System.Data/Test/Mono.Data.SqlExpressions/ChangeLog
2006-12-07 11:34:30 UTC (rev 69170)
+++ trunk/mcs/class/System.Data/Test/Mono.Data.SqlExpressions/ChangeLog
2006-12-07 11:37:11 UTC (rev 69171)
@@ -0,0 +1,5 @@
+2006-12-07 Nagappan A <[EMAIL PROTECTED]>
+
+ * Mono.Data.SqlExpressions/DataColumnExpressionTest.cs
+ (TestDataColumnExpr1, TestDataColumnExpr2): Added two functions to
+ test Data Column Expression.
Added:
trunk/mcs/class/System.Data/Test/Mono.Data.SqlExpressions/DataColumnExpressionTest.cs
===================================================================
---
trunk/mcs/class/System.Data/Test/Mono.Data.SqlExpressions/DataColumnExpressionTest.cs
2006-12-07 11:34:30 UTC (rev 69170)
+++
trunk/mcs/class/System.Data/Test/Mono.Data.SqlExpressions/DataColumnExpressionTest.cs
2006-12-07 11:37:11 UTC (rev 69171)
@@ -0,0 +1,41 @@
+using System;
+using System.Data;
+using NUnit.Framework;
+
+namespace Monotests_Mono.Data.SqlExpressions
+{
+ [TestFixture]
+ public class DataColumnExprTest
+ {
+ [Test]
+ public void TestDataColumnExpr1 ()
+ {
+ DataTable table = new DataTable ();
+ table.Columns.Add ("Col_0.Value", Type.GetType
("System.Int32"));
+ table.Columns.Add ("Col_1", Type.GetType
("System.Int32"));
+ table.Columns.Add ("Result", Type.GetType
("System.Int32"), "IIF(Col_0.Value > 10, Col_1 + 5, 0)");
+
+ DataRow row = table.NewRow ();
+ row ["Col_0.Value"] = 20;
+ row ["Col_1"] = 10;
+
+ table.Rows.Add (row);
+ Assert.AreEqual ((int)table.Rows[0][1] + 5,
table.Rows[0][2], "#1");
+ }
+ [Test]
+ public void TestDataColumnExpr2 ()
+ {
+ DataTable table = new DataTable ();
+ table.Columns.Add ("Col_0.Value", Type.GetType
("System.Int32"));
+ table.Columns.Add ("Col_1", Type.GetType
("System.Int32"));
+ table.Columns.Add ("Result", Type.GetType
("System.Int32"), "IIF(Col_0.Value > 10, Col_1 + 5, 0)");
+
+ DataRow row = table.NewRow ();
+ row ["Col_0.Value"] = 9;
+ row ["Col_1"] = 10;
+
+ table.Rows.Add (row);
+ Assert.AreEqual (0, (int)table.Rows[0][2], "#1");
+ }
+ }
+}
_______________________________________________
Mono-patches maillist - [email protected]
http://lists.ximian.com/mailman/listinfo/mono-patches
