Server Error in '/' Application.  Unable to load the specified metadata resource.
ArticleDBModel.Designer.cs    Line: 26
Line 26:         public ArticleEntities() :
Line 27:                 base("name=ArticleEntities", "ArticleEntities")

After studying tutorial 1* and documenting** some comments about it,
I finally began a non-trivial ASP.NET MVC applet.  Following the formula
laid out in tutorial #1, I created a database, then a table, then a model,
the a new controller, then proceeded to modify the Index view.  My
expectations were high because of the ease and magic I experienced
doing tutorial #1.  Unfortunately, when I clicked the "Articles" tab, I got:
    "Unable to load the specified metadata resource".

I spent hours on Google, in forums,asp.net, stackoverflow, and msdn
but nothing that I tried worked.  I examined every file in my solution
and the Movies tutorial with WinDiff.  Finally, I printed both Web.config
files and started highlighting the printouts.  Finally, I noticed:

<add name="ArticleEntities" connectionString="metadata=res://*/Scripts.ArticleDBModel.csdl|res://*/Scripts.ArticleDBModel.ssdl|res://*/Scripts.ArticleDBModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\mne.mdf;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient"/>

Hi Gerry,

I have been able to generate the connection string that you had at first by highlighting the scripts folder and:

Choosing 'add new item' , selecting 'ADO.Net Entity Data Model'

Choosing a filename of 'ArticleDBModel.edmx'

Choose generate from database, in the section that says save entity connection settings in the app.config as type 'ArticleEntities'

Choose some db tables and select the model namespace as 'ArticleDBModel'

It looks like you have then moved the .edmx file to the model folder, although when I do this from visual studio using drag-and-drop the connection string gets updated.

Any chance you did that from outside of visual studio?

Anyway I'm not sure that there is a bug here and if the connection string not getting updated for you is a bug it is most probably with the 'entity framework' tooling, not mvc.

Maybe it's worth just trying tha above steps again then moving the edmx using drag-and-drop to see if it is taken care of for you?

Hope that helps a bit,

Paul

<add name="ArticleDBEntities" connectionString="metadata=res://*/Controllers.AriticleDBModel.csdl|res://*/Controllers.AriticleDBModel.ssdl|res://*/Controllers.AriticleDBModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\mne.mdf;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />

<add name="ArticleEntities" connectionString="metadata=res://*/ArticleModel.csdl|res://*/ArticleModel.ssdl|res://*/ArticleModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\mne.mdf;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" /></connectionStrings>

                                   Note, above:  ArticleModel has no prefix.
Compare:
<add name="ArticleEntities"
connectionString="metadata=res://*/Models.ArticleDBModel.csdl|res://*/Models.ArticleDBModel.ssdl|res://*/Models.ArticleDBModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\mne.mdf;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient"/>

Again, I got the error that follows my signature, below.

Inserting Models. in front of ArticleModel resolved the error.

Given the consistently inconsistent behaviour, after 40+ years as a programmer,
to me this really looks like a BUG!

Regards,
Gerry (Lowry)

Line 24:         /// Initializes a new ArticleEntities object using the connection string found in the 'ArticleEntities' section of the application configuration file.
Line 25:         /// </summary>
Line 26:         public ArticleEntities() : 
Line 27:                 base("name=ArticleEntities", "ArticleEntities")
Line 28:         {

[MetadataException: Unable to load the specified metadata resource.]
   System.Data.Metadata.Edm.MetadataArtifactLoaderCompositeResource.LoadResources(String assemblyName, String resourceName, ICollection`1 uriRegistry, MetadataArtifactAssemblyResolver resolver) +3542846
   System.Data.Metadata.Edm.MetadataArtifactLoaderCompositeResource.CreateResourceLoader(String path, ExtensionCheck extensionCheck, String validExtension, ICollection`1 uriRegistry, MetadataArtifactAssemblyResolver resolver) +185
   System.Data.Metadata.Edm.MetadataArtifactLoader.Create(String path, ExtensionCheck extensionCheck, String validExtension, ICollection`1 uriRegistry, MetadataArtifactAssemblyResolver resolver) +63
   System.Data.EntityClient.EntityConnection.SplitPaths(String paths) +659
   System.Data.EntityClient.EntityConnection.GetMetadataWorkspace(Boolean initializeAllCollections) +148
   System.Data.Objects.ObjectContext.RetrieveMetadataWorkspaceFromConnection() +26
   System.Data.Objects.ObjectContext..ctor(EntityConnection connection, Boolean isConnectionConstructor) +172
   System.Data.Objects.ObjectContext..ctor(String connectionString, String defaultContainerName) +27
   mne.Models.ArticleEntities..ctor() in c:\!!!!!mne\mne\mne\models\articlemodel.designer.cs:26
   mne.Controllers.ArticleController..ctor() in C:\!!!!!mne\mne\mne\Controllers\ArticleController.cs:21

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck) +0
   System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache) +86
   System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache) +230
   System.Activator.CreateInstance(Type type, Boolean nonPublic) +67
   System.Web.Mvc.DefaultControllerFactory.GetControllerInstance(Type controllerType) +82

[InvalidOperationException: An error occurred while creating a controller of type 'mne.Controllers.ArticleController'. If the controller doesn't have a controller factory, ensure that it has a parameterless public constructor.]
   System.Web.Mvc.DefaultControllerFactory.GetControllerInstance(Type controllerType) +189
   System.Web.Mvc.DefaultControllerFactory.CreateController(RequestContext requestContext, String controllerName) +74
   System.Web.Mvc.MvcHandler.ProcessRequest(HttpContextBase httpContext) +128
   System.Web.Mvc.MvcHandler.ProcessRequest(HttpContext httpContext) +57
   System.Web.Mvc.MvcHandler.System.Web.IHttpHandler.ProcessRequest(HttpContext httpContext) +7
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +181
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75

I also came accross the same error but my problem was a different one.

I am using a seperate Class Library for my data access which has the Entities in it. I have a reference in my Web Project to the data class library, and when I tried to run my web project I got the same error about :

Unable to load the specified metadata resource

I discovered I had forgot to copy the Connection string from my data access Class library into my web project's web config.