Entity Framework connection string not working [Answered]RSS

• • Reply
  bhanu2217

  Member

  129 Points

  454 Posts

  Entity Framework connection string not working

  Jun 13, 2011 01:20 PM|bhanu2217|LINK

  In app.config i have following connection string

  <connectionStrings>
      <add name="UdyogaEntities" connectionString=
       "metadata=.\Model1.csdl|.\Model1.ssdl|.\Model1.msl;
        provider=System.Data.SqlClient;
        provider connection string=&quot;Data Source=Bhanu-pc\Bhanu;Initial Catalog=Udyoga;Integrated Security=True;MultipleActiveResultSets=False&quot;"
          providerName="System.Data.EntityClient" />
    </connectionStrings>
  
  Error Message:
  

  Keyword not supported: 'data source'.

  Seems like common issue, still couldn't solve it.

  I just moved thia application from linq to entity framework, it uses membership class/database also. I have connection string and membership provider defined in web.config also
  

  Windows 8 Professional 64 Bit.
  Visual Studio 2012
  Sql Server 2012
  -------------------------------------
  www.HermesWritings.com
• • Reply
  bhanu2217

  Member

  129 Points

  454 Posts

  Re: Entity Framework connection string not working

  Jun 14, 2011 03:15 AM|bhanu2217|LINK

  was doing couple of things wrong.

  Solution:

  Put the connection string from app.config to web.config and also changed the way i was trying to access this connection string.

  Windows 8 Professional 64 Bit.
  Visual Studio 2012
  Sql Server 2012
  -------------------------------------
  www.HermesWritings.com