Forced unicode strings in sql

Question

Is there a way to force the sql connection to always "string" the user as a unicode string, without adding the prefix N (N'string) as n? I am using SQL 2008 and I have a data type in unicode (nvarchar, nchar, ...)

Answer 1

No, you always need to use N to denote a string literal in Unicode.

Or assign a C # string (for example) to the nvarchar parameter (and not any string concatenation)