CODEWITHSUNDEEP
asp.net-mvc-3entity-frameworkef-code-first
MrMortales
MrMortales

Reputation: 647

InnerException {"Invalid object name 'dbo.Users'"}

I am currently trying to setup an ASP.Net MVC 3 Application for the first time. I know what I am doing with Ruby on Rails but completely lost with ASP.Net. I would like the app to create the database but not sure what I am doing wrong. I have an empty Database build called ssDB. I have setup the connectionStrings and built out the Model classes. According to everything I have read thus for, when I go to the run the App it should create the database but it doesn't look that way.

The Abbreviated Error I get is:

InnerException: System.Data.SqlClient.SqlException
Message=Invalid object name 'dbo.Users'.
Source=.Net SqlClient Data Provider
ErrorCode=-2146232060
Class=16
LineNumber=1
Number=208
Procedure=""
Server=TESTSVR01
State=1

Upvotes: 2

Views: 4796

Answers (2)

Wasif Subzwari
Wasif Subzwari

Reputation: 199

I also experienced the same issue while using Database first approach. Connection string in my service's/service's host web.config was incorrect. I corrected the connection string and it worked.

Upvotes: 1

Eranga
Eranga

Reputation: 32437

I have an empty Database build called ssDB

You have created an empty database with no tables. Since there is a database EF assumes tables are also created. Hence it will not proceed to create the tables.

You can drop the database and allow EF to create the database and the tables.

Upvotes: 6

Related Questions