EF4 and Connection String

Question

I have a 3 tiered project.

1) Project.Data (EDMX file)
2) Project.Model (POCO's)
3) Project.Console (Console app)

I have added the connection string into the Project.Console.

<?xml version="1.0" encoding="utf-8"?>
<configuration>
    <connectionStrings>
        <add name="ProjectEntities" connectionString="metadata=res://*/Project.csdl|res://*/Project.ssdl|res://*/Project.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=PC\SQLEXPRESS;Initial Catalog=Project;Integrated Security=True;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />
    </connectionStrings>
</configuration>

The Project.Model is built using the EntityObject T4 Template in VS2010. It generates a ObjectContext class, with this constructor:

public ProjectEntities() : base("name=ProjectEntities", "ProjectEntities")
{
    this.ContextOptions.LazyLoadingEnabled = true;
    OnContextCreated();
}

I am just trying to instantiate the context object, in the Project.Console:

namespace Project.Console
{
    class Program
    {
        static void Main(string[] args)
        {
            ProjectEntities pe = new ProjectEntities();
        }
    }
}

However, I am getting a MetadataException was unhandled error at the constructor. Stating Unable to load the specified metadata resource.

I have done a ton of research (Googling), and found that it seems to be a linking issue on those resources. I cannot seem to find a resolution.

Any help is appreciated.

I read the article that Craig suggested, but I am still uncertain where I have to place the ...dll file reference? I have a scenario likes yours. I am assuming in the Project.Model's app.config? I have my context and pocos separated from the edm file in separate project as in your case, Project.Model. — Brendan Vogt
– Brendan Vogt, Commented Oct 26, 2010 at 12:39
In my console project I needed a reference to my data (EDMX) and model project. It also required a reference to System.Data.Entity. — Dustin Laine
– Dustin Laine, Commented Oct 26, 2010 at 13:49

Craig Stuntz · Accepted Answer · 2010-10-21 12:59:51Z

8

I wrote a lengthy guide to debugging this error a while back.

answered Oct 21, 2010 at 12:59

Craig Stuntz

127k12 gold badges257 silver badges275 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Devart · Accepted Answer · 2010-10-21 10:43:56Z

3

Open your assembly using any resource viewer (e.g., RedGate .NET Reflector) and check that the name of the metadata resource is the same that you have specified in the app.config.

answered Oct 21, 2010 at 10:43

Devart

120k23 gold badges172 silver badges189 bronze badges

Comments

Bill the Lizard · Accepted Answer · 2012-10-02 02:48:37Z

0

Please replace the *　with your project.data assembly like below

<add name="ProjectEntities" connectionString="metadata=res://Project.Data/Project.csdl|res://Project.Data/Project.ssdl|res://Project.Data/Project.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=PC\SQLEXPRESS;Initial Catalog=Project;Integrated Security=True;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />

edited Oct 2, 2012 at 2:48

Bill the Lizard

407k213 gold badges579 silver badges892 bronze badges

answered Jul 20, 2012 at 19:43

SystemBug

31

Collectives™ on Stack Overflow

EF4 and Connection String

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related