'I am beginner in asp.net mvc and getting the following error

System.Data.Entity.Core.MetadataException: 'Unable to load the specified metadata resource.'

Code:

IPagedList<Tbl_Product> data = context.Database
                                      .SqlQuery<Tbl_Product>("GetBySearch @search", param)
                                      .ToList()
                                      .ToPagedList(page ?? 1, pageSize);
return new HomeIndexViewModel
c++sharpasp.net-mvcpagedlist


Solution 1:[1]

Try - Right click on the project>>Clean>> and then Rebuild - This resolved the error for me.

Also, this question is similar to: System.Data.MetadataException: Unable to load the specified metadata resource

Solution 2:[2]

The error comes from SQL Server. It means that the server failed to find the procedure with name 'GetBySearch'

There might be several reasons for that:

  • typo in code or on the server - double-check that the name on the server matches exactly the name you call

  • double-check that the data source is set to the right server

  • double-check that the database name is specified, aka either it is set in the connection string or it is set by calling ChangeDatabase method on SqlConnection. Refer to MSDN for more details...

Let me know if you have more questions.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 DJN
Solution 2 DotNet Team

Related Questions