RE: [Spam] RE: [AspNet2] users/roles/membership/profiles/etc

[Chris Farrell]

As in original email, the problem is with existing databases and applications.  Basically it isn’t just The user table that is changed here, it is most of the database that is affected.  Every table with A user ID foreign key would have to be modified, update all the data access, update the business Logic.  This value is also sometimes used in manual/human/paper processes and it is pretty darn Uncomfortable for humans to deal with GUIDs when talking to customers over the phone, the Shipping people on the docks are going to not like using GUIDS, the accountants don’t want to Use them.    There are further reasons but for now I’d prefer to focus on finding a solution.    Chris F     -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Ivanoff, Alex Sent: Friday, December 23, 2005 3:33 PM To: [EMAIL PROTECTED] Subject: [Spam] RE: [AspNet2] users/roles/membership/profiles/etc   What is wrong with GUID?   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Farrell Sent: Friday, December 23, 2005 14:24 To: [EMAIL PROTECTED] Subject: [AspNet2] users/roles/membership/profiles/etc I posted this on another list and didn’t get any responses.  Here goes again…..   I’ve been reading and working on a practice project to figure out what challenges I will face moving Towards .net 2.0.    Current issue is trying to use the new roles and membership/users setup with existing data Stores.  The key issue I am confronting now is that the .net 2.0 model uses a GUID as the Identifier for each user.  All previous data stores use simple integers with the user key being Just an int identity.   I am certain this is going to be an issue for many others and am surprised I haven’t already Found a solution pre packaged for this.   -Am I going to have to write my own provider?? -Am I better off just not using the new model? -Can I just modify the existing setup to use an int instead of a GUID?  How much work would this be?  Could I just add an identity int column to the table and then handle the rest through profiles? -Any pre-made solutions for this? -Any workarounds for this?  -Comments?? Suggestions?    Chris F       YAHOO! GROUPS LINKS  Visit your group "AspNet2" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.