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);
+		}
+	}
+}