diff UnitTests/CS/Data/Sql/SelectTest.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/UnitTests/CS/Data/Sql/SelectTest.cs	Thu Mar 27 21:46:09 2014 +0400
@@ -0,0 +1,61 @@
+using System;
+using NUnit.Framework;
+using BLToolkit.Data.Sql;
+
+namespace Data.Sql
+{
+	[TestFixture]
+	public class SelectTest
+	{
+		public static SqlTable Order = new SqlTable
+		{
+			Name   = "Order",
+			Fields = { new SqlField { Name = "ID" }, new SqlField { Name = "Number" } }
+		};
+
+		[Test]
+		public void Test1()
+		{
+			var sb = new SqlQuery();
+
+			sb
+				.Select
+					.Field(Order["ID"])
+					.Field(Order["Number"])
+				;
+
+			Assert.AreEqual(2, sb.Select.Columns.Count);
+		}
+
+		[Test]
+		public void Test2()
+		{
+			var sb = new SqlQuery();
+
+			sb
+				.Select
+					.Field(Order["ID"])
+					.Field(Order["Number"])
+					.Field(Order["ID"])
+				;
+
+			Assert.AreEqual(2, sb.Select.Columns.Count);
+		}
+
+		[Test]
+		public void Test3()
+		{
+			var sb = new SqlQuery();
+
+			sb
+				.Select
+					.Field(Order["ID"], "id1")
+					.Field(Order["ID"])
+					.Expr("{0} + {1}", Order["Number"], Order["Number"])
+					.Expr(new SqlExpression("{0} + {1}", Order["Number"], Order["Number"]))
+				;
+
+			Assert.AreEqual(2, sb.Select.Columns.Count);
+		}
+	}
+}