Ado Net Data Services BeginExecute Problem

Question

public void metodoX()
{ 
 foreach (TURNO t in listaTurnoPersona)
 {
  DataServiceQuery<VST_CANTIDAD_PERSONAS_POR_DIA> query = 
    General.Entities.VST_CANTIDAD_PERSONAS_POR_DIA.Where(
                    z => z.ID_TURN == t.ID_TURN 
                        && z.FE_CALE >= RadDatePicker1.SelectedDate.Value
                        && z.FE_CALE <= RadDatePicker1.SelectedDate.Value.AddDays(6)) 
    as DataServiceQuery<VST_CANTIDAD_PERSONAS_POR_DIA>;
  query.BeginExecute(ProcesarHorarioPersonasTurno, query);
  //HERE THE ID_TURN CHANGE 1, 2, 3 , 4 ...
 }
}

public void ProcesarHorarioPersonasTurno(IAsyncResult result)
{
            List<VST_CANTIDAD_PERSONAS_POR_DIA> listaDias = (result.AsyncState as   DataServiceQuery<VST_CANTIDAD_PERSONAS_POR_DIA>).EndExecute(result).ToList();
         //HERE ALWAYS I GET THE RESULT IDTURN = 1}

---

Please Check the code above, why is happening this, is supposed that the ID_TURN also change, this doesn't was happening before.

Answer 1

You're capturing the iterator variable 't' in your invocation of Where(), which is a lambda expression:

Where( z => z.ID_TURN == t.ID_TURN && z.FE_CALE ...

By the time the queries execute, they're all referencing the same 't', which in your case is the final value before the loop terminates. In other words, they are all getting the same value for t.ID_TURN, which in your example is '1'.

To do this properly, declare a new variable:

var id = t.ID_TURN;

DataServiceQuery query = General.Entities.VST_CANTIDAD_PERSONAS_POR_DIA
    .Where( z => z.ID_TURN == id && 
        z.FE_CALE >= RadDatePicker1.SelectedDate.Value && 
        z.FE_CALE <= RadDatePicker1.SelectedDate.Value.AddDays(6)) 
    as DataServiceQuery;

This will capture a different variable for each invocation of Where, which will get the results you want.

Answer 2

With this, now the result.AsyncState URL is changing the ID_TURN value (before i only was getting the last one always(128M))

{http://localhost:888/Services/WebDataServiceSiata.svc/VST_CANTIDAD_PERSONAS_POR_DIA()?$filter=((**ID_TURN eq 21M**) and (FE_CALE ge datetime'2009-07-20T00:00:00-05:00')) and (FE_CALE le datetime'2009-07-26T00:00:00-05:00')}

But the EndExecuteResult is still returning listaDia[0].ID_TURN = 1

List listaDias = (result.AsyncState as DataServiceQuery).EndExecute(result).ToList()

Answer 3

i Found that the entity returned VST_CANTIDAD_PERSONAS_POR_DIA is just being created only once!(when the the method is called for first time); i think this maybe is because the model is in another project or because im using Entity framework extensions.

BTW im registered now, sorry thtat i add an answer but i can comment or edit the another post.