Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Beginning ASP.NET 4.5 : in C# and VB
This is the forum to discuss the Wrox book Beginning ASP.NET 4.5: in C# and VB by Imar Spaanjaars; ISBN: 978-1-118-31180-6
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 4.5 : in C# and VB section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #21 (permalink)  
Old April 8th, 2013, 07:15 PM
Friend of Wrox
Points: 1,905, Level: 17
Points: 1,905, Level: 17 Points: 1,905, Level: 17 Points: 1,905, Level: 17
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2011
Posts: 411
Thanks: 13
Thanked 7 Times in 7 Posts
Default The App_Data

In your 4.0 previous version of your ASP.NET book, you had us drag and drop a .mdf file inside Visual Studio 2010 in the App.data folder and we were able to run and access the database from that location. Are you saying that is not the case anymore with Visual Studio 2012? That we have to do a separate install of SQL Server Express 2012 that will not have any internal plumbing .mdf inside the App_Data folder of the Visual Studio 2012 like we did in 2010?
Reply With Quote
  #22 (permalink)  
Old April 8th, 2013, 07:19 PM
Friend of Wrox
Points: 1,905, Level: 17
Points: 1,905, Level: 17 Points: 1,905, Level: 17 Points: 1,905, Level: 17
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2011
Posts: 411
Thanks: 13
Thanked 7 Times in 7 Posts
Default

Disregard this post!

Last edited by vbboyd; April 8th, 2013 at 09:21 PM..
Reply With Quote
  #23 (permalink)  
Old April 8th, 2013, 07:26 PM
Friend of Wrox
Points: 1,905, Level: 17
Points: 1,905, Level: 17 Points: 1,905, Level: 17 Points: 1,905, Level: 17
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2011
Posts: 411
Thanks: 13
Thanked 7 Times in 7 Posts
Default

Disregard this post

Last edited by vbboyd; April 8th, 2013 at 11:53 PM..
Reply With Quote
  #24 (permalink)  
Old April 8th, 2013, 07:31 PM
Friend of Wrox
Points: 1,905, Level: 17
Points: 1,905, Level: 17 Points: 1,905, Level: 17 Points: 1,905, Level: 17
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2011
Posts: 411
Thanks: 13
Thanked 7 Times in 7 Posts
Default

Disregard this post

Last edited by vbboyd; April 8th, 2013 at 11:46 PM..
Reply With Quote
  #25 (permalink)  
Old April 8th, 2013, 07:34 PM
Friend of Wrox
Points: 1,905, Level: 17
Points: 1,905, Level: 17 Points: 1,905, Level: 17 Points: 1,905, Level: 17
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2011
Posts: 411
Thanks: 13
Thanked 7 Times in 7 Posts
Default Thanks for your help.

Disregard this post.

Last edited by vbboyd; April 8th, 2013 at 09:23 PM..
Reply With Quote
  #26 (permalink)  
Old April 8th, 2013, 09:20 PM
Friend of Wrox
Points: 1,905, Level: 17
Points: 1,905, Level: 17 Points: 1,905, Level: 17 Points: 1,905, Level: 17
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2011
Posts: 411
Thanks: 13
Thanked 7 Times in 7 Posts
Default Doing it without the SQL Server 2012

Okay well. I started doing your exercise on pages 426 and 427 and I didn't have the 2012 SQL Server Management studio tool to do the steps in the book. So I had to improvise a bit so I opened up Windows explorer on my desktop and and navigated around to find your SQL script that came with the download for your book that is located in Resources/Chapter12. Then I right clicked on your SQL server script and opened it up with notepad and copied it into memory. What I did then was to go to SQL menu inside the Visual Studio 2012 environment and then I selected the Transact SQL option in the drop down list which opened up a query window for me in Visual Studio 2012, whereupon I pasted the contents of your SQL script into that window in Visual Studio 2012 and ran it. Voila!, everything worked just fine and created the tables and data for the Temporary Planet Wrox database for me, and this was without the benefit of SQL Server 2012 Management studio. That is kind of roundabout way of doing things, but it worked. I know that that is kind of kludgey way of doing things, but when you don't have the SQL Sever 2012 management studio front end, then you have to improvise sometimes. I put this post out here just in case anybody would like to find an alternative to doing the exercises in chapter 12 without having to use SQL Server 2012 management studio.

Last edited by vbboyd; April 12th, 2013 at 08:30 AM..
Reply With Quote
  #27 (permalink)  
Old April 8th, 2013, 10:54 PM
Friend of Wrox
Points: 1,905, Level: 17
Points: 1,905, Level: 17 Points: 1,905, Level: 17 Points: 1,905, Level: 17
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2011
Posts: 411
Thanks: 13
Thanked 7 Times in 7 Posts
Default

Quote:
Originally Posted by Imar View Post
This book assumes you're using SQL Server Express 2012. You can use another version of SQL if you want. Full details are in the database chapters and appendix B. I recommend to use SqlExpress for the exercises in the book. I also use it a lot myself for regular development, even though I have the dev and other additions as well.

Cheers,

Imar
Okay there are two database node/utilities in Visual Studio 2012 one is called SQL Server Object Explorer and another is called Server Explorer. I can see all of my databases including Planet Wrox and Planet Wrox Temp in SQL Server Object Explorer. But I can't do database diagrams that option is not available to me in SQL Server Object Explorer. But then I can go over to Server Explorer inside of VS 2012 and I can't see Planet Wrox and Planet Wrox Temp but I can do database diagrams. From Server Explorer I can do database diagrams but inside of SQL Server Object explorer I can't. How do a database diagram inside of Visual Studio 2012 without using SQL Server Management Studio?

Last edited by vbboyd; April 8th, 2013 at 11:38 PM..
Reply With Quote
  #28 (permalink)  
Old April 8th, 2013, 11:45 PM
Friend of Wrox
Points: 1,905, Level: 17
Points: 1,905, Level: 17 Points: 1,905, Level: 17 Points: 1,905, Level: 17
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2011
Posts: 411
Thanks: 13
Thanked 7 Times in 7 Posts
Default I was just looking at your script.

I was just looking at the SQL Script in-depth that you supply with the download for the book, and I noticed that it already had all of the PK-FK relationships and all relationships already put in for us automatically. So in essence it is really not necessary to do the database diagram exercise that you have in the book, because all of the PK-FK stuff is already coded into the SQL script that comes with the download from the book. The only reason I was stressing about the database diagram stuff was because I was afraid that the deletes and updates would not cascade down later on like they were supposed to with db entity relationships. But you coded that in all for us already. So correct me if I am wrong, all you need to do is go to Visual Studio 2012, create a new database inside of Visual Studio 2012 called Planet Wrox, then take the script that you supplied and run it against the Planet Wrox database and you are off and running to the races. You can proceed onto Chapter 13 and do the exercises with no real problems. Cool! Way Cool!
PS. I also noticed that the SQL Script that comes with your book already has clustered keyed index with CONSTRAINT[PK_Review]Primary Key Clustered. Cool, way cool. That will definitely help with search times on the database.

Last edited by vbboyd; April 8th, 2013 at 11:59 PM..
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems with chapter 12 happyandstable BOOK: Beginning ASP.NET 4 : in C# and VB 5 March 7th, 2012 11:28 AM
Chapter 12 SQL File? Any SQL files? ripcurlksm BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 0 June 20th, 2008 06:49 PM



All times are GMT -4. The time now is 04:27 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.