1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
|
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using NUnit.Framework;
using Test_NUnit;
using nwind;
// test ns Linq_101_Samples
#if MYSQL
namespace Test_NUnit_MySql.Linq_101_Samples
#elif ORACLE && ODP
namespace Test_NUnit_OracleODP.Linq_101_Samples
#elif ORACLE
namespace Test_NUnit_Oracle.Linq_101_Samples
#elif POSTGRES
namespace Test_NUnit_PostgreSql.Linq_101_Samples
#elif SQLITE
namespace Test_NUnit_Sqlite.Linq_101_Samples
#elif INGRES
namespace Test_NUnit_Ingres.Linq_101_Samples
#elif MSSQL && L2SQL
namespace Test_NUnit_MsSql_Strict.Linq_101_Samples
#elif MSSQL
namespace Test_NUnit_MsSql.Linq_101_Samples
#elif FIREBIRD
namespace Test_NUnit_Firebird.Linq_101_Samples
#endif
{
/// <summary>
/// Source: http://msdn2.microsoft.com/en-us/vbasic/bb737930.aspx
/// manually translated from VB into C#.
/// </summary>
[TestFixture]
public class NullTest : TestBase
{
[Test]
public void Null()
{
Northwind db = CreateDB();
var q = from e in db.Employees
where e.ReportsTo==null select e;
List<Employee> list = q.ToList();
Assert.IsTrue(list.Count > 0);
}
[Test]
public void NullableT_HasValue()
{
Northwind db = CreateDB();
var q = from e in db.Employees
where !e.ReportsTo.HasValue select e;
List<Employee> list = q.ToList();
Assert.IsTrue(list.Count > 0);
}
[Test]
public void NullableT_Value()
{
Northwind db = CreateDB();
var q = from e in db.Employees
where e.ReportsTo.HasValue
select new { e.FirstName, e.LastName, ReportsTo = e.ReportsTo.Value };
var list = q.ToList();
Assert.IsTrue(list.Count > 0);
}
[Test]
public void Null_EX1()
{
Northwind db = CreateDB();
var q = from e in db.Employees
where null == e.ReportsTo
select e;
List<Employee> list = q.ToList();
Assert.IsTrue(list.Count > 0);
}
[Test]
public void Null_EX2()
{
Northwind db = CreateDB();
var q = from e in db.Employees
where null != e.ReportsTo
select e;
List<Employee> list = q.ToList();
Assert.IsTrue(list.Count > 0);
}
}
}
|
