Ch 19 SQL connection string

AlanWheeler · February 10th, 2014, 01:11 AM

Hi Imar,

My first step toward publishing was to add IIS to a VM running Server 2012. I was successful (to a degree - there are still some permissions problems). I won't be able to load to a hosting service until I have a new site designed. But in the meantime I'd like to make sure I understand the database connections.

The text instructs to change the connection string for SQL, but I didn't change anything and the site worked fine. I also checked the Final folder of the downloaded code and noticed those connection strings were not changed.

Could you provide a little insight to explain why the connection string didn't need to be changed so I'm prepared later to know when I do need to change it.

Thanks.

Best Regards,
Alan

Imar · February 10th, 2014, 05:16 PM

Can you post your connection string? Local DB should not be supported under IIS so that shouldn't work out of the box. Maybe you used SqlExpress instead?

Imar

AlanWheeler · February 11th, 2014, 12:11 PM

Hi Imar,

Here's the strings from web.config that I used (and never changed):

Code:

  <connectionStrings>
    <add name="PlanetWroxConnectionString1"
                     connectionString="Data Source=(LocalDB)\v11.0;
                     AttachDbFilename=|DataDirectory|\PlanetWrox.mdf;
                     Integrated Security=True"
                     providerName="System.Data.SqlClient" />

    <add name="PlanetWroxEntities"
                     connectionString=
                       "metadata=res://*/App_Code.PlanetWrox.csdl|
                       res://*/App_Code.PlanetWrox.ssdl|
                       res://*/App_Code.PlanetWrox.msl;
                       &#xA;
                       provider=System.Data.SqlClient;
                       provider connection string=&quot;
                       data source=(LocalDB)\v11.0;
                       &#xA;
                       attachdbfilename=|DataDirectory|\PlanetWrox.mdf;
                       integrated security=True;
                       &#xA;
                       MultipleActiveResultSets=True;
                       App=EntityFramework&quot;"
                     providerName="System.Data.EntityClient" />
  </connectionStrings>

So you raise an interesting point. 'Maybe you used SqlExpress instead'. I think you might be right, but I don't know how to tell which is installed. Where do you determine the type of SQL? Most places I looked in the application just said SQL, I didn't see a reference to 'Express'.

BTW, can you explain what the short terms "&#xA" are in the 2nd connection string? I didn't see them in your sample code, but Visual Studio seemed to have put them in the strings.

Best Regards,
Alan

Imar · February 11th, 2014, 12:34 PM

Hi Alan,

Your connection strings refer to LocalDB so that's what's being used (for Express you would have seen .\SqlExpress). Check out Appendix B for more information.

LocalDB shouldn't be supported under IIS, so maybe your system has something configured to make it work, as explained in this post: http://blogs.msdn.com/b/sqlexpress/a...r-profile.aspx

Regarding &#xA, Google says it's a line feed: http://stackoverflow.com/questions/5...e-xa-character. It shouldn't be there so you can safely remove it.

Cheers,

Imar