public void SqlStatement_with_Values() {
var line = new Line(new object[] {"1", 2, true});
var result = DbAdapter.SqlCommandWithValues(
DbAdapter.CreateSqlCommandWithParameters(
"INSERT INTO x (a,b,c) VALUES (@a,@b,@c)", new[] {
new Column("a", typeof(string)),
new Column("b", typeof(int)),
new Column("c", typeof(bool))
}), line);
Assert.That(result.Parameters["a"].Value, Is.EqualTo("1"));
Assert.That(result.Parameters["b"].Value, Is.EqualTo(2));
Assert.That(result.Parameters["c"].Value, Is.EqualTo(true));
}
public void Ein_einzelner_String_kann_in_einen_Csv_String_konvertiert_werden() {
Line line = new Line(new object[] {"a"});
Assert.That(CsvAdapter.CsvLine(line.Values), Is.EqualTo("a"));
}
public void Mehrere_Ints_können_in_einen_Csv_String_konvertiert_werden() {
Line line = new Line(new object[] {1, 2, 3});
Assert.That(CsvAdapter.CsvLine(line.Values), Is.EqualTo("1;2;3"));
}
public void Mehrere_Strings_können_in_einen_Csv_String_konvertiert_werden() {
Line line = new Line(new object[] {"a", "b", "c"});
Assert.That(CsvAdapter.CsvLine(line.Values), Is.EqualTo("a;b;c"));
}
