Mercurial > pub > bltoolkit
diff UnitTests/Linq/ProviderSpecific/Firebird.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/Linq/ProviderSpecific/Firebird.cs Thu Mar 27 21:46:09 2014 +0400 @@ -0,0 +1,50 @@ +using System; +using System.Linq; + +using BLToolkit.Data.DataProvider; +using BLToolkit.Data.Linq; + +using NUnit.Framework; + +using UnitTests.Linq.Interface.Model; + +namespace Data.Linq.ProviderSpecific +{ + [TestFixture, Category("Firebird")] + public class Firebird : TestBase + { + [Test] + public void SequenceInsert([IncludeDataContexts(ProviderName.Firebird)] string context) + { + using (var db = new TestDbManager(context)) + { + db.GetTable<FirebirdSpecific.SequenceTest>().Where(_ => _.Value == "SeqValue").Delete(); + db.Insert(new FirebirdSpecific.SequenceTest { Value = "SeqValue" }); + + var id = db.GetTable<FirebirdSpecific.SequenceTest>().Single(_ => _.Value == "SeqValue").ID; + + db.GetTable<FirebirdSpecific.SequenceTest>().Where(_ => _.ID == id).Delete(); + + Assert.AreEqual(0, db.GetTable<FirebirdSpecific.SequenceTest>().Count(_ => _.Value == "SeqValue")); + } + } + + [Test] + public void SequenceInsertWithIdentity([IncludeDataContexts(ProviderName.Firebird)] string context) + { + using (var db = new TestDbManager(context)) + { + db.GetTable<FirebirdSpecific.SequenceTest>().Where(_ => _.Value == "SeqValue").Delete(); + + var id1 = Convert.ToInt32(db.InsertWithIdentity(new FirebirdSpecific.SequenceTest { Value = "SeqValue" })); + var id2 = db.GetTable<FirebirdSpecific.SequenceTest>().Single(_ => _.Value == "SeqValue").ID; + + Assert.AreEqual(id1, id2); + + db.GetTable<FirebirdSpecific.SequenceTest>().Where(_ => _.ID == id1).Delete(); + + Assert.AreEqual(0, db.GetTable<FirebirdSpecific.SequenceTest>().Count(_ => _.Value == "SeqValue")); + } + } + } +}