Author: marcoruas | Posted on: 8/6/2009 10:51:40 PM | Views : 442

Hi,
Just merged over to ASP.NET 3.5 and am about to build an online shopping cart website. Im going to be using the Membership, Role and Profile providers. The only query i have is i am going to have an ORDERS table which will needs to reference which customer the order belongs too. Would it be okay if i inserted the UserID (guid) column from the aspnet_Membership table into my ORDERS table to act as my unique customer id value and therefore create a relationship between the two tables for future access.



Previously in ASP.NET 1.1 i had a customerid value field, but obviously out of the box the membership provider table does not come with such a field. Rather then extending the membership provider i was wondering if this was a possible solution to EXTRACT, and INSERT the UserID value from the aspnet_Membership.


Will this create any foreseen issues? Obviously when i extract individual orders i need to link b ...

Go to the complete details ...