Try writing multiple linq queries and using the results of the other queries
in your final result. Not sure on the array part, however. Will have to mull
that one over.
--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA
Subscribe to my blog
http://feeds.feedburner.com/GregoryBeamer#
or just read it:
http://feeds.feedburner.com/GregoryBeamer
********************************************
| Think outside the box! |
********************************************
"shapper" <md*****@gmail.comwrote in message
news:48**********************************@2g2000hs n.googlegroups.com...
Hello,
I have a sub query in a Linq query:
var data = (from a in database.A
select new B {
B1 = (from b in database.B
join b in database.B on a.AID equals
b.AID
select b).ToList(),
B2 = ?????????
}).ToList();
I want B2 to be a conversion of B1 to Array.
So B2 = B1.ToArray();
But is it possible to make this in the Linq query?
In SQL I would give a name to the table produced by the Sub Query and
then I would use that.
Thanks,
Miguel