2 using System.Collections.Generic;
\r
5 using NUnit.Framework;
\r
10 // test ns Linq_101_Samples
\r
12 namespace Test_NUnit_MySql.Linq_101_Samples
\r
14 namespace Test_NUnit_OracleODP.Linq_101_Samples
\r
16 namespace Test_NUnit_Oracle.Linq_101_Samples
\r
18 namespace Test_NUnit_PostgreSql.Linq_101_Samples
\r
20 namespace Test_NUnit_Sqlite.Linq_101_Samples
\r
22 namespace Test_NUnit_Ingres.Linq_101_Samples
\r
23 #elif MSSQL && MONO_STRICT
\r
24 namespace Test_NUnit_MsSql_Strict.Linq_101_Samples
\r
26 namespace Test_NUnit_MsSql.Linq_101_Samples
\r
28 namespace Test_NUnit_Firebird.Linq_101_Samples
\r
32 /// Source: http://msdn2.microsoft.com/en-us/vbasic/bb737930.aspx
\r
33 /// manually translated from VB into C#.
\r
36 public class NullTest : TestBase
\r
41 Northwind db = CreateDB();
\r
43 var q = from e in db.Employees
\r
44 where e.ReportsTo==null select e;
\r
46 List<Employee> list = q.ToList();
\r
47 Assert.IsTrue(list.Count > 0);
\r
51 public void NullableT_HasValue()
\r
53 Northwind db = CreateDB();
\r
55 var q = from e in db.Employees
\r
56 where !e.ReportsTo.HasValue select e;
\r
58 List<Employee> list = q.ToList();
\r
59 Assert.IsTrue(list.Count > 0);
\r
63 public void NullableT_Value()
\r
65 Northwind db = CreateDB();
\r
67 var q = from e in db.Employees
\r
68 where e.ReportsTo.HasValue
\r
69 select new { e.FirstName, e.LastName, ReportsTo = e.ReportsTo.Value };
\r
71 var list = q.ToList();
\r
72 Assert.IsTrue(list.Count > 0);
\r
76 public void Null_EX1()
\r
78 Northwind db = CreateDB();
\r
80 var q = from e in db.Employees
\r
81 where null == e.ReportsTo
\r
84 List<Employee> list = q.ToList();
\r
85 Assert.IsTrue(list.Count > 0);
\r
89 public void Null_EX2()
\r
91 Northwind db = CreateDB();
\r
93 var q = from e in db.Employees
\r
94 where null != e.ReportsTo
\r
97 List<Employee> list = q.ToList();
\r
98 Assert.IsTrue(list.Count > 0);
\r