.net Sql New Table Doesn't Exist

NOTE: This issue has been resolved, but lead to a new question. I'm getting this error: System.Data.SqlClient.SqlException 'Invalid object name [tablename]' I'm working on a DB

Solution 1:

I'm not sure what AppEntities is but I'm pretty confident that it does not reflect the structure of your new database.

I'm going to take a guess that it is some form of generated code that is based purely on the initial version of the database and has not been recodegen'd (sp?) to hold information about the new tables. Hence, the error.

This would also explain why the application still fails at that same location when you have created the tables before it even runs.

To sum up, investigate AppEntities and figure out exactly how that thing works.