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

Question

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

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. — Community
– Community Bot, Commented Mar 5, 2022 at 13:18

DJN · Accepted Answer · 2022-03-04 18:19:13Z

0

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

answered Mar 4, 2022 at 18:19

DJN

1722 silver badges12 bronze badges

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

1 Comment

Waseem khan Over a year ago

Thanks mate it worked but now giving following exception Could not find stored procedure 'GetBySearch'.

user3497034 · Accepted Answer · 2022-03-07 15:12:17Z

0

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.

answered Mar 7, 2022 at 15:12

user3497034

Collectives™ on Stack Overflow

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

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related