public void ReturnSimpleScalar()
{
ExecuteSQL("CREATE TABLE test(id INT)");
ExecuteSQL("INSERT INTO test VALUES (1)");
SqlResult r = GetSession(true).SQL("SELECT * FROM test").Execute();
Assert.True(r.Next());
Assert.Equal(1, r[0]);
Assert.False(r.NextResult());
}