System.Data.EntityCommandExecutionException: An error occurred while executing th

Question

I have created a connectionstring in mvc3 application and it is working fine in mvc views and controllers and I am able to fetch data. Now I have called the repository/model functions in a Unit Test in Test project and I am getting error:

System.Data.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Invalid object name 'dbo.tblProduct'.

How can i fix it?

score 6 · Accepted Answer · answered Apr 08 '11 at 13:17

6

That has nothing to do particularly with MVC. As it seems, when testing, you use ConnectionString on database that does not have 'dbo.tblProduct' table/view. Check the connetion string and database. You may need to debug tests

answered Apr 08 '11 at 13:17

archil

39,013
7
65
82

score 2 · Answer 2 · edited May 23 '17 at 11:54

2

Check your table may have different schema (other then dbo) change it to dbo using query below

look at this. How do I change db schema to dbo

edited May 23 '17 at 11:54

Community

1
1

answered Jul 18 '11 at 20:02

Zeshan Sadiq

21
1

score 0 · Answer 3 · edited Aug 03 '15 at 13:58

0

Its very strange for my case, as it is required to do mapping between model and tables, the name has to be the same. When I added 's' at the end of table's name, it works. I don't know if this part work of what LINQ does.

edited Aug 03 '15 at 13:58

Dan Beaulieu

19,406
19
101
135

answered Mar 06 '13 at 15:30

Moe

197
6

System.Data.EntityCommandExecutionException: An error occurred while executing th

3 Answers3

Linked