public virtual void Builds_RelationalCommand_with_parameters()
{
var builder = new SqlCommandBuilder(
new RelationalCommandBuilderFactory(
new FakeSensitiveDataLogger<RelationalCommandBuilderFactory>(),
new DiagnosticListener("Fake"),
new FakeRelationalTypeMapper()),
new RelationalSqlGenerator(),
new ParameterNameGeneratorFactory());
var command = builder.Build("SQL COMMAND TEXT {0} {1} {2}", new object[] { 1, 2L, "three" });
Assert.Equal("SQL COMMAND TEXT @p0 @p1 @p2", command.CommandText);
Assert.Equal(3, command.Parameters.Count);
Assert.Equal("@p0", command.Parameters[0].Name);
Assert.Equal("@p1", command.Parameters[1].Name);
Assert.Equal("@p2", command.Parameters[2].Name);
Assert.Equal(1, command.Parameters[0].Value);
Assert.Equal(2L, command.Parameters[1].Value);
Assert.Equal("three", command.Parameters[2].Value);
Assert.Equal(DbType.Int32, command.Parameters[0].RelationalTypeMapping.StoreType);
Assert.Equal(DbType.Int64, command.Parameters[1].RelationalTypeMapping.StoreType);
Assert.Equal(DbType.String, command.Parameters[2].RelationalTypeMapping.StoreType);
}
public virtual void Builds_RelationalCommand_with_empty_parameter_list()
{
var builder = new SqlCommandBuilder(
new RelationalCommandBuilderFactory(
new FakeSensitiveDataLogger<RelationalCommandBuilderFactory>(),
new DiagnosticListener("Fake"),
new FakeRelationalTypeMapper()),
new RelationalSqlGenerator(),
new ParameterNameGeneratorFactory());
var command = builder.Build("SQL COMMAND TEXT", new object[0]);
Assert.Equal("SQL COMMAND TEXT", command.CommandText);
Assert.Equal(0, command.Parameters.Count);
}
