asp.net mvc - System.Data.SqlClient.SqlException: Invalid object name 'dbo.Projects'

Question

(Closed.) This question needs debugging details. It is not currently accepting answers. question from:https://stackoverflow.com/questions/1355795/system-data-sqlclient-sqlexception-invalid-object-name-dbo-projects

Answer 1

Check the Initial Catalog parameter in your connection string. It may be that your code is looking in the wrong database for the Projects object.

For example, if you have database syncing setup in such a way that only a subset of the master-database's tables are transferred, you can encounter this error if Linq to SQL is expecting all tables to be in the database pointed to by the connection string.