How can i get linq to sql to map my type when i use a parameterized constructor?

I know that L2S is not designed to map custom/POCO types to L2S-entity types without the object initializer syntax. But is there a back-book way to achieve this so that i can project into开发者_高级运维 my POCO with a parameterized constructor and not get stung when i try to apply an expression to that result?

Do a ToList() into memory and run your statements against in-memory collection.

Yes of course its not as effecient as querying against L2S IQueryable. But the design is cleaner.

I been down that road before. It turned out badly. L2S and EF implementation of IQueryable just does not work (well) with anything other than the object it was designed for.

You can't.

And if there is a "back-book way" I haven't found it (and I suspect I don't want to).