dotConnect for SQLite has some options that customize translating LINQ to Entities to SQL statements. The list of these options includes:

• NoEscapeLike - allows disabling ESCAPE in LIKE expression. The default value is false.
• CaseInsensitiveLike - allows using case insensitive comparison mode, when translating LINQ to Entities extension methods .Contains(), .EndsWith(), .StartsWith(). The default value is false.
• CaseInsensitiveComparison - allows using case insensitive comparison mode, when translating LINQ to Entities extension method .Equals(). The default value is false.
• UseCSharpNullComparisonBehavior - allows performing NULL checks when comparing a property (column) with a value (parameter) in LINQ to Entities. The default value is false.

These options can be set either in code as the properties of the EntityProviderConfig.QueryOptions object or in the project config file as the attributes of the QueryOptions element of the Devart.Data.SQLite.Entity tag.