Hi guys,
I'm having problem with case sensitive collation of SQL Database. one
my client is having case sensitive database. While developing the Data
Layer i didn't consider this scenario.
the problem is I've all Store Procedures in the Database and I'm using
sqlcommand to execute those SPs with Parameters.
for e.g.
Data Layer:
......
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add("@param1", SqlDbType.VarChar);
........
Case Sensitive Database:
PROCEDURE [dbo].[SPxyz]
.....
@Param1 [nvarchar](4000),
......
you can notice that the parameter in the C# Code is in small cape
"param1" while it is declare with capital latter in Database "Param1".
this is causing the failure while executing the procedure through the
code.
Is it possible to ignore the case sensitivity while executing the SP
through code?
I would appreciate your response over my Query. if there is a ways to
ignore the case, then it will save lot of time to me otherwise i've to
go through several SPs to check for the parameter casing.
thanks,
Lucky