Can I automatically generate queries on Visual Studio similar to what SQL Server Management Studio does?

I had SQL Server Management Studio on my computer and I used it to explore my database. When building the queries, it was very easy to right click on the table and select the "1000" rows. I would take this code and change it. This will allow me to shorten the time to enter all the field names eg.

Now I have MS Visual Studio and I cannot install Server Management Express. I can explore the database and I can right click on the table and view the records. However, I cannot automatically generate a select query. How can I create these queries automatically and is there a way to visually design my SQL query?


source to share

1 answer

In Visual Studio, if you run tools -> Server Explorer and add a DB connection, then you can simulate management studio option to generate sql from db objects ...



All Articles