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