Stack Overflow
Stack Overflow

Questions tagged [devart]

Devart is a software development company specializing in native data access solutions, tools and database tools for the most popular databases, including MS SQL Server, MySQL, Oracle, PostgreSQL, InterBase, Firebird, and SQLite.

Devart is a software development company specializing in native data access solutions, tools and database tools for the most popular databases, including:

  • MS SQL Server
  • MySQL
  • Oracle
  • PostgreSQL
  • InterBase
  • Firebird
  • SQLite.

We try to provide high-end products to let you have the fastest data access and the broadest database support.

386 questions
0
votes
0 answers

How can I enable the DevArt performance counters in Resource Monitor?

I'm using the DevArt dotConnect for Oracle performance counters in my dev/test environment. By adding Use Performance Monitor=True to my database connection string, I can capture useful information such as number of connections, etc. However, on my…
Gary McGill
  • 26,400
  • 25
  • 118
  • 202
0
votes
1 answer

How to work with an DevArt edml file and start a connection?

I am working with the newest DevArt Oracle version and created a EDML file that connects to my Oracle 12 database and get the models with the db first approach. I followed this howto: https://www.devart.com/entitydeveloper/docs/ So I have my context…
PassionateDeveloper
  • 14,558
  • 34
  • 107
  • 176
0
votes
1 answer

Upgrading EF6 to EF Core 3 with Devart.MySql

I've been trying to upgrade our Entity Framework from EF6 to EF Core 3.1 and I get this weird error. So here are the steps that I did or some info that might help Current .NET framework version is 4.7.2 Using EF Core 6 Using MySQL Upgrade EF Core…
Aj Grandeza
  • 75
  • 1
  • 8
0
votes
0 answers

Is Devart Oracle provider support split query feature which is newly added in EF Core 5?

One of my projects is in EF core 3.1. This uses the Devart Oracle provider. Now I need to upgrade this project into EF Core 5. In a POC I found that using devart the split query feature is not working as demonstrated in the document. The code…
Achyut
  • 29
  • 8
0
votes
0 answers

How to get TCustomUniDataSet from a TUniQuery in Delphi

I have a TUniQuery in Delphi, using the DevArt component. This works fine, and I can assign values using syntax like qry1.Fields[1].AsString. But to avoid absolute indexing of database fields I would like to work with field names instead. After…
MyICQ
  • 987
  • 1
  • 9
  • 25
0
votes
3 answers

How can I scaffold with multiple schemas and particular table?

I have two schemas Bob and Bill. I want to scaffold with schema Bob all tables and with schema Bill only View_Otf table. If I use the following code, I get an empty DbContext: dotnet ef dbcontext scaffold "Data…
littleO
  • 33
  • 6
0
votes
1 answer

Problem accessing PostgreSql with TLS 1.2 using Devart library

I'm using the library Devart.Data.PostgreSql (https://www.nuget.org/packages/Devart.Data.PostgreSql/) to interact with PostgreSQL from a C# application, but I run into problems when I try to connect to a PostgreSQL instance hosted in Azure that…
Øystein Kolsrud
  • 359
  • 2
  • 16
0
votes
1 answer

EntityFramework 6.4.4 Code First "Update-Database -Script" generating incomplete sql Oracle devart driver

The Update-Database -script command generates an incomplete sql. The weird behavior is that the missing output from sql is dumped in the Package Manager console. Example migration: public partial class removePoprireData : DbMigration { …
Infinity
  • 13
  • 2
0
votes
1 answer

Why Devart is not working when trying to create models from database?

I'm using Devart with Oracle database 10g and Entity Framework Core 5 and I'm trying to create the models from database with Scaffold-DbContext: dotnet ef dbcontext scaffold "User Id=proj1;Password=proj1;Data Source=proj.pr.local:1515;"…
littleO
  • 33
  • 6
0
votes
2 answers

Devart/EFCore Permanent failure if First Query attempted while DB server is unavailable

We have several microservices built on top of aspnetcore and entity framework and using the MySQL EntityFramework connector from Devart. I've noticed that if the first query that any of our applications attempts fails due to the data store being…
phillip voyle
  • 1,863
  • 2
  • 15
  • 18
0
votes
0 answers

how to cast devart.Pgsqlarray to c# list

Simple question but I cant do it. I want something like this: List date_range = (List)reader.GetPgSqlArray("date_array"); there is "date_array" data array range List range = new List(); forech(var d in…
Инк Огнито
  • 1
  • 1
0
votes
1 answer

Oracle Views - EF Core 3.1 - Unable to track an instance of type 'Entity' because it does not have a primary key

I try to reload an entity using .NET Framework 4.8 with EF Core 3.1. If I execute the following code: Context.Entry(viewEntity).Reload(); I get the following Error: Unable to track an instance of type 'ViewName' because it does not have a primary…
Florent
  • 355
  • 2
  • 12
0
votes
2 answers

Adding postgresql function in Devart Entity Model

I'm trying to import a postgresql function in an devart entity model, where I want to return a "custom" table, but I just can't get it working I define my function like this: CREATE OR REPLACE FUNCTION "GetJournalEntriesByVoucherId"(bigint) …
Torben Pi Jensen
  • 850
  • 9
  • 27
0
votes
1 answer

cannot query for data in devart dotconnect for sqlite

using (var ctx = new TIS2APPContext()) { var test = ctx.RSTOPs.ToArray(); } I have just downloaded dotconnect for sqlite (trial version) and I have the above code. An exception…
mannok
  • 1,712
  • 1
  • 20
  • 30
1 2 3
…
25 26