public IEnumerable <ApplicationRecordModel> GetApplications() { var statement = "SELECT t.Id, UserName, Date, CardName FROM TransactionLog t LEFT JOIN CreditCards c ON t.CardId = c.Id"; var json = databaseAccess.ReadMultipleAsJSON(statement); var records = json.Select(j => JsonConvert.DeserializeObject <ApplicationRecordModel>(j)); return(records); }