LINQ and Extended Entity Properties : Hi ramister, I was not able...

Thu, 03 Feb 2011 16:53:59 -700

Author: sbelini
Subject: 2484
Posted: 03-Feb-2011 at 4:53pm

Hi ramister,

I was not able to reproduce your issue here.

Here's my test case: (against NorthwindIB)

var coop = Coroutine.Start(LoadListEntitiesCoroutine);

coop.Completed += (sender, args) => {

// some code

};

...

private IEnumerable<INotifyCompleted> LoadListEntitiesCoroutine() {

var employeesOp = _mgr.Employees.ExecuteAsync();

yield return employeesOp;

if (employeesOp.Results.Count() > 0) {

employeesOp.Results.Where(c => c.FullName == "Andy Fuller").ToList().ForEach(_employees.Add);

}

yield return Coroutine.Return(employeesOp.Results);

}

...

List<Employee> _employees = new List<Employee>();

...

public partial class Employee : BaseClass {

public string FullName {

get { return FirstName + " " + LastName; }

}

Is "NameFullFirstLast" a custom property? How is it being implemented? You might also check this thread at http://stackoverflow.com/questions/2241643/how-to-use-a-custom-property-in-a-linq-to-entities-query.

Also, I'm assuming you mean to add more async operations in your coroutine, right? (otherwhise, why not just populate your list in the callback of ExecuteAsync?)

Silvio.

LINQ and Extended Entity Properties : Folks,I have the following query...

Thu, 03 Feb 2011 08:56:51 -700

Author: rasmister
Subject: 2484
Posted: 03-Feb-2011 at 8:56am

Folks,

I have the following query that is throwing and exception:

private IEnumerable GetParticipantsByNameFullCoRoutine()

{

_isBatchCompleted = false;

Participants.Clear();

var participantOp =

App.EntityManager.Participants

//.Where(p => p.NameFullFirstLast == SearchTerm)

.ExecuteAsync();

yield return participantOp;

if (participantOp.Results.Count() > 0)

{

participantOp.Results.Where(p => p.NameFullFirstLast == SearchTerm).ForEach(Participants.Add);

}

yield return Coroutine.Return(participantOp.Results);

}

The p.NameFullFirstLast is a computed value in the entity buddy class.

The exception thrown is "NameFullFirstLast" is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation pies are supported.

Is there a way to do this or am I barking up the wrong tree?

Thanks!

Ross

DevForce Community Forum : LINQ and Extended Entity Properties

LINQ and Extended Entity Properties : Hi ramister, I was not able...

LINQ and Extended Entity Properties : Folks,I have the following query...