Mercurial > pub > bltoolkit
diff HowTo/DataAccess/SqlQuery.cs @ 0:f990fcb411a9
Копия текущей версии из github
author | cin |
---|---|
date | Thu, 27 Mar 2014 21:46:09 +0400 |
parents | |
children |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/HowTo/DataAccess/SqlQuery.cs Thu Mar 27 21:46:09 2014 +0400 @@ -0,0 +1,36 @@ +using System; +using System.Collections.Generic; + +using NUnit.Framework; + +using BLToolkit.DataAccess; + +namespace HowTo.DataAccess +{ + [TestFixture] + public class SqlQuery + { + public abstract class TestAccessor : DataAccessor + { + [/*[a]*/SqlQuery/*[/a]*/(@" + SELECT + * + FROM + Person + WHERE + FirstName like @firstName AND + LastName like @lastName")] + public abstract List<Person> GetPersonListByName(string @firstName, string @lastName); + } + + [Test] + public void Test() + { + TestAccessor ta = DataAccessor.CreateInstance<TestAccessor>(); + + List<Person> list = ta.GetPersonListByName("John", "P%"); + + Assert.AreNotEqual(0, list.Count); + } + } +}