dotConnect for PostgreSQL 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.

• NewGuidGenerationMethod. Determines which method to use for GUID generation when translating the NewGuid Entity Framework canonical function. This option can have the following values:

  • Default. In this case GUIDs are generated using a specific SQL expression. PostgreSQL uuid-ossp functions are not used.

  • UuidGenerateV1. In this case the uuid_generate_v1() PostgreSQL function is used. This function generates a version 1 UUID. Note that generation involves the MAC address of the computer and a time stamp, and thus, may reveal the identity of the computer that created the GUID and the time of the generation.

  • UuidGenerateV1mc. In this case the uuid_generate_v1mc() PostgreSQL function is used. It generates a version 1 UUID using a random multicast MAC address instead of the real MAC address of the computer.
  • UuidGenerateV4. In this case the uuid_generate_v4() PostgreSQL function is used. This function generates a version 4 UUID, derived entirely from random numbers.

• OrderByNullBehavior. Determines how NULL values will participate in sorting (whether to add NULLS FIRST or NULLS LAST to the ORDER BY clause of generated SQL queries). This option can have the following values:

  • Default. In this case neither NULLS FIRST nor NULLS LAST is added to the generated ORDER BY clauses.

  • NullsFirst . In this case NULLS FIRST is added to the generated ORDER BY clauses.

  • NullsLast. In this case NULLS LAST is added to the generated ORDER BY clauses.
• 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.PostgreSql.Entity tag.