ulas said:
dpratt71 said:
*snip*
Yup, that worked like a charm Smiley Thanks a lot!

I hope VS will be able to tell what is not supported in LINQ queries at some point. Or even better, may be the Entity Framework will be able to translate everything you can do in code Wink
We'll it can't do that (translate everything), but they do have a pattern for letting you describe a proceedure to use for a given method. 

http://blogs.msdn.com/efdesign/archive/2008/10/08/edm-and-store-functions-exposed-in-linq.aspx

It would be nice if the model was more 'stood off' I feel, meta data is great - but when you don't even control the source, its just as useless..

Even still the design is imperfect but thats the way the ecosystem is for this software..