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);
}
