setting EntityProviderConfig.QueryOptions

[ratm]

Hi I would need to set EntityProviderConfig.QueryOptions CaseInsensitiveLike = true. How can I do?

[Shalex]

With EF6, you can do that in code or via *.config:

a) in code (for example, in a static constructor of the context)

Code: Select all

            var config = Devart.Data.PostgreSql.Entity.Configuration.PgSqlEntityProviderConfig.Instance;
            config.QueryOptionsCaseInsensitiveLike=true;

b) via *.config

Code: Select all

  <configSections>
    <section name="Devart.Data.PostgreSql.Entity" type="Devart.Data.PostgreSql.Entity.Configuration.PgSqlEntityProviderConfigurationSection, Devart.Data.PostgreSql.Entity.EF6, Version=7.12.1328.0, Culture=neutral, PublicKeyToken=09af7300eec23701" />
  </configSections>
  <Devart.Data.PostgreSql.Entity xmlns="http://devart.com/schemas/Devart.Data.PostgreSql.Entity/1.0">
      <QueryOptions CaseInsensitiveLike="true" />
  </Devart.Data.PostgreSql.Entity>

Refer to https://www.devart.com/dotconnect/postg ... tions.html.

[ratm]

80/5000
I can't get it to work on the code in * .config
How can I do?

[Shalex]

Please specify:
1) the name of ORM framework you use and its version (e.g.: LinqConnect, Entity Framework 6, Entity Framework Core, etc)
2) the value of Target framework set in the properties of your Visual Studio project

[ratm]

Freamwork .NET 4.5 and use LinqConnection

[Shalex]

Devart.Data.PostgreSql.Entity.Configuration.PgSqlEntityProviderConfig works with Entity Framework (not LinqConnect).

Refer to viewtopic.php?f=3&t=38492.