By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,659 Members | 1,945 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,659 IT Pros & Developers. It's quick & easy.

What is the database "standard" in 2.0?

P: n/a
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?

Jan 12 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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 own
tables?

Jan 13 '06 #2

P: n/a
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" <St***@Orr.net> wrote in message
news:2A**********************************@microsof t.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:
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?

Jan 13 '06 #3

P: n/a
Check this out:
http://www.microsoft.com/downloads/d...displaylang=en

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"VB Programmer" <do**@emailme.com> wrote in message
news:eA***************@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" <St***@Orr.net> wrote in message
news:2A**********************************@microsof t.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:
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?


Jan 13 '06 #4

P: n/a
Thanks once again Steve!

"Steve C. Orr [MVP, MCSD]" <St***@Orr.net> wrote in message
news:OL**************@TK2MSFTNGP10.phx.gbl...
Check this out:
http://www.microsoft.com/downloads/d...displaylang=en

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"VB Programmer" <do**@emailme.com> wrote in message
news:eA***************@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" <St***@Orr.net> wrote in message
news:2A**********************************@microsof t.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:

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?



Jan 13 '06 #5

P: n/a
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" <do**@emailme.com> wrote in message
news:eD**************@TK2MSFTNGP11.phx.gbl...
Thanks once again Steve!

"Steve C. Orr [MVP, MCSD]" <St***@Orr.net> wrote in message
news:OL**************@TK2MSFTNGP10.phx.gbl...
Check this out:
http://www.microsoft.com/downloads/d...displaylang=en

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"VB Programmer" <do**@emailme.com> wrote in message
news:eA***************@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" <St***@Orr.net> wrote in message
news:2A**********************************@microsof t.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:

> 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?
>
>
>
>



Jan 13 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.