Before I start trashing the Membership Provider, I'll seek to understand. In my old 2.12 modules I was able to join to the users table by userId in my stored procedures to get information like street address and telephone number. That worked great. But how do I do this with the Membership Provider?
For instance I have this procedure that joins a table I created to the users table.
Select B.UserID,B.Loc_i, A.Loc_t,C.UserName,C.Firstname,C.Lastname, C.Telephone
from dbo.My_Locations A
inner join dbo.MyUserLocation B on A.Loc_i = B.Loc_i
inner join dbo.users C on B.UserID = C.UserID
where B.Loc_i = @Loc_i
Order by c.Lastname