--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/UnitTests/Linq/UserTests/LetTest.cs	Thu Mar 27 21:46:09 2014 +0400
@@ -0,0 +1,96 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Linq.Expressions;
+
+using BLToolkit.Data.Linq;
+using BLToolkit.Mapping;
+
+using NUnit.Framework;
+
+namespace Data.Linq.UserTests
+{
+	[TestFixture]
+	public class LetTest : TestBase
+	{
+		class Table1
+		{
+			public int  Field3;
+			public int? Field5;
+
+			[Association(ThisKey="Field5", OtherKey="Field3", CanBeNull=true)]
+			public Table1 Ref1 { get; set; }
+
+			[Association(ThisKey="Field3", OtherKey="Field3", CanBeNull=true)]
+			public List<Table3> Ref2 { get; set; }
+		}
+
+		class Table2
+		{
+			public int? Field6;
+
+			[Association(ThisKey = "Field6", OtherKey = "Field6", CanBeNull = true)]
+			public Table3 Ref3 { get; set; }
+		}
+
+		class Table3
+		{
+			public int? Field6;
+			public int  Field3;
+			public int  Field4;
+
+			[Association(ThisKey="Field3", OtherKey="Field3", CanBeNull=true)]
+			public Table1 Ref4 { get; set; }
+
+			[Association(ThisKey="Field4", OtherKey="Field4", CanBeNull=true)]
+			public Table7 Ref5 { get; set; }
+
+			[Association(ThisKey = "Field6", OtherKey = "Field6", CanBeNull = true)]
+			public List<Table2> Ref9 { get; set; }
+		}
+
+		class Table7
+		{
+			public int    Field4;
+			public string Field8;
+		}
+
+		[Test]
+		public void LetTest1()
+		{
+			using (var repository = new TestDbManager())
+			{
+				var q =
+					from t1 in repository.GetTable<Table2>()
+					from t2 in 
+						from t5 in t1.Ref3.Ref4.Ref1.Ref2
+						let  t3 = t1.Ref3
+						where t3.Ref5.Field8 == t5.Ref5.Field8
+						from t4 in t5.Ref9
+						select t4
+					select t1;
+
+				var linqResult = q.ToString();
+			}
+		}
+
+		[Test]
+		public void LetTest2()
+		{
+			using (var repository = new TestDbManager())
+			{
+				var q =
+					from t1 in repository.GetTable<Table2>()
+					from t2 in 
+						from t5 in t1.Ref3.Ref4.Ref1.Ref2
+						let  t3 = t1.Ref3
+						where t3.Ref5 == t5.Ref5
+						from t4 in t5.Ref9
+						select t4
+					select t1;
+
+				var linqResult = q.ToString();
+			}
+		}
+	}
+}