private string TransactionQuery() { string Query = ""; foreach (var table in _tables) { var value = table.Value; foreach (var item in value) { Query += InsertQuery(item.Key, item.Value); } // Query += InsertQuery(table.Key, table.Value); } return(TransactionHelper.BuildQuery(Query)); // Query += "BEGIN BEGIN TRY "; // Query += "BEGIN TRANSACTION "; // foreach (var table in _tables) // { // var value = table.Value; // foreach (var item in value) // { // Query += InsertQuery(item.Key, item.Value); // } // // Query += InsertQuery(table.Key, table.Value); // } // Query += "COMMIT TRANSACTION "; // Query += "END TRY "; // Query += "BEGIN CATCH "; // Query += "ROLLBACK TRANSACTION "; // Query += "declare @strErrorMessage nvarchar(200),"; // Query += "@intErrorNumber int,"; // Query += "@intErrorSeverity int,"; // Query += "@intErrorState int,"; // Query += "@intErrorLine int,"; // Query += "@strErrorProcedure nvarchar(200)"; // Query += "SELECT @strErrorMessage = ERROR_MESSAGE(),"; // Query += "@intErrorNumber = ERROR_NUMBER(),"; // Query += "@intErrorSeverity = ERROR_SEVERITY(),"; // Query += "@intErrorState = ERROR_STATE(),"; // Query += "@intErrorLine = ERROR_LINE(),"; // Query += "@strErrorProcedure = ISNULL(ERROR_PROCEDURE(), '-');"; // Query += "RAISERROR(@strErrorMessage, @intErrorSeverity, 1, @intErrorNumber, @intErrorSeverity, @intErrorState, @strErrorProcedure, @intErrorLine);"; // Query += "END CATCH "; // Query += "END "; //return Query; }