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