public void BulkSqlInsertTest() { #region --Arrange -- var result = false; #endregion #region --Act -- var dataTable = _workService.LoadAndDataFile(_path); try { _workRepository.BulkInsert(dataTable); Trace.WriteLine(string.Format("Successfully Uploaded: {0}", dataTable.Rows.Count)); result = true; } catch (Exception exception) { Trace.WriteLine(exception.Message); } #endregion #region --Assert -- Assert.IsTrue(result); #endregion }