|
0
|
1 using System;
|
|
|
2
|
|
|
3 using NUnit.Framework;
|
|
|
4
|
|
|
5 using BLToolkit.Data;
|
|
|
6 using BLToolkit.DataAccess;
|
|
|
7 using BLToolkit.Mapping;
|
|
|
8
|
|
|
9 namespace HowTo.DataAccess
|
|
|
10 {
|
|
|
11 [TestFixture]
|
|
|
12 public class OpenConfigQuery
|
|
|
13 {
|
|
|
14 public class Person
|
|
|
15 {
|
|
|
16 [MapField("PersonID"), PrimaryKey, NonUpdatable]
|
|
|
17 public int ID;
|
|
|
18
|
|
|
19 public string LastName;
|
|
|
20 public string FirstName;
|
|
|
21 public string MiddleName;
|
|
|
22 }
|
|
|
23
|
|
|
24 // /*[i]*/DbManager/*[/i]*/ is created by /*[i]*/SqlQuery/*[/i]*/.
|
|
|
25 //
|
|
|
26 [Test]
|
|
|
27 public void Test1()
|
|
|
28 {
|
|
|
29 SqlQuery<Person> query = new SqlQuery<Person>/*[a]*/()/*[/a]*/;
|
|
|
30
|
|
|
31 Person person = query.SelectByKey(1);
|
|
|
32
|
|
|
33 Assert.IsNotNull(person);
|
|
|
34 }
|
|
|
35
|
|
|
36 // /*[i]*/SqlQuery/*[/i]*/ takes /*[i]*/DbManager/*[/i]*/ as a parameter.
|
|
|
37 //
|
|
|
38 [Test]
|
|
|
39 public void Test2()
|
|
|
40 {
|
|
|
41 using (DbManager db = new DbManager())
|
|
|
42 {
|
|
|
43 SqlQuery<Person> query = new SqlQuery<Person>/*[a]*/(db)/*[/a]*/;
|
|
|
44
|
|
|
45 Person person = query.SelectByKey(1);
|
|
|
46
|
|
|
47 Assert.IsNotNull(person);
|
|
|
48 }
|
|
|
49 }
|
|
|
50
|
|
|
51 // /*[i]*/SqlQuery/*[/i]*/ method takes /*[i]*/DbManager/*[/i]*/ as a parameter.
|
|
|
52 //
|
|
|
53 [Test]
|
|
|
54 public void Test3()
|
|
|
55 {
|
|
|
56 using (DbManager db = new DbManager())
|
|
|
57 {
|
|
|
58 SqlQuery<Person> query = new SqlQuery<Person>/*[a]*/()/*[/a]*/;
|
|
|
59
|
|
|
60 Person person = query.SelectByKey(/*[a]*/db/*[/a]*/, 1);
|
|
|
61
|
|
|
62 Assert.IsNotNull(person);
|
|
|
63 }
|
|
|
64 }
|
|
|
65 }
|
|
|
66 }
|
|
|
67
|
