Linq Selecting rows from a view?

Question

I have a view in my sql database and it's mapped in my dbml file. Lets call ituserview

using(FooDataContext db = new FooDataContext()){
var users = from ur in db.userview
            where ur.username == "james"   //username is a colomn of userview
            select ur;
}

I get the following error

Could not find an implementation of the query pattern for source type 'TestProject.Models.userview'. 'Select' not found.

Did you see this: http://stackoverflow.com/questions/8215773 If that post offers and answer and yours is a dupe, then please delete it. — Paul Sasik, Apr 30 '12 at 20:53
Unfortunately I just tried to implement it. neither methods suggested in that thread worked. my `userview` doesn't have `where` `select` members, only generic ones like `tostring`, `attach` etc. — Bonk, Apr 30 '12 at 20:58
@MikeTWebb Wow, thanks!! That was a huge oversight on my part. Problem fixed. — Bonk, Apr 30 '12 at 20:59
should I delete this thread now or should I leave it for future reference for other people? — Bonk, Apr 30 '12 at 21:01

score 2 · Accepted Answer · answered Apr 30 '12 at 21:02

2

Have you added System.Linq to your code file?

answered Apr 30 '12 at 21:02

MikeTWebb

9,149
25
93
132

Linq Selecting rows from a view?

1 Answers1