|
0
|
1 using System;
|
|
|
2
|
|
|
3 using NUnit.Framework;
|
|
|
4
|
|
|
5 using BLToolkit.DataAccess;
|
|
|
6 using BLToolkit.Mapping;
|
|
|
7
|
|
|
8 namespace HowTo.DataAccess
|
|
|
9 {
|
|
|
10 [TestFixture]
|
|
|
11 public class MultiplePrimaryKey
|
|
|
12 {
|
|
|
13 [TableName("Person")]
|
|
|
14 public class Person
|
|
|
15 {
|
|
|
16 [MapField("PersonID"), NonUpdatable]
|
|
|
17 public int ID;
|
|
|
18
|
|
|
19 // These fields are not real primary key of the table.
|
|
|
20 // They are made primary key for demonstration purpose only.
|
|
|
21 //
|
|
|
22 [/*[a]*/PrimaryKey(1)/*[/a]*/] public string FirstName;
|
|
|
23 [/*[a]*/PrimaryKey(2)/*[/a]*/] public string LastName;
|
|
|
24
|
|
|
25 public string MiddleName;
|
|
|
26 }
|
|
|
27
|
|
|
28 [Test]
|
|
|
29 public void Test()
|
|
|
30 {
|
|
|
31 SqlQuery<Person> query = new SqlQuery<Person>();
|
|
|
32
|
|
|
33 Person person = query./*[a]*/SelectByKey("Tester", "Testerson")/*[/a]*/;
|
|
|
34
|
|
|
35 Assert.IsNotNull(person);
|
|
|
36 }
|
|
|
37 }
|
|
|
38 }
|
|
|
39
|
