Hi, I am developing an application that uses SQL Server Express for it's data store. I'm using Linq to SQL to connect to my data layer. I'm also using the Membership API to manage users and roles in my application. I store additional user information in a table called "employee" which has a one-to-one relationship to the table aspnet_Users using UserId as a key (I enter the UserId created in the aspnet_Users table into the employee table).
How can I pull out all employees who are in a certain role? Linq to SQL seems to be able to cope pretty well with relationships using the EntitySet collection - but my relationship with the aspnet_Users table is not showing this way? I don't know if that last sentance makes much sense?!
If you look at the pic below (from scottGu's blog) he has a table called Products which has a relationship to a table called Category, but he can use this relationship to get the categoryName from t ...
Go to the complete details ...