Mercurial > pub > bltoolkit
comparison HowTo/Data/ExecuteScalarList.cs @ 0:f990fcb411a9
Копия текущей версии из github
| author | cin |
|---|---|
| date | Thu, 27 Mar 2014 21:46:09 +0400 |
| parents | |
| children |
comparison
equal
deleted
inserted
replaced
| -1:000000000000 | 0:f990fcb411a9 |
|---|---|
| 1 using System; | |
| 2 using System.Collections.Generic; | |
| 3 | |
| 4 using NUnit.Framework; | |
| 5 | |
| 6 using BLToolkit.Data; | |
| 7 | |
| 8 namespace HowTo.Data | |
| 9 { | |
| 10 using DataAccess; | |
| 11 | |
| 12 [TestFixture] | |
| 13 public class ExecuteScalarList | |
| 14 { | |
| 15 List<string> GetNameList1() | |
| 16 { | |
| 17 using (DbManager db = new DbManager()) | |
| 18 { | |
| 19 return db | |
| 20 .SetCommand("SELECT FirstName FROM Person") | |
| 21 ./*[a]*/ExecuteScalarList/*[/a]*/<string>(); | |
| 22 } | |
| 23 } | |
| 24 | |
| 25 [Test] | |
| 26 public void Test1() | |
| 27 { | |
| 28 List<string> list = GetNameList1(); | |
| 29 | |
| 30 Assert.AreNotEqual(0, list.Count); | |
| 31 Assert.IsNotNull(list[0]); | |
| 32 } | |
| 33 | |
| 34 List<string> GetNameList2() | |
| 35 { | |
| 36 using (DbManager db = new DbManager()) | |
| 37 { | |
| 38 return db | |
| 39 .SetCommand("SELECT * FROM Person") | |
| 40 ./*[a]*/ExecuteScalarList/*[/a]*/<string>(/*[a]*/"FirstName"/*[/a]*/); | |
| 41 } | |
| 42 } | |
| 43 | |
| 44 [Test] | |
| 45 public void Test2() | |
| 46 { | |
| 47 List<string> list = GetNameList2(); | |
| 48 | |
| 49 Assert.AreNotEqual(0, list.Count); | |
| 50 Assert.IsNotNull(list[0]); | |
| 51 } | |
| 52 } | |
| 53 } |
