entity framework compare strings ignore case code example

Example: entity framework string comparison case sensitive

ALTER TABLE Thingies
ALTER COLUMN Name VARCHAR(25)
COLLATE Latin1_General_CS_AS
default is --> SQL_Latin1_General_CP1_CI_AS