I am so confused by this. I want to use SQL Server on my desktop when I design and use Live SQL Server when publishing my project. I play with conversion things in Visual Studio 2010.
I get the name “No Attribute” for “Match Locator” when I try to publish my project.
My Web.config file contains:
<connectionStrings> <add name="EFDbContext" connectionString="Data Source=.\SQLEXPRESS;Integrated Security=SSPI;Initial Catalog=db" providerName="System.Data.SqlClient"/> </connectionStrings> <system.web> <sessionState mode="SQLServer" sqlConnectionString="Server=.\SQLEXPRESS;Integrated Security=SSPI;Initial Catalog=ASPState;Application Name=eGov" timeout="20" allowCustomSqlDatabase="true" /> </system.web>
I am still testing it, so for now my Web.Release.config file contains:
<connectionStrings> <add name="EFDbContext" connectionString="Data Source=.\SQLEXPRESS;Integrated Security=SSPI;Initial Catalog=db" providerName="System.Data.SqlClient" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" /> </connectionStrings> <system.web> <compilation xdt:Transform="RemoveAttributes(debug)" /> <sessionState mode="SQLServer" sqlConnectionString="Server=.\SQLEXPRESS;Integrated Security=SSPI;Initial Catalog=ASPState;Application Name=app" timeout="20" allowCustomSqlDatabase="true" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" /> </system.web>
Everything that I see on the Internet only confuses me. Any help to get me up and running?
source share