public static List<ResFile> GetAllFiles() { using (var dbManager = new DbManager("tmresource")) { var sql = new SqlQuery("res_files"); return dbManager.ExecuteList(sql.SelectAll()).Select(r => new ResFile { FileID = (int)r[0], ProjectName = (string)r[1], ModuleName = (string)r[2], FileName = (string)r[3] }).ToList(); } }