private void AddCommandWithParameters(string commandText, IDictionary <string, object> parameters) { string statementText; using (var command = new SqlCommand()) { command.CommandText = commandText; if (parameters != null) { foreach (var p in parameters) { SqlHelper.AddParamWithValue(command, p.Key, p.Value); } } statementText = SqlCommandDumper.GetCommandText(command); } AddScript(statementText); }
private void AddCommandWithParameters(string commandText, IDictionary <string, object> parameters) { string statementText; using (var command = new SqlCommand()) { command.CommandText = DatabaseCaretReferences.Replace(commandText); if (parameters != null) { var dialect = command.Connection.GetDialect(); foreach (var p in parameters) { SqlHelper.AddParamWithValue(command, p.Key, p.Value, dialect); } } statementText = SqlCommandDumper.GetCommandText(command); } AddScript(statementText); }