diff HowTo/Data/ExecuteScalarList.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/Data/ExecuteScalarList.cs	Thu Mar 27 21:46:09 2014 +0400
@@ -0,0 +1,53 @@
+using System;
+using System.Collections.Generic;
+
+using NUnit.Framework;
+
+using BLToolkit.Data;
+
+namespace HowTo.Data
+{
+	using DataAccess;
+
+	[TestFixture]
+	public class ExecuteScalarList
+	{
+		List<string> GetNameList1()
+		{
+			using (DbManager db = new DbManager())
+			{
+				return db
+					.SetCommand("SELECT FirstName FROM Person")
+					./*[a]*/ExecuteScalarList/*[/a]*/<string>();
+			}
+		}
+
+		[Test]
+		public void Test1()
+		{
+			List<string> list = GetNameList1();
+
+			Assert.AreNotEqual(0, list.Count);
+			Assert.IsNotNull(list[0]);
+		}
+
+		List<string> GetNameList2()
+		{
+			using (DbManager db = new DbManager())
+			{
+				return db
+					.SetCommand("SELECT * FROM Person")
+					./*[a]*/ExecuteScalarList/*[/a]*/<string>(/*[a]*/"FirstName"/*[/a]*/);
+			}
+		}
+
+		[Test]
+		public void Test2()
+		{
+			List<string> list = GetNameList2();
+
+			Assert.AreNotEqual(0, list.Count);
+			Assert.IsNotNull(list[0]);
+		}
+	}
+}