Page 1 of 1
setting EntityProviderConfig.QueryOptions
Posted: Mon 11 Mar 2019 15:47
by ratm
Hi I would need to set EntityProviderConfig.QueryOptions CaseInsensitiveLike = true. How can I do?
Re: setting EntityProviderConfig.QueryOptions
Posted: Wed 13 Mar 2019 16:29
by 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.
Re: setting EntityProviderConfig.QueryOptions
Posted: Sat 23 Mar 2019 15:31
by ratm
80/5000
I can't get it to work on the code in * .config
How can I do?
Re: setting EntityProviderConfig.QueryOptions
Posted: Mon 25 Mar 2019 15:38
by 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
Re: setting EntityProviderConfig.QueryOptions
Posted: Tue 26 Mar 2019 16:33
by ratm
Freamwork .NET 4.5 and use LinqConnection
Re: setting EntityProviderConfig.QueryOptions
Posted: Thu 28 Mar 2019 13:22
by Shalex
Devart.Data.PostgreSql.Entity.Configuration.PgSqlEntityProviderConfig works with Entity Framework (not LinqConnect).
Refer to
viewtopic.php?f=3&t=38492.