Step: Database is Created and now it's time to create the table to the database, as these database tables are used in your applications.Īdd New Table And Design The Database And Tables As RequiredĪdd Table and create the data as you require for your application and start consuming the database into your application using the connection string fetched from Database ADO.Net Connections.

Select Microsoft SQL Server Database File -> okīrowse to create a DB file in Location : Always Recommeneded to create in APP Data folder of the project – using Browse Option You will have many options like ODBC, SQL ect.

Step: In Add Connection, you will be provided the option to select and add any new connection of the database.

The Add Connection is the command used to add the new server connection or any of the database connections to the Data Connections.

Step: Create a DataBase using Add Connection.

Go to view -> server Explorer or Ctrl+W+L, Server Explorer is the place where all the database server related information will be available.

Step: In the View menu open the “Server Explorer”.

Step: Open Visual Studio and select view option.

Here the step by step process is explained with screen shots. When you require SQL database and do not want to install SQL Server in your machine then here is the solution for consuming the SQL database in your application where you don't need to install SQL installations. They have options to have many data sources.

This article which will help all the people who need to work with the visual studio application and aren't very dependent on the data part.

Visual studio 2017 sql server compact