comparison HowTo/DataAccess/ExecuteScalar.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
3 using NUnit.Framework;
4
5 using BLToolkit.DataAccess;
6
7 namespace HowTo.DataAccess
8 {
9 [TestFixture]
10 public class ExecuteScalar
11 {
12 public abstract class /*[a]*/PersonAccessor/*[/a]*/ : /*[a]*/DataAccessor/*[/a]*/<Person>
13 {
14 [SqlQuery("SELECT Count(*) FROM Person")]
15 public abstract int GetCount();
16
17 // The Person_Insert sproc returns an id of the created record.
18 //
19 [SprocName("Person_Insert")]
20 public abstract /*[a]*/int/*[/a]*/ Insert(Person person);
21 }
22
23 [Test]
24 public void Test()
25 {
26 PersonAccessor pa = DataAccessor.CreateInstance<PersonAccessor>();
27
28 // ExecuteScalar.
29 //
30 Assert.IsTrue(pa.GetCount() > 0);
31
32 // Insert and get id.
33 //
34 Person person = new Person();
35
36 person.FirstName = "Crazy";
37 person.LastName = "Frog";
38 person.Gender = Gender.Unknown;
39
40 int id = pa./*[a]*/Insert(person)/*[/a]*/;
41
42 Assert.IsFalse(id == 0);
43
44 new SprocQuery<Person>().DeleteByKey(id);
45 }
46 }
47 }