public bool SetupCommand(IDataInteraction command)
{
command.ExecuteText(GetSql());
command.AddOutputParameter("@param", DbType.StringFixedLength, 4);
return(true);
}
public bool SetupCommand(IDataInteraction command)
{
command.ExecuteText(GetSql());
command.AddParameterWithValue("@documentId", _documentId);
command.AddParameterWithValue("@start", _start);
command.AddParameterWithValue("@pageSize", _pageSize);
return(true);
}
public bool SetupCommand(IDataInteraction command)
{
command.ExecuteText(@"
SELECT @value = 'param';
SELECT 'result';");
command.AddOutputParameter("@value", DbType.AnsiString, 5);
return(true);
}
public bool SetupCommand(IDataInteraction interaction)
{
interaction.ExecuteText("SELECT 1 UNION SELECT 2 UNION SELECT 3");
return(interaction.IsValid);
}
public bool SetupCommand(IDataInteraction interaction)
{
interaction.ExecuteText(_simple.GetSql());
return(interaction.IsValid);
}
public bool SetupCommand(IDataInteraction interaction)
{
interaction.ExecuteText("SELECT 'TEST'");
return(interaction.IsValid);
}
public bool SetupCommand(IDataInteraction command)
{
command.ExecuteText("SELECT @param = 'TEST';");
command.AddOutputParameter("@param", DbType.StringFixedLength, 4);
return(false);
}
public bool SetupCommand(IDataInteraction command)
{
command.ExecuteText("SELECT 'TEST';");
return(false);
}
public bool SetupCommand(IDataInteraction command)
{
command.ExecuteText("SELECT @param = 'TEST';");
command.AddOutputParameter("@param", DbType.AnsiString, 4);
return(true);
}
public bool SetupCommand(IDataInteraction interaction)
{
interaction.ExecuteText("SELECT @Value1 AS Value1, @Value2 AS Value2, @Value3 AS Value3;");
interaction.AddParametersWithValues(_values);
return(interaction.IsValid);
}
public bool SetupCommand(IDataInteraction interaction)
{
interaction.ExecuteText("SELECT @value = 5;");
interaction.AddOutputParameter("@value", DbType.Int32, 0);
return(true);
}
public bool SetupCommand(IDataInteraction interaction)
{
interaction.ExecuteText("SELECT @value = 'TEST';");
interaction.AddOutputParameter("@value", DbType.AnsiString, 8000);
return(true);
}