Looks like you are using
Contains in your LINQ where clause.
LINQ to SQL will translate a Contains() to a SQL LIKE statement which is not case sensitive in general.
Try:
OPTION 1:
s = From row In context.Table Where String.Compare(row.Name, "test", StringComparison.CurrentCulture) = 0
OR
OPTION 2:
If you want to use the Contains clause then, best way would be to create your own comparer. Look here:
Enumerable.Contains[
^]