Re: Help with ASP.NET Memberships

Okay, thanks. It would be a shame though. In my database, some users are clients and some users are trainers and each client must be associated with a trainer. So if my data is in separate tables, I need a table just to link the users to trainers. In addition to the fact that I think that would break things like cascading deletes, etc., it just doesn't seem like a very good design.

It looks like you can implement your own provider class. I'll research that some more as I don't know if that's more than I want to get into now.

Thanks.

--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com


"Scott M." <s-mar@xxxxxxxxxxxxx> wrote in message news:ONecSu4DIHA.3848@xxxxxxxxxxxxxxxxxxxxxxx
Correct. Also, I don't see any problem with creating relationships in your new table(s) with existing data. Also, I'm not sure what data (if any) in the auto-generated tables may be encrypted or hashed, so you may run into issues deciphering the data (I'm not sure).



"Jonathan Wood" <jwood@xxxxxxxxxxxxxxxx> wrote in message news:%23UQH883DIHA.748@xxxxxxxxxxxxxxxxxxxxxxx
I just want to make sure I understand.

So you don't see any need for a separate database, but that I should add separate tables for storing my application's user data, even if there is some overlap. Is that correct?

At this point, I should probably take the path of least resistance.

Thanks.

--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com

"Scott M." <s-mar@xxxxxxxxxxxxx> wrote in message news:e0clM33DIHA.5160@xxxxxxxxxxxxxxxxxxxxxxx
Are you recommending I create a new database so that I have two different databases that store my users' data?

No, you could create new tables in the membership database if needed, but I wouldn't mess with any of the auto-generated stuff.







.

Relevant Pages

  • Re: Horses In Training
    ... the number of horses coming into and leaving training each year will mean that the number in training in a given year will be much less than Malc's 10-year figure - but how much? ... If I'd had to guess how many trainers currently held a licence to train under Rules in the UK, I'd have said about 750 at the most! ... At the end of the day it's for A-Z to determine what sort of parameters he uses; this is merely a report on the data which I have. ... As it happens I also load all my data in arrays; it's considerably faster than linked lists or collections to process and significantly faster than leaving it all in a database and working on it within there. ...
    (uk.sport.horseracing)
  • Re: Supporting multiple oracle versions in a trigger
    ... This is a very unscalable solution. ... Why would you do that in a database? ... > - Clients can add/modify their data collection requirements in minutes ... > - Clients can connect to the database with 3rd party sql tools and access ...
    (comp.databases.oracle.server)
  • Re: Poly Couples
    ... Essentially - different versions for different clients. ... insist that you use their existing database which is from a different ... vendor, and the structure is different than the one you use originally. ... characters would mark variable insertion place-holders in the SQL. ...
    (comp.object)
  • Re: Programatically adding Fields to an existing Database (using SQL)
    ... database to new clients, ... TADODataSet method "GetFieldNames" in order to find the fields the ...
    (borland.public.delphi.database.ado)
  • Re: Synching between Access and MSSQL
    ... The clients will only be disconnected a matter of a few days in most cases ... The challenge is that the information has to be tracked in a main database ... Working out the details of how to keep the data synchronized and accomodate ... I found code to allow an ADO connection to a local Access database but now I ...
    (microsoft.public.access.externaldata)
Loading