Is it possible to convert "userid" type into "integer" from "uniqueidifier" in asp.net membership? And how to do this?
Asp.Net The subscription user ID is set to the unique identifier in the data type table schema. You probably do not want to attempt and change the datatype of the column, because then all the stored procedures and the sqlmembership provider also need to be changed. But what you can do is create a lookup table that will match an integer with the unique identifier ID unique. There will be 2 columns in the lookup table, one for asp.net membership (datatype of uniqueidentifier) to UserId and then another column of type that gives you its integer.
But before you go ahead with it, you should ask why you need an integer in the first place or what a unique identifier will do? If you are trying to return to the asp.net subscription provider at the top of an existing database (where int is used to identify a user), then a lookup table should work well.
Comments
Post a Comment