public virtual void Builds_RelationalCommand_without_optional_parameters()
{
var builder = new RawSqlCommandBuilder(
new RelationalCommandBuilderFactory(
new FakeSensitiveDataLogger<RelationalCommandBuilderFactory>(),
new DiagnosticListener("Fake"),
new FakeRelationalTypeMapper()),
new RelationalSqlGenerationHelper(),
new ParameterNameGeneratorFactory());
var command = builder.Build("SQL COMMAND TEXT");
Assert.Equal("SQL COMMAND TEXT", command.CommandText);
Assert.Equal(0, command.Parameters.Count);
}
public virtual void Builds_RelationalCommand_with_empty_parameter_list()
{
var builder = new RawSqlCommandBuilder(
new RelationalCommandBuilderFactory(
new FakeSensitiveDataLogger<RelationalCommandBuilderFactory>(),
new DiagnosticListener("Fake"),
new FakeRelationalTypeMapper()),
new RelationalSqlGenerationHelper(),
new ParameterNameGeneratorFactory());
var rawSqlCommand = builder.Build("SQL COMMAND TEXT", new object[0]);
Assert.Equal("SQL COMMAND TEXT", rawSqlCommand.RelationalCommand.CommandText);
Assert.Equal(0, rawSqlCommand.RelationalCommand.Parameters.Count);
Assert.Equal(0, rawSqlCommand.ParameterValues.Count);
}
public virtual void Builds_RelationalCommand_with_parameters()
{
var builder = new RawSqlCommandBuilder(
new RelationalCommandBuilderFactory(
new FakeSensitiveDataLogger<RelationalCommandBuilderFactory>(),
new DiagnosticListener("Fake"),
new FakeRelationalTypeMapper()),
new RelationalSqlGenerationHelper(),
new ParameterNameGeneratorFactory());
var rawSqlCommand = builder.Build("SQL COMMAND TEXT {0} {1} {2}", new object[] { 1, 2L, "three" });
Assert.Equal("SQL COMMAND TEXT @p0 @p1 @p2", rawSqlCommand.RelationalCommand.CommandText);
Assert.Equal(3, rawSqlCommand.RelationalCommand.Parameters.Count);
Assert.Equal("p0", rawSqlCommand.RelationalCommand.Parameters[0].InvariantName);
Assert.Equal("p1", rawSqlCommand.RelationalCommand.Parameters[1].InvariantName);
Assert.Equal("p2", rawSqlCommand.RelationalCommand.Parameters[2].InvariantName);
Assert.Equal(3, rawSqlCommand.ParameterValues.Count);
Assert.Equal(1, rawSqlCommand.ParameterValues["p0"]);
Assert.Equal(2L, rawSqlCommand.ParameterValues["p1"]);
Assert.Equal("three", rawSqlCommand.ParameterValues["p2"]);
}