Creating Data Application in Visual Studio 2013 Preview

Introduction

Today, I am describing how to work on Data Applications in Visual Studio 2013 Preview. With the release of Visual Studio Preview 2013, working on a Data Application in Visual Studio is easier and helpful. The new version of Visual Studio has the very exciting feature to create Data Applications. All you need to do that connects your database with Visual Studio and then you can create entire queries, triggers, procedures anything. It feels like you are working in the SQL Server. Visual Studio 2013 Preview works easily with the SQL Server version 2012.

Let's have a look at how it works. The following is the relevant procedure that helps:

1. Connect to the Database
2. New Query Option
3. Query Execution
4. Queries
5. IntelliSense

Brief

1. Connect the database with IDE: In the Server Explorer window, select the Data Connection and right-click. Click "Add Connection". Select your SQL Server name or just write it and select your database name and click on "Test Connection" (optional) to confirm that the connection is successful.
   
   
    
2. Goto New Query Option: After creating the connection and database, select the connection and then right-click to go to the New Query option. A New Query window is opened in which you can write and executes the SQL Queries, Procedures, Triggers and so on.
   
   
    
3. Query Execution: Now when the window is opened, it feels like you are working in the New Query window of SQL Server. The execution of queries will be performed by Ctrl+Shift+E. Just select the query and press Ctrl+Shift+E. The query executes and the result and message option dialog box opens in the bottom just like in SQL Server.
   
   
    
4. Queries: Write your SQL Queries, execute the queries and see the result.
   
   
    
5. IntelliSense: In Visual Studio 2013 Preview the presence of IntelliSense is very helpful to code fast. You don't need to go to SQL Server for Query Execution.
    

A typical Data Application uses the processes listed below:

• Connecting Data
• Receiving Data
• Fetching Data
• Editing Data
• Validating Data
• Saving Data