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