I was wondering with Entity Framework 4.1 code first how do you guys handle queries that involve an existing aspnet\_Users table?

Basically I have a requirement for a query that involves the aspnet\_Users so that I can return the username:

```
SELECT t.Prop1, u.Username
FROM Table1 t 
INNER JOIN aspnet_User u ON t.UserId = u.UserId
Where t.Prop2 = true

```

Ideally in linq I would like:

```
from t in context.Table1
join u in context.aspnet_Users on t.UserId equals u.UserId
where t.Prop2 = true

```

But I'm not sure how to get aspnet\_Users mapping to a class User? how do I make aspnet\_Users part of my dbset ?

Any help would be appreciated, thanks in advance