{"id":36,"date":"2018-09-26T18:16:00","date_gmt":"2018-09-26T16:16:00","guid":{"rendered":"https:\/\/kindsonthegenius.com\/blog\/2018\/09\/26\/how-to-generate-stored-procedures-automatically-using-visual-studio\/"},"modified":"2020-08-22T08:48:35","modified_gmt":"2020-08-22T06:48:35","slug":"how-to-generate-stored-procedures-automatically-using-visual-studio","status":"publish","type":"post","link":"https:\/\/kindsonthegenius.com\/blog\/how-to-generate-stored-procedures-automatically-using-visual-studio\/","title":{"rendered":"How to Generate Stored Procedures Automatically Using Visual Studio"},"content":{"rendered":"

You don’t have to spend your time writing stored procedures. You simply generate them. By the way writing stored procedures have always be a pain for developers and DBAs.<\/p>\n

So as a genius, I found an easy way you can do it!<\/p>\n

Step by Step Video explanation<\/a>
\n<\/u>
\nPrerequisite<\/b>
\nYou must have an existing table in MS SQL Server<\/p>\n

 <\/p>\n

Step 1<\/b>: Create a Project in Visual Studio<\/p>\n

Step 2<\/b>: Right-click on the project in Solution explorer and choose Add > New Item<\/p>\n

Step 3<\/b>: Choose Data in the left sided under C# and then Choose DataSet from the right<\/p>\n

 <\/p>\n

 <\/p>\n

<\/a><\/div>\n

 <\/p>\n

Step 4<\/b>: Give the DataSet a name and Click on Add (The DataSet Designer windows opens up as shown)<\/p>\n

Step 5<\/b>: Right-click and the design surface and choose Add > TableAdapter<\/p>\n

 <\/p>\n

<\/a><\/p>\n

Step 6<\/b>: Create a New Connection or Select an existing one an click Next<\/p>\n

<\/a><\/b><\/i><\/u>
\n<\/b><\/i><\/u>
\nStep 7<\/b>: Click Next again to display Choose Command Type window<\/p>\n

Step 8<\/b>: Choose Create New Stored Procedure and Click on Next<\/p>\n

 <\/p>\n

<\/a><\/div>\n

 <\/p>\n

Step 9<\/b>: Click on Query Builder, Select the table and the close Query Builder ( you can also write the select statement yourself)<\/p>\n

Step 10<\/b>: Click on Next<\/p>\n

Step 11<\/b>: Give the stored procedure names and Click Finish.<\/p>\n

<\/a><\/div>\n

You’re done!.<\/p>\n

By now, your stored procedures are beautifully created in SQL Server. You can now open SQL Server Management Studio to verify that your stored procedures have been created.<\/p>\n

<\/a><\/div>\n

 <\/p>\n

<\/a><\/div>\n
<\/div>\n
Step by Step Video explanation<\/a><\/div>\n
<\/div>\n

So by now you have learnt how to generate stored procedure in SQL Server using Visual studio.
\nWatch the video explanation and subscribe to the free lessons.<\/p>\n