Inheritance: ISqlBulkInserter
        public void SqlBulkInserter_Constructor_WhenCreatingNew_ExpectValidObject()
        {
            //------------Setup for test--------------------------
            var bulkInserter = new SqlBulkInserter();

            //------------Execute Test---------------------------

            //------------Assert Results-------------------------
            Assert.IsNotNull(bulkInserter);
        }
        public void SqlBulkInserter_Insert_WhenInsertingNullTableData_ExpectInsertFailure()
        {
            //------------Setup for test--------------------------
            var bulkInserter = new SqlBulkInserter();
            Mock<ISqlBulkCopy> bulkCopy = new Mock<ISqlBulkCopy>();
            bulkCopy.Setup(b => b.WriteToServer(It.IsAny<DataTable>())).Returns(false);

            //------------Execute Test---------------------------
            var result = bulkInserter.Insert(bulkCopy.Object, (DataTable)null);

            //------------Assert Results-------------------------
            Assert.IsFalse(result);
        }
        public void SqlBulkInserter_Insert_WhenInsertingTableData_ExpectInsertSuccess()
        {
            //------------Setup for test--------------------------
            var bulkInserter = new SqlBulkInserter();
            Mock<ISqlBulkCopy> bulkCopy = new Mock<ISqlBulkCopy>();
            bulkCopy.Setup(b => b.WriteToServer(It.IsAny<DataTable>())).Returns(true);
            DataTable dt = new DataTable("myTable");

            //------------Execute Test---------------------------
            var result = bulkInserter.Insert(bulkCopy.Object, dt);

            //------------Assert Results-------------------------
            Assert.IsTrue(result);
        }