private void LoadData(DateTime dt, int SensorID) { stackpanel.Children.Clear(); db = new DbContext(); EntityQuery<vwSensorValuesAndTC10MinDataLog> qry = from n in db.GetVwSensorValuesAndTC10MinDataLogQuery() where n.TIMESTAMP >= dt && n.TIMESTAMP < dt.AddDays(1) && n.SENSOR_ID == SensorID && n.ISVALID == "Y" orderby n.TIMESTAMP select n; //EntityQuery qry = from n in db.GetTblTC10MinDataLogQuery() // join m in db.GetTblSensor_ValuesQuery() on n.SensorID equals m.SensorID // where n.TIMESTAMP >= dt && n.TIMESTAMP < dt.AddDays(1) && n.SENSOR_ID == SensorID && n.ISVALID == "Y" // orderby n.TIMESTAMP // select new { n., m }; LoadOperation<vwSensorValuesAndTC10MinDataLog> lo = db.Load<vwSensorValuesAndTC10MinDataLog>(qry); lo.Completed += (s, a) => { if (lo.Error != null) { MessageBox.Show(lo.Error.Message); return; } db.Load<tblSensor>(db.GetTblSensorQuery().Where(dd => dd.SENSOR_ID == SensorID)).Completed += (ss, aa) => { if ((ss as LoadOperation).Error != null) { MessageBox.Show((ss as LoadOperation).Error.Message); return; } //tblTC10MinDataLog data = new tblTC10MinDataLog(); //in db.tblTC10MinDataLogs if (db.tblSensors.FirstOrDefault().SENSOR_TYPE == "TILT") { IsTilt = 1; vcnt = 3; } else vcnt = 3; for (int i = 1; i <= vcnt; i++) { CreateChart(i); } //db.Load<tblSensor_Values>(db.GetTblSensor_ValuesQuery().Where(dv => dv.SENSOR_ID == SensorID)).Completed += (sss, aaa) // => // { // initmean = db.tblSensor_Values.FirstOrDefault().INITMEAN; // sigma = db.tblSensor_Values.FirstOrDefault().SIGMA; // }; }; }; }