Is there any way to convert fairly basic queries (selects joining across
several tables) into linq? Here's the idea - I use views to act as the
basis for my data access layer (code generated). However I can't use views
directly because they don't use indexes properly (or so I'm told). I just
want to use the views as a place to store select statements. I want to
grab the view definition and convert it to linq and then I can easily add
paging. It doesn't look too hard to convert the select statements into
linq as long as they remain simple and strictly formatted. It's just I was
wondering if anyone had experience (and code) of doing something like
this. If the views get changed then the code generation would break. I am
new to this and I am open to any better ideas.