Hi,

Please can someone advise the best route forward?

I have an existing 'football predictions' website that I wrote in php. On that I used several session variables including a user number that I used to enter into a db table that recorded the predictions against that user.
I plan to rewrite the site in C# ASP.NET but keeping the previous data of users and predictions etc from last season as I'll need to show that in certain pages.

Therefore should I add the existing users data into the 'Users' table in the db aspnetdb (as I would like to use the new technology rather than session variables) or keep the existing user table I have and place in a separate table in another db and have to use session variables?

Also, as I have the existing user number in my predictions tables, is it possible to look up by this number as opposed to 'using User.Identity.Name' which looks up by name?

Many thanks in advance,

Dave

Hi there,

I guess it depends a bit on where your data is stored, and how much work you're willing to put into this.

I can see a few options (there are more though)

1. Import users into the Users table based on the old data. You can write some code that reads data from the old system, and programmatically creates new users.

2. You can reuse some of the controls (like Login), and handle their events to look into your own database. E.g. with Login, it fires OnLoggingIn which you can use to query your users table for a user name and password.

3. You can implement your own Membership and optionally Roles and Profile providers. A bit more work, but much cleaner in the long run as you can use all of the security functionality against your own database structure. For some more details:

http://imar.spaanjaars.com/380/migra...s-and-profiles
http://imar.spaanjaars.com/404/using...rver-providers
http://www.google.com/#sclient=psy&h...=1050&bih=1262

With all options you still need to find a way to store the user's number; either in a Session variable or by looking it up each time you need it. You could store the old ID in the user's Profile or in a related table you can query later.

Hope this gives you some ideas.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!