I'm using C# in VisualStudio 2008 for database Windows application. I've got connection "db" to local database. Database contained table "tblBib" with string-type column "Redak". I want to query this table and get out all rows in which column "Redak" contains substring "Adams", but I don't want rows with substring "adams" or "aDams". I want case sensitive search.
I've tried this:
var linqUpit =
from redovi in db.tblBib
where redovi.Redak.Contains("Adams")
select redovi;
but this code gives back "Adams" and "adams" and "aDams".
What's missing?
Thanks.