public string GetData(int value) { List<BBandPassRate> lstPassRates = new List<BBandPassRate>(); using (NetaDBEntities neta = new NetaDBEntities()) { var myData = from p in neta.view_passrates_by_broadband select p; foreach(view_passrates_by_broadband viewItem in myData) { BBandPassRate bbRate = Utils.CreteBBandPassRateFromDBView(viewItem);
//Class methods used to assign DataContract object variables to database fields public static BBandPassRate CreteBBandPassRateFromDBView(view_passrates_by_broadband view) { BBandPassRate ret = new BBandPassRate(); ret.PostCode = view.postcode; ret.SchoolName = view.school_name; ret.PassRate = view.percent_5_pass_grades_gcse; ret.AverageSpeed = (decimal)view.average_speed_mbps; return ret; }
public List<BBandPassRate> MyView() { List<BBandPassRate> lstPassRates = new List<BBandPassRate>(); using (NetaDBEntities neta = new NetaDBEntities()) { var myData = from p in neta.view_passrates_by_broadband select p; foreach (view_passrates_by_broadband viewItem in myData) { BBandPassRate bbRate = Utils.CreteBBandPassRateFromDBView(viewItem); lstPassRates.Add(bbRate); } } return lstPassRates; }