Create database for Entity Framework

down voteaccepted

Follow below steps: 1) First go to Server Explorer in Visual Studio, check if the ".mdf" Data Connections for this project are connected, if so, right click and delete. 2 )Go to Solution Explorer, click show All Files icon. 3) Go to App_Data, right click and delete all ".mdf" files for this project. 4) Delete Migrations folder by right click and delete. 5) Go to SQL Server Management Studio, make sure the DB for this project is not there, otherwise delete it. 6) Go to Package Manager Console in Visual Studio and type: Enable-Migrations -Force Add-Migration init Update-Database 7) Run your application Note: In step 6 part 3, if you get an error "Cannot attach the file...", it is possibly because you didn't delete the database files completely in SQL Server. if  this error :A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 50 - Local Database Runtime error occurred. The specified LocalDB instance does not exist. )        : sqllocaldb c Projects 11.0 Command line explained c - is for "create" "Projects - is the instance name 11.0 is the version