Having trouble with LinqPad Adding a Connection to Entity Framework

linqpad
Alan Fisher picture Alan Fisher · May 15, 2012 · Viewed 7k times · Source

I am new to Entity Framework and Linq to Entities and I want to try LinqPad but I can't figure out how to make a connection to the edmx model I have created. I have an MVC project and I added an ADO.Net Entity Data Model against a SQL Sever database ( a Development server, not one on my local machine) Did a Build.Right click in my designer surface and Add Code Generation Item. That has given me two .tt folders, one for my dbContext class, one with all my classes.

Open LinqPad click on Add Connection. Point to the .dll file in my solutions bin folder, then in the Full Type Name of dbContext I choose the entity I created. Now is whee I am having trouble making this work. I point to the solution web.config file and when I click the Test button I get an error saying "Could not load file or assembly 'Entity Framework version=..." & "The system cannot find the file specified. (C:\users..\web.config line 9" Any ideas?

Answer

Pauli picture Pauli · May 21, 2012

I took configSections away from config file and connection works.

  <configSections>
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=4.3.1.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
  </configSections>
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlCeConnectionFactory, EntityFramework">
      <parameters>
        <parameter value="System.Data.SqlServerCe.4.0" />
      </parameters>
    </defaultConnectionFactory>
  </entityFramework>

Related questions

LinqPad - Convert SQL to Linq command

I recently purchased LINQPad in hopes that it would allow me to convert SQL statements into LINQ statements. Using LINQPad, I am able to attach a DB and run the SQL statement which returns the results I need. But I …

Read More
How does LINQ expression syntax work with Include() for eager loading

I have a query below, but I want to perform an Include() to eager load properties. Actions has a navigation property, User (Action.User) 1) My basic query: from a in Actions join u in Users on a.UserId equals u.…

Read More
LINQPad [extension] methods

Does anyone have a complete list of LINQPad extension methods and methods, such as .Dump() SubmitChanges()

Read More