Forgive me for asking such a simple question, I know I
should be able to figure this out, but it has been hours and I still don't have
I have a simple DB that has the aspnet Membership tables
added into it (cf. aspnet_regsql.exe).
In addition, I have a UserProfiles table to store additional user info
like FirstName, LastName, Sex, Age, etc.
There is a foreign key relationship between aspnet_Users and
UserProfiles, using the UserID field.
The functionality I desire is:
1) A 1:1 relationship between aspnet_Users and UserProfiles;
there should only be 1 Profile per aspnet_User.
2) When an aspnet_User is created, that UserProfiles would
inherit that UserID created for the aspnet_Users row
3) CRUD operations that cascade. If a aspnet_User is deleted, so should the
a) Is all of this supposed to be handled in the EDM
b) Should I use map custom stored procedures?
Thanks in Advance
View Complete Post