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?


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! 



Please sign in to leave a comment.