Greetings,

We've created a wrapper component around ADO.NET (written in VB.NET).  When
we build a string in C# that contains escape characters "\r\n" or "\t",
etc., and pass them to the data access wrapper, VB.NET actually sees the
string as "something\r\n\telse" and thus, we aren't able to execute the RAW
SQL scripts that we're trying to execute.  However, if we simple use ADO.NET
directly it works just fine.  The wrapper component doesn't do anything that
we aren't doing directly.  When we log, we can see, at the point where we
pass the string to the VB.NET function and log the parameter that it picks
the escape characters as part of the string rather than converting them to a
VB equivelent.

My question is: how can we solve this problem?


Thanks,
Shawn

Create my own db connection wizard
asp.net sql connection problem
SqlConnection - Timeout Property is read-only?
Operation must use an updateable query... while trying to write to Excel file
DAL