Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Beginning ASP.NET 4 : in C# and VB
This is the forum to discuss the Wrox book Beginning ASP.NET 4: in C# and VB by Imar Spaanjaars; ISBN: 9780470502211
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 4 : in C# and VB section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old April 28th, 2010, 02:33 PM
Friend of Wrox
 
Join Date: Mar 2010
Posts: 99
Thanks: 21
Thanked 6 Times in 4 Posts
Default SQL Database .mdf standalone ?

Hello,

There is something i don't understand.. what is the main difference between an .mdf file and SQL Server Express 2008 ? I alway though it was needed to use SQL Server Express 2008 in order to use a database.. but in your book look like you can use only an .mdf file and open it up in VWD ? Does this mean that you can actually put that in the App Folder and call it to write and manage data ? then when do you need SQL Server Express 2008 ? It is for remote purpose only ? security ?

Thanks for your time, i am sorry for asking so much question hope you don't mind i just wanna understand the right way.
  #2 (permalink)  
Old April 28th, 2010, 03:52 PM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi Rushino,

It looks as if you can just open the MDF file. However, under the hood, Visual Studio connects to SQL Server Express and attaches the database on the fly. So, you still need SQL Server Express, even though VS gives you the impression it's handling all interaction with the database for you.

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
  #3 (permalink)  
Old April 29th, 2010, 09:01 AM
Friend of Wrox
 
Join Date: Mar 2010
Posts: 99
Thanks: 21
Thanked 6 Times in 4 Posts
Default

Thanks i didn't know.. so the fact that its a standalone file mean its good for backup purpose only ?
  #4 (permalink)  
Old July 28th, 2010, 06:35 AM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Quote:
so the fact that its a standalone file mean its good for backup purpose only ?
Not necessarily. When the database is in use, it still can't be backed up using a copy operation.

The main benefit I see is that you don't need to attach it to SQL Server first, which lowers configuration and security requirements.

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!


Similar Threads
Thread Thread Starter Forum Replies Last Post
can't open aspnet.mdf database file moulot BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio 1 October 11th, 2009 07:00 AM
how to connect to MDF sql server database? hertendreef Classic ASP Databases 1 March 25th, 2007 02:02 AM
how to prepare database with .ldf and .mdf files beetle_jaipur SQL Server 2000 2 March 8th, 2007 11:54 PM
how to open database file of .mdf extension ravi.gurgaon BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 1 August 19th, 2006 05:09 AM
Connecting to project MDF SQL Database File nsoivan Crystal Reports 0 July 31st, 2006 05:14 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.