Page 1 of 1

How do i get DbContextOptions From DbContextOptionsBuilder().UsePostgreSql extension

Posted: Thu 13 Dec 2018 07:36
by tommyiraone
I used to use this code using Npgsql
new DbContextOptionsBuilder().UseNpgsql(_arg_connection).Options;

but i cannot get the .Options using UsePostgreSql extension.
DbContextOptionsBuilder().UsePostgreSql(_arg_connection);

How do i get DbContextOptions From DbContextOptionsBuilder().UsePostgreSql extension ?

Re: How do i get DbContextOptions From DbContextOptionsBuilder().UsePostgreSql extension

Posted: Fri 14 Dec 2018 09:34
by Shalex
The .UsePostgreSql() extension method is defined in Devart.Data.PostgreSql.Entity.EFCore.dll:

* .NET Standard (.NET Core) version of this assembly is included into the package https://www.nuget.org/packages/devart.d ... sql.efcore

* .NET Framework version is created by the installation at C:\Program Files (x86)\Devart\dotConnect\PostgreSQL\Entity\EFCore2\Devart.Data.PostgreSql.Entity.EFCore.dll

Re: How do i get DbContextOptions From DbContextOptionsBuilder().UsePostgreSql extension

Posted: Fri 14 Dec 2018 12:50
by tommyiraone
The .UsePostgreSql() is not the problem.

the problem is there is no .Options property after .UsePostgreSql() method.

if i use Npgsql
DbContextOptions _option = new DbContextOptionsBuilder().UseNpgsql(_connection).Options;

if i use SqlServer
DbContextOptions _option = new DbContextOptionsBuilder().UseSqlServer(_connection).Options;

but if use dotConnect for PostgreSQL.. there is no .Options.
PgsqlDbContextOptionsBuilder does not contain definition for 'Options'...

Re: How do i get DbContextOptions From DbContextOptionsBuilder().UsePostgreSql extension

Posted: Sun 16 Dec 2018 22:51
by tommyiraone
how can I get support more faster? I already have a license... i need this asap.. this is to slow....

Re: How do i get DbContextOptions From DbContextOptionsBuilder().UsePostgreSql extension

Posted: Mon 17 Dec 2018 20:29
by Shalex
tommyiraone wrote: Sun 16 Dec 2018 22:51there is no .Options property after .UsePostgreSql() method
1. We will investigate the question and notify you about the result. As a current solution, you can get the same functionality via DbContextOptionsBuilder.Options.
For example:

Code: Select all

  var builder = new DbContextOptionsBuilder<postgresModel>();
  builder.UsePostgreSql(@"...");
  builder.Options...
tommyiraone wrote: Sun 16 Dec 2018 22:51how can I get support faster?
2. Our support has a two business day response policy: https://www.devart.com/dotconnect/postg ... pport.html. But we do our best to respond as soon as possible.

Re: How do i get DbContextOptions From DbContextOptionsBuilder().UsePostgreSql extension

Posted: Mon 17 Dec 2018 21:31
by tommyiraone
ok, thanks

Re: How do i get DbContextOptions From DbContextOptionsBuilder().UsePostgreSql extension

Posted: Fri 25 Oct 2019 18:37
by Shalex
Entity Framework Core 3.0 is supported in dotConnect for PostgreSQL v7.15.1499: viewtopic.php?f=3&t=39477.

In EF Core 3.0, UsePostgreSql() returns DbContextOptionsBuilder that has Options.