Mostrando filas de un sdf.

Ahí va el código enterito de un método que realiza una consulta
select contra la BD:


public List<Food> RetrieveFoods(string foodType)
{
SqlCeConnection connection = new
SqlCeConnection(Constants.ConnectionString);
SqlCeResultSet resultSet = null;
List<Food> foodList = new List<Food>();
try
{
connection.Open();

string query = "SELECT FoodId, FoodName, Calories FROM
Food WHERE FoodFamily=" + foodType;
SqlCeCommand command = new SqlCeCommand(query,
connection);
resultSet command.ExecuteResultSet(ResultSetOptions.Scrollable);
if (resultSet != null && resultSet.HasRows)
{
while (resultSet.Read())
{
Food f = new Food();
f.FoodId = resultSet.GetValue(0).ToString();
f.FoodName = resultSet.GetString(1);
f.Calories = !resultSet.IsDBNull(8) ?
resultSet.GetInt32(8) : int.MinValue;
foodList.Add(f);
}
}
}
catch (Exception ex)
{
throw;
}
finally
{
connection.Close();
}
return foodList;
}

SaludoX.