Hi,
In my app I have a few roles. I use the asp.net membership and profile provider.
The admin adds users, and he may choose their role. One of the roles is Inspector.
An Inspecotr may be the inspector of a certain region. So as I choose the Inspector role (checkbox..) I must choose the ID of the Region - of which he wuill be an inspector.
Now I have to save his RegionID somehow.
Here I come to a confusion:
If I save the RegionID into a profile Property called RegionID (I define it in the web.config and then in code I just add: Profile.RegionID=ddlRegion.selectedvalue.....), may it make my apllication slower, considering the fact that in the profile there is only one column for all the properties and there may be lots of long properties which when looping over may slow the app?
Or would it be better to build a new table just for this purpose (with new storedprocedures of course and tableadapt ...
Go to the complete details ...