diff HowTo/DataAccess/CommandBehavior.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/CommandBehavior.cs	Thu Mar 27 21:46:09 2014 +0400
@@ -0,0 +1,34 @@
+using System.Data;
+
+using NUnit.Framework;
+
+using BLToolkit.Data;
+using BLToolkit.DataAccess;
+
+namespace HowTo.DataAccess
+{
+	[TestFixture]
+	public class CommandBehaviorDemo
+	{
+		public abstract class TestAccessor : DataAccessor
+		{
+			[SprocName("Person_SelectAll"), /*[a]*/CommandBehavior/*[/a]*/(CommandBehavior.SchemaOnly)]
+			public abstract IDataReader SelectAllIDataReaderSchemaOnly(DbManager db);
+		}
+
+		[Test]
+		public void Test()
+		{
+			TestAccessor ta = DataAccessor.CreateInstance<TestAccessor>();
+
+			using (DbManager   db = ta.GetDbManager())
+			using (IDataReader dr = ta.SelectAllIDataReaderSchemaOnly(db))
+			{
+				DataTable table = dr.GetSchemaTable();
+
+				Assert.AreEqual("PersonID",  table.Rows[0]["ColumnName"]);
+				Assert.AreEqual(typeof(int), table.Rows[0]["DataType"]);
+			}
+		}
+	}
+}