public void TestSqlCe()
{
var insertSql = "insert into Test (TestColumn) values ('foo')";
ExecuteCommand(insertSql);
var query = "select count(*) from Test";
int count = 0;
using (var connection = new SqlCeConnection(_connectionString))
{
connection.Open();
var command = new SqlCeCommand(query, connection);
count = (int)command.ExecuteScalar();
}
Assert.AreEqual<int>(1, count);
}