What is the database "standard" in 2.0?

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.
I hope this helps,
Steve C. Orr
MCSD, MVP
http://Steve.Orr.net
"VB Programmer" wrote:

> 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 o
wn
> tables?
>
>
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
"Steve C. Orr" <Steve@.Orr.net> wrote in message
news:2AC76A85-C1B3-40C9-8056-4294C6101277@.microsoft.com...
> 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.
> --
> I hope this helps,
> Steve C. Orr
> MCSD, MVP
> http://Steve.Orr.net
>
> "VB Programmer" wrote:
>
Check this out:
http://www.microsoft.com/downloads/...&displaylang=en
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"VB Programmer" <dont@.emailme.com> wrote in message
news:eAeUe5%23FGHA.644@.TK2MSFTNGP09.phx.gbl...
> 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
> "Steve C. Orr" <Steve@.Orr.net> wrote in message
> news:2AC76A85-C1B3-40C9-8056-4294C6101277@.microsoft.com...
>
Thanks once again Steve!
"Steve C. Orr [MVP, MCSD]" <Steve@.Orr.net> wrote in message
news:OLgX3pAGGHA.3064@.TK2MSFTNGP10.phx.gbl...
> Check this out:
> http://www.microsoft.com/downloads/...&displaylang=en
> --
> I hope this helps,
> Steve C. Orr, MCSD, MVP
> http://SteveOrr.net
>
> "VB Programmer" <dont@.emailme.com> wrote in message
> news:eAeUe5%23FGHA.644@.TK2MSFTNGP09.phx.gbl...
>
I don't know which username was selected by default. I never remember
selecting one and have already uploaded the ASPNETDB.MDF to the site here:
http://www.MySite.com/App_data/aspnetdb.mdf
How would I connect to it?
Thanks.
"VB Programmer" <dont@.emailme.com> wrote in message
news:eD1NHWEGGHA.1032@.TK2MSFTNGP11.phx.gbl...
> Thanks once again Steve!
> "Steve C. Orr [MVP, MCSD]" <Steve@.Orr.net> wrote in message
> news:OLgX3pAGGHA.3064@.TK2MSFTNGP10.phx.gbl...
>