public IEnumerable <PersistedMessage> ExecuteAndReadResults(SQLiteCommand command)
{
var reader = _queryExecutor.ExecuteReader(command);
var result = new List <PersistedMessage>();
while (reader.Read())
{
result.Add(new PersistedMessage()
{
TableId = reader.GetInt64(0),
Id = reader.GetString(1),
Type = reader.GetString(2),
Body = reader.GetString(3)
});
}
reader.Close();
return(result);
}
