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.
s = From row In context.Table Where String.Compare(row.Name, "test", StringComparison.CurrentCulture) = 0
If you want to use the Contains clause then, best way would be to create your own comparer. Look here: