ASP.NET MVC how to connect to SQL Server and create new database?

Question

I'm learning this tutorial: http://www.codeproject.com/Articles/986730/Learn-MVC-Project-in-days-Day

I have problem with day 3 in first step - Step 1 – Create Database. I don't know how do this.

UPDATE

Ok, I added this DB, this is the tree in SQL Server Object Explorer I have an error:

An exception of type 'System.Data.SqlClient.SqlException' occurred in EntityFramework.dll but was not handled in user code

in return

public List<Employee> GetEmployees()
    {
        SalesERPDAL salesDal = new SalesERPDAL();
        return salesDal.Employees.ToList();
    }

This is my connectionString

<connectionStrings>
    <add connectionString="Data Source=(LocalDb);Initial Catalog=SalesERPDB;Integrated Security=True"
            name="SalesERPDAL"
            providerName="System.Data.SqlClient"/>
</connectionStrings>

I added DB in App_Data project folder

Visual Studio has a "Server Explorer" pane which can connect to a database. Conversely, the database itself should have some kind of tool for connecting and managing databases. (Such as SQL Server Management Studio.) — David
– David, Commented Aug 17, 2016 at 19:30
Try to add your SQL instance name to the datasource ("LocalDb\MSSQLLocalDB") — Reinard
– Reinard, Commented Aug 17, 2016 at 21:47

Sebastian Estrada · Accepted Answer · 2016-08-17 20:20:27Z

1

Do you have installed SQL Server Management Studio? an easy way to create a database is using this tool.

Just connect to the local instance and you will see a folder named DataBases, then Right-click > New Database...a window will appear to name this database as you wish

answered Aug 17, 2016 at 20:20

Sebastian Estrada

3073 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

ASP.NET MVC how to connect to SQL Server and create new database?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related