Database Connection - LINQ Entities RSS

• • Reply
  

  dennismachel

  Member

  73 Points

  117 Posts

  Database Connection - LINQ Entities

  May 01, 2011 09:35 PM|LINK

  I have the following connections defined in my web.config;

  <connectionStrings>
      <add name="PlanOfStudy" connectionString="Server=ZAKEERA\SQL08DMH;Database=PlanOfStudies;Trdusted_Connection=Yes" />
      <add name="ApplicationServices" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient" />
    <add name="PlanOfStudiesEntities" connectionString="metadata=res://*/Models.Entities.ModelplanOfStudy.csdl|res://*/Models.Entities.ModelplanOfStudy.ssdl|res://*/Models.Entities.ModelplanOfStudy.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=ZAKEERA\SQL08DMH;Initial Catalog=PlanOfStudies;Integrated Security=True;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />
  </connectionStrings>

   

  However, when I run my application I am noticing that the database field is empty;

  usrLogin.Connection
  {System.Data.EntityClient.EntityConnection}
      [System.Data.EntityClient.EntityConnection]: {System.Data.EntityClient.EntityConnection}
      base {System.ComponentModel.Component}: {System.Data.EntityClient.EntityConnection}
      ConnectionString: "name=PlanOfStudiesEntities"
      ConnectionTimeout: 15
      Database: ""
      DataSource: "ZAKEERA\\SQL08DMH"
      ServerVersion: 'usrLogin.Connection.ServerVersion' threw an exception of type 'System.InvalidOperationException'
      State: Closed
  

• • Reply
  

  alex_brambil...

  Participant

  761 Points

  278 Posts

  Re: Database Connection - LINQ Entities

  Jan 03, 2013 11:21 PM|LINK

  PlanOfStudiesEntities is not a database connection string.  It's an entity framework connection string, i.e. it connects to your model classes in your project not your database.  If you want to connect ot your database use the PlanOfStudy connection string.