DevForce Community Forum : Async anonymous LINQ query

Async anonymous LINQ query : Hi chuckc, I tried an equivalentquery...

Thu, 16 Sep 2010 18:35:02 -700

Author: ting
Subject: 2120
Posted: 16-Sep-2010 at 6:35pm

Hi chuckc,

I tried an equivalent query and did not need the cast to the EntityQuery and was able to get the strong typing in the results.

Async anonymous LINQ query : Here's another related example...

Fri, 10 Sep 2010 08:58:36 -700

Author: chuckc
Subject: 2120
Posted: 10-Sep-2010 at 8:58am

Here's another related example of where the type information isn't available in the async result. This scenario doesn't involve a GroupBy:

var q0 = Repository.EntityManager.Certificates.Select(c =>

new { PersonLastName = c.Provider.Person.LastName,

PersonFirstName = c.Provider.Person.FirstName });

foreach (var i in q0)

{

string t = i.PersonLastName; // OK - is strongly typed

}

((EntityQuery)q0).ExecuteAsync(op =>

{

foreach (var i in op.Results)

{

string t = i.PersonLastName; // FAIL - not strongly typed

}

});

Async anonymous LINQ query : Ok, after performing the GroupBy...

Thu, 09 Sep 2010 15:05:45 -700

Author: ting
Subject: 2120
Posted: 09-Sep-2010 at 3:05pm

Ok, after performing the GroupBy you need to cast to an EntityQuery> to restore the type information. Here's an example:

// Perform the cast below to restore type information after the GroupBy

var query1 = (EntityQuery<IGrouping<string, Customer>>)manager.Customers.GroupBy(c => c.Country);

var query2 = query1.Select(g => new { Country = g.Key, Count = g.Count() });

query2.ExecuteAsync(op => {

foreach (var anonItem in op.Results) {

var country = anonItem.Country;

var count = anonItem.Count;

}

});

We'll look into the extension methods and see if we can do this automatically for you.

Async anonymous LINQ query : It looks like the GroupBy clause...

Wed, 08 Sep 2010 18:25:00 -700

Author: ting
Subject: 2120
Posted: 08-Sep-2010 at 6:25pm

It looks like the GroupBy clause is breaking the inference and also forcing the cast to EntityQuery. I'll check with an architect tomorrow and see if there is a solution. Thanks for pointing this out!

Async anonymous LINQ query : I am seeing the same behavior,...

Wed, 08 Sep 2010 12:10:34 -700

Author: chuckc
Subject: 2120
Posted: 08-Sep-2010 at 12:10pm

I am seeing the same behavior, that being that I have to cast my var query to an EntityQuery in order to call ExecuteAsync. And the collection returned in op.Results is not strongly typed.

Is there some other syntax required?

Or do you need to use the explicit event handler approach? Would *that* handle the anonymous type?

Async anonymous LINQ query : Ok, I still might be doing something...

Mon, 06 Sep 2010 15:25:04 -700

Author: BringerOD
Subject: 2120
Posted: 06-Sep-2010 at 3:25pm

Ok, I still might be doing something wrong.

I think the type information is getting lost somewhere. I do not get back strongly typed anon collection back. I looked for it when I first tried this.

This might have to do with the fact that I have to cast the first group by query back to "EntityQuery"

Async anonymous LINQ query : Nice. Good to see that you're...

Fri, 03 Sep 2010 12:54:06 -700

Author: ting
Subject: 2120
Posted: 03-Sep-2010 at 12:54pm

Nice. Good to see that you're using some of the advanced DevForce features.

The op.Results collection is actually strongly typed, so you can directly reference the properties. For example:

var query = manager.Customers.Select(

c => new { CompanyName = c.CompanyName, Customer = c, Orders = c.Orders }

);

query.ExecuteAsync(op => {

foreach (var anonItem in op.Results) { // op.Results is IEnumerable strongly typed anon collection

var companyName = anonItem.CompanyName;

var customer = anonItem.Customer;

var orders = anonItem.Orders;

}

});

Edited by ting - 08-Sep-2010 at 6:14pm

Async anonymous LINQ query : What is the best practice for...

Fri, 03 Sep 2010 07:32:59 -700

Author: BringerOD
Subject: 2120
Posted: 03-Sep-2010 at 7:32am

What is the best practice for getting results of an async anonymous LINQ query?

Just for the record its cool that you can even get this far. Becuase that means DevForce is sending that query to the server and atleast getting back results, where RIA cannot do this.

This code works below, just want to make sure this is the best practice.

Bryan

-----------------------------------------------------------------------------

var query1 = PrimeEntities.LeadListings

.Where(l => l.GroupId == LoggedIntUser.GroupId)

.GroupBy(l => l.StatusName).Select(g => new

{

g.FirstOrDefault().DisplayOrder,

StatusId = g.FirstOrDefault().StatusId.Value,

StatusName = g.Key,

TotalLeads = g.Count(),

g.FirstOrDefault().FontColor,

g.FirstOrDefault().BackgroundColor

});

((EntityQuery) query1).ExecuteAsync((op) =>

{

StatusGroupDtos.Clear();

foreach (var result in op.Results)

{

Type type = result.GetType();

var newItem = new LeadStatusGroupDto();

newItem.StatusId = (Guid) type.GetProperty("StatusId").GetValue(result, null);

newItem.StatusName = (string) type.GetProperty("StatusName").GetValue(result, null);

newItem.TotalLeads = (int) type.GetProperty("TotalLeads").GetValue(result, null);

newItem.FontColor = (string) type.GetProperty("FontColor").GetValue(result, null);

newItem.BackgroundColor = (string) type.GetProperty("BackgroundColor").GetValue(result, null);

newItem.DisplayOrder = (int?) type.GetProperty("DisplayOrder").GetValue(result, null);

StatusGroupDtos.Add(newItem);

}

});