Possible ways to link existing user table into SQLMembershipProvider?

Hi all,

I have membership working well and I'm trying to integrate it into a
database that makes heavy use of a pre-existing 'User' table. I'd like
to keep my existing table (I've reduced the fields it holds so that it
does not duplicate the .Net provided ones) as there are a lot of joins
to the table and a few extra columns.

This means I have two sets of user data, the .Net one and my very small
table with a few extra columns and a 'loginname' column to join back to
the .Net one.

I've created a user using the site admin tools in Visual Studio so I
can log in initially but my application does not have any knowledge of
this .Net created user. I'd like to be able to subscribe to an event so
that I can keep the two in sync, but as my app is ASP.Net based I can't
see that working.

Has anyone got a good angle on how to approach this? I could put a
trigger on the .Net tables, but I don't want to touch those and I've
put them in the default 'aspnetdb' database to keep them away from my
code.

Thanks in advance

Ryan

.

Relevant Pages

  • Re: Will ASP query be slow if field names are lengthy?
    ... Its a very bad idea to add extra columns just for description, ... your database is going to be that large you might consider using SQL Server ... > the query.asp would just show a list of the last 3 months worth of ...
    (microsoft.public.inetserver.asp.general)
  • Re: Create Indexes & extra columns!
    ... > I have not yet had the guts to do it while the database was in use ... index is a more time consuming process if the table is large. ... create a clustered index, you'll likely take the table offline until the ...
    (microsoft.public.sqlserver.server)
  • Create Indexes & extra columns!
    ... I have not yet had the guts to do it while the database was in use however ... Regards ...
    (microsoft.public.sqlserver.server)