mcs/class/System.Data/Test/Mono.Data.SqlExpressions/DateComparisonTest.cs

   1 using System;\r
   2 using System.Data;\r
   3 using NUnit.Framework;\r
   4 \r
   5 namespace Monotests_Mono.Data.SqlExpressions\r
   6 {\r
   7         [TestFixture]   \r
   8         public class DateComparisonTest\r
   9         {\r
  10                 private DataSet dataSet;\r
  11 \r
  12                 [SetUp]\r
  13                 public void SetUp()\r
  14                 {\r
  15                         dataSet = new DataSet();\r
  16                         dataSet.ReadXml("Test/Mono.Data.SqlExpressions/dateComparisonTest.xml", XmlReadMode.InferSchema);\r
  17                 }\r
  18 \r
  19                 [Test]\r
  20                 public void TestDateComparisonRight()\r
  21                 {\r
  22                         DataView dataView = new DataView(dataSet.Tables["thing"], "#2009-07-19 00:01:00# = start", "", DataViewRowState.CurrentRows);\r
  23                         Assert.AreEqual (1, dataView.Count);\r
  24                 }\r
  25                 \r
  26                 [Test]\r
  27                 [Category ("NotWorking")]\r
  28                 public void TestDateComparisonLeft()\r
  29                 {\r
  30                         DataView dataView = new DataView(dataSet.Tables["thing"], "start = #2009-07-19 00:01:00#", "", DataViewRowState.CurrentRows);\r
  31                         Assert.AreEqual (1, dataView.Count);\r
  32                 }\r
  33         }\r
  34 }\r