|
.net
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
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. Show quoteHide quote "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? > > > > 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 Show quoteHide quote "Steve C. Orr" <St***@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: > >> 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? >> >> >> >> Check this out:
http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en Show quoteHide quote "VB Programmer" <d***@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" <St***@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: >> >>> 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? >>> >>> >>> >>> > > Thanks once again Steve!
Show quoteHide quote "Steve C. Orr [MVP, MCSD]" <St***@Orr.net> wrote in message news:OLgX3pAGGHA.3064@TK2MSFTNGP10.phx.gbl... > Check this out: > http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en > > -- > I hope this helps, > Steve C. Orr, MCSD, MVP > http://SteveOrr.net > > > "VB Programmer" <d***@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" <St***@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: >>> >>>> 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? >>>> >>>> >>>> >>>> >> >> > > 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. Show quoteHide quote "VB Programmer" <d***@emailme.com> wrote in message news:eD1NHWEGGHA.1032@TK2MSFTNGP11.phx.gbl... > Thanks once again Steve! > > "Steve C. Orr [MVP, MCSD]" <St***@Orr.net> wrote in message > news:OLgX3pAGGHA.3064@TK2MSFTNGP10.phx.gbl... >> Check this out: >> http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en >> >> -- >> I hope this helps, >> Steve C. Orr, MCSD, MVP >> http://SteveOrr.net >> >> >> "VB Programmer" <d***@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" <St***@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: >>>> >>>>> 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? >>>>> >>>>> >>>>> >>>>> >>> >>> >> >> > >  
Other interesting topics
ASP.NET 2.0 menu: where to set alternate text for "^ up one level
disabling html validation does not seem to stck Application Performance Question Issues with multiple website development on Windows 2000 pro box Problems with ASP.NET 2.0 menu with Safari Need Step by Step guide for setting up IIS 6 for ASP Question on string DataGrid Columns Spannig More Than One Column hash.web is denied Send Email with MAPI |
|||||||||||||||||||||||
