in my asp.net application I have a gridview with a LinqDataSource as its source. I have a function that filters the datasource with the following command:
That works fine.
But what do I have to change to allow for accent insensitive filters?
I read about the collation SQL_Latin1_General_CP1_CI_
AI and I set my Database to this collation.
But now I need to get the COLLATE statement somehow into the query.
Who can help?
Thanks a lot
myDataSource.WhereParameters.Add(key, dbType, value);
myDataSource.Where = key + ".Contains(@" + key + ")";