public void TestSelectTable()
{
const string sqlSelectTable = "select 1, 2, 3 union select 4, 5, 6;";
var xQuery = new XQuerySqlite(SetUp.SqliteConnectionString);
var result = xQuery.SelectTable(sqlSelectTable);
Assert.AreEqual(2 * 3, result.Rows.Count * result.Columns.Count);
}
public void TestArgumentsCanBeSpecifiedWithinSelectTable()
{
var xQuery = new XQuerySqlite(SetUp.SqliteConnectionString);
const string value = "asd";
var result = xQuery.SelectTable("select @a;", new XParameter("@a", value))
.Rows[0].ItemArray[0];
Assert.AreEqual(result, value);
}
