Rider does not detect SQL in strings that begin with "DECLARE" or CTE

I love it when Rider helps me with SQL strings, but it fails to detect some basic SQL, such as strings that start by declaring a variable, like the following: var sqlQuery = “DECLARE @id INT = 0; SELECT @id = ID FROM Table;”. Same with SQL that starts with common table expressions, such as var sql = "WITH statusCTE(numId, txtName) AS (SELECT …). Is there anything I can do to get these to work? Is this a known issue?
 

1
2 comments

Hi flipdoubt

Unfortunately, this case is not supported in Rider. We have the following feature request. Feel free to follow it and upvote to show your interest! 

 

0

Please sign in to leave a comment.