What is the database "standard" in 2.0?

  • Thread starter Thread starter VB Programmer
  • Start date Start date
V

VB Programmer

If you want to store custom tables in ASP.NET 2.0, such as Products,
Companies, Shopping Carts, etc... where is the standard place to put the
tables? I want to link it to the user/membership tables. BUT, is it "ok" or
the standard practice to go ahead and use the ASPNETDB.mdf to store your own
tables?
 
For small web sites the solution you've specified is fine.
Larger web sites will likely have their own database, in which case the
membership table either remain in a separate database or the SQL scripts are
run to include the tables in the site's main database.
 
Excellent response!

Now, if I deploy a ASPNETDB.mdf with custom tables, etc..., if I LATER add a
table, or field, etc... what is the best way to update the database without
losting current data? Is Enterprise Manager the tool I can use? If so,
what password do I use to get into the ASPNETDB.mdf? I tried with 'sa' (no
password) with no success.

(I have MSDN Universal account so might have access to other tools you
recommend.)

Thanks!
Robert
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

storing personalized information, what is best practice? 1
Membership and Roles 3
Creating a custom ASPNET provider Database 2
Advice needed (ASP.NET membership) 14
[asp.net 2.0] Interesting Membership problem 1
Move asp.net profile/membership tables to sql server 2
aspnet database stores password in plaintext? 3
adding Membership tables to database, how? 1

Back
Top