nVarchar and SqlParameter
I'm developing an application which must support several languages. To solve the special characters problem I'm using NVarhcar for my text fields. So my SQL query for a text field is
insert into tbl_text(text)values(N'Chci tančit v oblasti')
My problem is to put it in SqlCommand, wich is "insert into tbl_text(text)values(N@text)". It saves "N@text" in the DB table, sure.
Do you guys know someway to do it? I'm using C# and SQL 2008.
Sorry if it was hard to understand my question. My English is poor =/
Answer
Add(string, object) has been deprecated for this reason (from Pablo Castro of the SQL Server team):
The problem is that both the C# and the VB.NET compilers will expose very weird behavior for this code:
command.Parameters.Add(“@p”, 0);
you may expect this to use the overload that takes an object and assign the value 0 to it, but instead it will pick the overload that takes a SqlDbType as the second parameter! In order to avoid this (and potentially others) ambiguity between the Add(string, sqldbtype) and Add(string, object), we deprecated Add(string, object) and introduced AddWithValue(string, object). In general, having multiple overloads where the distinguishing parameter type is “object” in one of them is a dangerous thing to do.