--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/UnitTests/Linq/TestAK107.cs	Thu Mar 27 21:46:09 2014 +0400
@@ -0,0 +1,188 @@
+using System;
+
+using BLToolkit.Data.Linq;
+using BLToolkit.Data.Sql.SqlProvider;
+using BLToolkit.DataAccess;
+using BLToolkit.Mapping;
+
+using NUnit.Framework;
+
+namespace Data.Linq
+{
+	[TestFixture, Category("Oracle")]
+	public class TestAK107 : TestBase
+	{
+		[TableName(Name = "t_test_user")]
+		public sealed class User
+		{
+			[PrimaryKey, Identity]
+			[SequenceName("sq_test_user")]
+			[MapField("user_id")]
+			public long Id { get; set; }
+
+			[NotNull, NonUpdatable(OnInsert = false)]
+			[MapField("name")]
+			public string Name { get; set; }
+		}
+
+		[TableName(Name = "t_test_user_contract")]
+		public sealed class Contract
+		{
+			[PrimaryKey, Identity]
+			[SequenceName("sq_test_user_contract")]
+			[MapField("user_contract_id")]
+			public long Id { get; set; }
+
+			[NotNull, NonUpdatable(OnInsert = false)]
+			[MapField("user_id")]
+			public long UserId { get; set; }
+
+			[Association(ThisKey = "UserId", OtherKey = "Id", CanBeNull = false)]
+			public User User { get; set; }
+
+			[NotNull, NonUpdatable(OnInsert = false)]
+			[MapField("contract_no")]
+			public long ContractNo { get; set; }
+
+			[NotNull]
+			[MapField("name")]
+			public string Name { get; set; }
+		}
+
+		[Test]
+		public void UserInsert([IncludeDataContexts("Oracle")] string context)
+		{
+			using (var db = new TestDbManager(context))
+			{
+				db.BeginTransaction();
+				db.Insert(new User { Name = "user" });
+			}
+		}
+
+		[Test]
+		public void UserInsertWithIdentity([IncludeDataContexts("Oracle")] string context)
+		{
+			using (var db = new TestDbManager(context))
+			{
+				db.BeginTransaction();
+				db.InsertWithIdentity(new User { Name = "user" });
+			}
+		}
+
+		[Test]
+		public void UserLinqInsert([IncludeDataContexts("Oracle")] string context)
+		{
+			using (var db = new TestDbManager(context))
+			{
+				db.BeginTransaction();
+				db.GetTable<User>().Insert(() => new User { Name = "user" });
+			}
+		}
+
+		[Test]
+		public void UserLinqInsertWithIdentity([IncludeDataContexts("Oracle")] string context)
+		{
+			using (var db = new TestDbManager(context))
+			{
+				db.BeginTransaction();
+				db.GetTable<User>().InsertWithIdentity(() => new User { Name = "user" });
+			}
+		}
+
+		[Test]
+		public void ContractInsert([IncludeDataContexts("Oracle")] string context)
+		{
+			using (var db = new TestDbManager(context))
+			{
+				db.BeginTransaction();
+
+				var user = new User { Name = "user" };
+				user.Id = Convert.ToInt64(db.InsertWithIdentity(user));
+
+				db.Insert(new Contract { UserId = user.Id, ContractNo = 1, Name = "contract1" });
+			}
+		}
+
+		[Test]
+		public void ContractInsertWithIdentity([IncludeDataContexts("Oracle")] string context)
+		{
+			using (var db = new TestDbManager(context))
+			{
+				db.BeginTransaction();
+
+				var user = new User { Name = "user" };
+				user.Id = Convert.ToInt64(db.InsertWithIdentity(user));
+
+				db.InsertWithIdentity(new Contract { UserId = user.Id, ContractNo = 1, Name = "contract" });
+			}
+		}
+
+		[SqlExpression("sq_test_user_contract.nextval")]
+		static long ContractSequence { get; set;  }
+
+		[Test]
+		public void ContractLinqInsert([IncludeDataContexts("Oracle")] string context)
+		{
+			using (var db = new TestDbManager(context))
+			{
+				db.BeginTransaction();
+
+				var user = new User { Name = "user" };
+				user.Id = Convert.ToInt64(db.InsertWithIdentity(user));
+
+				db.GetTable<Contract>().Insert(() => new Contract
+				{
+					Id         = ContractSequence,
+					UserId     = user.Id,
+					ContractNo = 1,
+					Name       = "contract"
+				});
+			}
+		}
+
+		[Test]
+		public void ContractLinqInsertWithIdentity([IncludeDataContexts("Oracle")] string context)
+		{
+			using (var db = new TestDbManager(context))
+			{
+				db.BeginTransaction();
+
+				var user = new User { Name = "user" };
+				user.Id = Convert.ToInt64(db.InsertWithIdentity(user));
+
+				db.GetTable<Contract>().InsertWithIdentity(() => new Contract { UserId = user.Id, ContractNo = 1, Name = "contract" });
+			}
+		}
+
+		[Test]
+		public void ContractLinqManyInsert([IncludeDataContexts("Oracle")] string context)
+		{
+			using (var db = new TestDbManager(context))
+			{
+				db.BeginTransaction();
+
+				var user = new User { Name = "user" };
+				user.Id = Convert.ToInt64(db.InsertWithIdentity(user));
+
+				db.GetTable<User>().Insert(db.GetTable<Contract>(), x => new Contract { UserId = x.Id, ContractNo = 1, Name = "contract" });
+			}
+		}
+
+		//[Test]
+		public void ContractLinqManyInsertWithIdentity([IncludeDataContexts("Oracle")] string context)
+		{
+			using (var db = new TestDbManager(context))
+			{
+				db.BeginTransaction();
+
+				var user = new User { Name = "user" };
+				user.Id = Convert.ToInt64(db.InsertWithIdentity(user));
+
+				db.GetTable<User>().InsertWithIdentity(db.GetTable<Contract>(), x => new Contract
+				{
+					UserId = x.Id, ContractNo = 1, Name = "contract"
+				});
+			}
+		}
+	}
+}