Esempio n. 1
0
        public void Bulk_ShouldInterceptWriteCommands()
        {
            const string
                                    CMD_1 = "DELETE FROM 'KUTYA'",
                                    CMD_2 = "DELETE FROM 'CICA'";

            var mockDbConnection = new Mock <IDbConnection>(MockBehavior.Strict);

            mockDbConnection.Setup(c => c.CreateCommand()).Returns(() => new SqlCommand());

            using (IBulkedDbConnection bulk = mockDbConnection.Object.CreateBulkedDbConnection())
            {
                foreach (string command in new[] { CMD_1, CMD_2 })
                {
                    using (IDbCommand cmd = bulk.CreateCommand())
                    {
                        cmd.CommandText = command;
                        cmd.ExecuteNonQuery();
                    }
                }

                Assert.That(bulk.ToString(), Is.EqualTo($"{CMD_1};\r\n{CMD_2};\r\n"));
            }
        }