//I have the following methods. I want to query a table data by using the output i got from previous query. I tried the below code but data does not load.
private void btnFetch_Click(object sender, RoutedEventArgs e) { ctx = new Context(); //Data loads here ctx.Load(ctx.GetQuery()).Completed += new EventHandler(Report_Completed); } void Report_Completed(object sender, EventArgs e) { int foundryId=1; //Data loads here ctx.Load(ctx.GetReportQuery(foundryId, (DateTime)fromDatePicker.SelectedDate, (DateTime)toDatePicker.SelectedDate)).Completed += loadCompleted; }
private void loadCompleted(object sender, EventArgs e) {
if (ctx.IsLoading) return; var report = ((LoadOperation<FilmConsumptionReportRow>)sender).Entities;
foreach (var r in report) {
//I am trying to load the data here. But data is null. ctxForPreviousREport = new RadiographyContext(); ctxForPreviousREport.Load(ctxForPreviousREport.GetRGReportsOnRtNoAndReshootNoQuery(r.RTNo, r.ReshootNo)); RGReport rGReport = ctxForPreviousREport.RGReports.FirstOrDefault(); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)