public IEnumerable<object> GetAllEventsEver()
{
const string cmdText = "SELECT EventType, BODY from EventWrappers ORDER BY TimeStamp";
var connectionString = ConfigurationManager.ConnectionStrings["main"].ConnectionString;
using (var con = new SqlCeConnection(connectionString))
using (var cmd = new SqlCeCommand(cmdText, con))
{
cmd.Connection.Open();
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var eventTypeString = reader["EventType"].ToString();
var eventType = Type.GetType(eventTypeString);
var serializedBody = reader["Body"].ToString();
yield return JsonConvert.DeserializeObject(serializedBody, eventType);
}
}
}