public void RetriveResultSetFromNullSqlCommandThrows()
{
using (TestResourceFile dbFile = new TestResourceFile(this, "Datastore.sdf"))
{
using (SmartClientDatabase database = DatabaseFactory.CreateDatabase() as SmartClientDatabase)
{
database.ExecuteResultSet((SqlCeCommand)null, ResultSetOptions.None);
}
}
}
public void RetriveResultSetFromEmptySqlStringThrows()
{
using (TestResourceFile dbFile = new TestResourceFile(this, "Datastore.sdf"))
{
using (SmartClientDatabase database = DatabaseFactory.CreateDatabase() as SmartClientDatabase)
{
database.ExecuteResultSet("", ResultSetOptions.None);
}
}
}
public void ExecuteResultSetCanBeScrollable()
{
using (TestResourceFile dbFile = new TestResourceFile(this, "Datastore.sdf"))
{
using (SmartClientDatabase database = DatabaseFactory.CreateDatabase() as SmartClientDatabase)
{
string queryString = @"select * From TestTable";
using (SqlCeResultSet result = database.ExecuteResultSet(queryString, ResultSetOptions.Scrollable))
{
Assert.IsNotNull(result);
}
}
}
}
public void ExecuteResultSetReturnExpectedValues()
{
using (TestResourceFile dbFile = new TestResourceFile(this, "Datastore.sdf"))
{
using (SmartClientDatabase database = DatabaseFactory.CreateDatabase() as SmartClientDatabase)
{
string queryString = @"select * From TestTable";
using (SqlCeResultSet result = database.ExecuteResultSet(queryString, ResultSetOptions.Scrollable))
{
Assert.IsTrue(result.HasRows);
Assert.AreEqual(2, result.FieldCount);
}
}
}
}
public void ExecuteResultSetFromSqlStringSucceeds()
{
using (TestResourceFile dbFile = new TestResourceFile(this, "Datastore.sdf"))
{
using (SmartClientDatabase database = DatabaseFactory.CreateDatabase() as SmartClientDatabase)
{
string queryString = @"select * from TestTable";
using (SqlCeResultSet resultSet = database.ExecuteResultSet(queryString, ResultSetOptions.None))
{
Assert.IsNotNull(resultSet);
Assert.IsFalse(resultSet.IsClosed);
}
}
}
}
public void ExecuteResultSetFromSqlCommandSucceeds()
{
using (TestResourceFile dbFile = new TestResourceFile(this, "Datastore.sdf"))
{
using (SmartClientDatabase database = DatabaseFactory.CreateDatabase() as SmartClientDatabase)
{
SqlCeCommand queryCommand = new SqlCeCommand();
string queryString = @"select * From TestTable";
queryCommand.CommandText = queryString;
using (SqlCeResultSet result = database.ExecuteResultSet(queryCommand, ResultSetOptions.None))
{
Assert.IsNotNull(result);
Assert.IsFalse(result.IsClosed);
}
}
}
}