Added test to verify trigger execution.

Master Garrett · Master Garrett · commit faf79a164477 · 2013-02-25T23:51:49.000+01:00
diff --git a/Simple.Data.SqlTest/BulkInsertTest.cs b/Simple.Data.SqlTest/BulkInsertTest.cs
@@ -1,4 +1,6 @@
-﻿namespace Simple.Data.SqlTest
+﻿using Simple.Data.Ado;
+
+namespace Simple.Data.SqlTest
 {
     using System.Collections.Generic;
     using System.Diagnostics;
@@ -31,6 +33,25 @@ public void BulkInsertUsesSchema()
             Assert.AreEqual(1000, list.Count);
         }
 
+        [Test]
+        public void BulkInsertUsesSchemaAndFireTriggers()
+        {
+            var db = DatabaseHelper.Open();
+
+            using (var tx = db.BeginTransaction())
+            {
+                tx.WithOptions(new AdoOptions(commandTimeout: 60000, fireTriggersOnBulkInserts: true));
+                tx.test.SchemaTable.DeleteAll();
+                tx.test.SchemaTable.Insert(GenerateItems());
+
+                tx.Commit();
+            }
+
+            int rowsWhichWhereUpdatedByTrigger = db.test.SchemaTable.GetCountBy(Optional: "Modified By Trigger");
+
+            Assert.AreEqual(1000, rowsWhichWhereUpdatedByTrigger);
+        }
+
         private static IEnumerable<SchemaItem> GenerateItems()
         {
             for (int i = 0; i < 1000; i++)
