SqlCommand with where clause backslashes [closed]

Question

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers.

This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers.

Closed 4 years ago.

Improve this question

There is a matching record in the DB for DESKTOP-123\\markj. When I execute the code in SQL Server Management Studio, it returns one record.

DECLARE @User NVARCHAR(260) = 'DESKTOP-123\\markj'

SELECT r.RoleName 
FROM dbo.WindowsAuthenticationRole war 
JOIN dbo.[Role] r ON r.RoleId = war.RoleId 
WHERE war.[User] = @User

However this C# code returns 0 records

SqlCommand command = new SqlCommand("SELECT r.RoleName FROM dbo.WindowsAuthenticationRole war JOIN dbo.[Role] r ON r.RoleId = war.RoleId WHERE war.[User] = @User", connection);

command.Parameters.Add("@User", SqlDbType.NVarChar).Value = @"DESKTOP-123\\markj";

How can I get the SQL command in C# to work?

Update

The responses helped me troubleshoot, I actually had the value saved in the DB with two slashes.

There is a matching record in the DB for "DESKTOP-123\markj". ← You are using the @ symbol so you only should use one backslash as it is no longer escaped. @"DESKTOP-123\markj"; — Igor
– Igor, Commented May 24, 2021 at 14:00
Likewise in Sql Server you do not escape backslash at all in a string (varchar/nvarchar or char nchar). DECLARE @User NVARCHAR(260) = 'DESKTOP-123\markj' — Igor
– Igor, Commented May 24, 2021 at 14:02

Jawad · Accepted Answer · 2021-05-24 14:02:25Z

3

use either @ without escaping the backslash.. or escape it without @

command.Parameters.Add("@User", SqlDbType.NVarChar).Value = @"DESKTOP-123\markj";

//or
command.Parameters.Add("@User", SqlDbType.NVarChar).Value = "DESKTOP-123\\markj";

Documentation on string interpolation.

answered May 24, 2021 at 14:02

Jawad

11.4k3 gold badges28 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SqlCommand with where clause backslashes [closed]

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related