Tag Archives: SQL

SQL inside C# strings, fragment editor, run query in console – Language injection updates in Rider 2018.3

The latest Rider 2018.3 EAP build extends Rider’s language injections functionality quite a bit, with SQL language support in string literals. This gives us highlighting, code completion and code analysis, and a Run in console action for SQL inside of a … Continue reading

Posted in How-To's | Tagged , , , , | 20 Comments

Working with Data in Rider

In previous blog posts in this series, we looked at connecting to a Microsoft SQL Server and getting familiar with the features in Rider 2017.3 to work with SQL databases. In this final post in our series, we will look … Continue reading

Posted in How-To's | Tagged , , , | 1 Comment

Working with Tables and Indexes in Rider

In previous blog posts in this series, we looked at connecting to a Microsoft SQL Server and getting familiar with the features in Rider to work with SQL databases. In this blog post, we will look at how to work … Continue reading

Posted in How-To's | Tagged , , , | 2 Comments

Getting started with database support in Rider

If you are new to using Rider, it’s worth mentioning that you get all the .NET features of ReSharper, along with the web development features of WebStorm, which provides the developer with great overall experience. What’s more, you also get … Continue reading

Posted in How-To's | Tagged , , , | 5 Comments

Configuring SQL Server 2017 for Rider

Rider is not only a great .NET IDE, it also is a wonderful tool for working with databases that are associated with .NET Core solutions. Many .NET Core developers use Microsoft SQL Server on their laptops; more specifically, the Developer … Continue reading

Posted in How-To's | Tagged , , , | 6 Comments

Understanding how SQL queries impact app performance, with dotTrace 6.1

Application performance depends on a huge variety of factors: code design, web server performance, possible network lags, and so on. Effective execution of SQL queries is an additional concern. Naturally, you want your profiler to cover as many of these … Continue reading

Posted in How-To's | Tagged , | 7 Comments