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
  #1 (permalink)  
Old July 15th, 2013, 02:51 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 Deployment

I posted my website onto a remote server this morning and I was told by the hosting provider that you can just copy the whole thing up via ftp and Visual Studio 2012 and that you don't need to set up the SQL Server database that sits under the App_Data folder in your Visual Studio directory that once you post to the remote IIS server that your ASP.NET 4.5 application will automatically just see that .mdf file sitting under the App_data folder (that is referenced in your web.config file) in the file structure of your ASP.NET 4.5 website and that you don't have to do any special configuration. At least that is what their tech support people told me. That Microsoft was really good about that sort of thing.
But I found out that I needed to change the web config to point to the SQL Server database that they was created by me remotely.
Thanks once again:
PS
I took your example out of your book as a blueprint and I used to build and E-Commerce website for a fictional chocolate factory and candy store.



Thanks once again.

Last edited by vbboyd; July 17th, 2013 at 12:29 AM..
Reply With Quote
  #2 (permalink)  
Old July 15th, 2013, 11:06 PM
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2013
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Good luck to you.

Good luck to you. I hope you get the job. At least you are trying to improve and better yourself which is a lot more than I can say for the worthless bums on welfare. But I didn't mean to preach. What you are doing is very honorable. Again good luck to you. I just hope the Author guy doesn't get as you say get too "crabby" with you for asking a question. Ha, ha, ha. Only kidding.

-Rich C-
Reply With Quote
  #3 (permalink)  
Old July 16th, 2013, 11:39 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 On page 802 of your book

Is this the correction connection string that I should add to my remote hosting of the production server to where I have uploaded my application as it is on page 802 of your book?
Code:
<add name="CandyStoreEntities" connectionString="metadata=res://*/App_Code.CandyStore.csdl|res://*/App_Code.CandyStore.ssdl|res://*/App_Code.CandyStore.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=localhost;Initial Catalog=CandyStore;User ID=****yd;password=****ez;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient"/>

Here is the regular connection string for the remote server that the remote hosting service gave me to use:
<add name="strConn" connectionString="Data Source=localhost;Initial Catalog=DBNAME;Integrated Security=false;User ID=DBUSERNAME;Password=DBPASSWORD" />
The only thing about your entity connection string that I am not understanding is what is this part of the connection string all about?:
provider connection string=&quot;
Does that part need to be changed too?

Last edited by vbboyd; July 17th, 2013 at 12:14 AM..
Reply With Quote
  #4 (permalink)  
Old July 30th, 2013, 02:15 PM
Imar's Avatar
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Quote:
The only thing about your entity connection string that I am not understanding is what is this part of the connection string all about?:
provider connection string=&quot;
This embedded connection string refers to the SQL Server database you want to use. EF leverages the main connection string facilities. However, it has other needs than regular connection strings. So, part of the connection string is EF specific (all the metadata stuff). It then embeds a SQL Server connection string inside its own connection string. In order for the quotes to be used as literal values, they are encoded to &quot; otherwise that would prematurely close of the connectionString attribute of the outer connection string.

Hope this helps,

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!
Reply With Quote
  #5 (permalink)  
Old August 6th, 2013, 01:10 AM
Staceysmith
Guest
 
Posts: n/a
Default

the posts here are beneficial one for me as well ..
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
deployment Bhavin Crystal Reports 1 February 5th, 2009 08:07 AM
deployment p2pMember ASP.NET 2.0 Basics 0 June 7th, 2007 01:12 AM
Deployment sen22 .NET Framework 2.0 1 April 17th, 2007 02:38 PM
Deployment regbnvl BOOK: Professional VB 2005 ISBN: 0-7645-7536-8 0 May 7th, 2006 04:44 PM
Deployment Bhavin Crystal Reports 2 October 25th, 2004 08:28 AM



All times are GMT -4. The time now is 08:52 PM.


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