public static Dictionary <DateTime, decimal> getShareValues(string shareID) { var values = new Dictionary <DateTime, decimal>(); using (DataBaseAccessDataContext asdc = new DataBaseAccessDataContext()) { var shareQuery = (from share in asdc.HistoricalShareValues where share.id == shareID orderby share.date select share); foreach (var share in shareQuery) { values.Add(share.date, share.value); } } return(values); }
public static List <Share> getShares() { List <Share> allShares = new List <Share>(); using (DataBaseAccessDataContext asdc = new DataBaseAccessDataContext()) { var allSharesQuery = (from share in asdc.ShareNames select share).Distinct(); foreach (var share in allSharesQuery) { Share newShare = new Share(share.name, share.id); allShares.Add(newShare); } } return(allShares); }