public HydraAppsModel GetApplications() { HydraAppsModel model = new HydraAppsModel(); using (SQLiteConnection connection = this.OpenConnection()) { string commandText = @"SELECT ap.uid , ap.app_name , ap.app_url , ap.description , dv.id AS developer_id , dv.dev_name AS developer_name FROM application ap LEFT JOIN developer dv ON dv.id = ap.developer_id ORDER BY ap.app_name "; using (DataTable dtApplications = this.Fill(commandText)) { foreach (DataRow app in dtApplications.Rows) { model.Add(new HydraAppModel() { UId = TryParse.ToGuid(app["uid"]), Name = TryParse.ToString(app["app_name"]), DeveloperId = TryParse.ToInt32(app["developer_id"]), DeveloperName = TryParse.ToString(app["developer_name"]), AppUrl = TryParse.ToString(app["app_url"]), Description = TryParse.ToString(app["description"]) }); } } } return(model); }