troubleshooting Question

Web.Config Connection String

Avatar of Kevin Robinson
Kevin Robinson asked on
Microsoft SQL ServerASP.NET
1 Comment1 Solution135 ViewsLast Modified:
This is a Entity framework connection string in my web.config.  Is there a way to tidy this.
For example could the actual connection string  "provider connection string"  be pointed to a separate connection string.
Its just sooo ugly and hard to read..


  <add name="MyEFConnection"
         connectionString="metadata=res://*/VN.csdl|res://*/VN.ssdl|res://*/VN.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=PC01;initial catalog=MyDatabaseName;user id=joe;password=xxxxxxx;multipleactiveresultsets=True;connect timeout=30;application name=EntityFramework&quot;"
         providerName="System.Data.EntityClient" />
ASKER CERTIFIED SOLUTION
Megan Brooks
SQL Server Consultant

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros