Mercurial > pub > bltoolkit

comparison HowTo/DataAccess/Param.cs @ 0:f990fcb411a9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Копия текущей версии из 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.Data;
3
4 using NUnit.Framework;
5
6 using BLToolkit.Data;
7 using BLToolkit.DataAccess;
8
9 namespace HowTo.DataAccess
10 {
11 [TestFixture]
12 public class Param
13 {
14 public abstract class TestAccessor : DataAccessor
15 {
16 [SqlQuery("SELECT {0} = {1} FROM Person WHERE PersonID = 1")]
17 public abstract void SelectJohn(
18 [/*[a]*/ParamSize/*[/a]*/(50), /*[a]*/ParamDbType/*[/a]*/(DbType.String)] out string name,
19 [Format] string paramName,
20 [Format] string fieldName);
21 }
22
23 [Test]
24 public void AccessorTest()
25 {
26 using (DbManager db = new DbManager())
27 {
28 TestAccessor ta = DataAccessor.CreateInstance<TestAccessor>(db);
29
30 string actualName;
31
32 ta.SelectJohn(out actualName, "@name", "FirstName");
33
34 Assert.AreEqual("John", actualName);
35 }
36 }
37 }
38 }