Introduction:
In this article, i am going to explain about how to create a new database from visual studio.
Main:
First, make sure you have SQL Server (the Express Edition is fine) or
another database server installed. Although SQL Server will automatically integrate
with Visual Studio, you may have to download additional components to allow thirdparty
databases to work inside Visual Studio. This section will assume you are
using SQL Server.
1. Open Server Explorer (Ctrl+W, L or from the View menu).
2. Right-click Data Connections and choose Create New SQL Server Database.
3. Pick your server instance from the drop-down box and select the appropriate
authentication method (usually chosen when you set up the server).
4. Type in a name—for example, “TestDB”—and hit OK.
5. Expand the new database that was created for you.
6. Right-click Tables and select Add New Table.
7. Configure the table
8. Close the window and give the table the name Books.
9. To add data, right-click the created table and select Show Table Data.
Thats it.
Conclusion:
Hope this helps,
Happy Coding.