DevForce Community Forum : Query Search Many to many

Query Search Many to many : Hi DenisThanks for help.. This...

Fri, 08 Oct 2010 12:07:38 -700

Author: bala
Subject: 2215
Posted: 08-Oct-2010 at 12:07pm

Hi Denis

Thanks for help.. This code works..

Query Search Many to many : Hi Bala;Could you try and change...

Wed, 06 Oct 2010 11:12:41 -700

Author: DenisK
Subject: 2215
Posted: 06-Oct-2010 at 11:12am

Hi Bala;

Could you try and change your query as follows

_em.PESSOA_PROFISSAO_GRUPOS

.Where(f => f.ID_PESSOA_PROFISSAO_GRUPO == PessoaProfissaoGrupo.ID_PESSOA_PROFISSAO_GRUPO)

.Include(f => PESSOA_PROFISSAO)

.ExecuteAsync(op =>

{

//Rest of the code here

});

Query Search Many to many : Hi ThereI have one problem in...

Wed, 06 Oct 2010 06:52:46 -700

Author: bala
Subject: 2215
Posted: 06-Oct-2010 at 6:52am

Hi There

I have one problem in searching recrods

When I search record first time it return nothing in first click but second click
it returning the records...
I using following code.
Where Is Mistake?

ObservableCollection Profissoes = new ObservableCollection();

_em.PESSOA_PROFISSAO_GRUPOS.Where(f => f.ID_PESSOA_PROFISSAO_GRUPO == PessoaProfissaoGrupo.ID_PESSOA_PROFISSAO_GRUPO).ExecuteAsync(op =>

         {
             if (op.IsCompleted)
             {
                 op.Results.FirstOrDefault().PESSOA_PROFISSAO.ForEach(Profissoes.Add);

agDataGrid3.DataSource = Profissoes;

             }
             else
             {

                 MessageBox.Show(op.Error.Message);
             }
         });

Thanks