lambda select

[Badgers]

Hi

I'm using some lambda for sql access - does anyone know how to do a select statement, I have the following below, but the select don't work.

IEnumerable<Table1> agentTeamFacts = entities.Table1
.Where(
e => e.InstanceID.Equals(Id))
.OrderBy(a => a.ID)
.ThenBy(a => a.Date)
.Select(a => new {a.ROWID, a.PID, a.nDate.Value});

Thanks

 

[jmeckley]

how does it not work? doesn't compile? incorrect results? throws exception?

usually when developers talk of linq and sql they are either referring to Linq2Sql or LinqD. LinqD was a buzz word when linq first hit the scene. Is this what you are referring to?

Jason Meckley
Programmer
Specialty Bakers, Inc.

faq855-7190
faq732-7259