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
1 answer

How to get MySQL time fraction with Devart dotConnect Express MySQL?

Assume that I have a table like this: CREATE TABLE `table1` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `date` date, `timestamp2` timestamp(2), `datetime3` datetime(3), `time6` time(6), PRIMARY KEY (`id`) ); Here's the sample…
mjb
  • 7,649
  • 8
  • 44
  • 60
0
votes
1 answer

Devart Error when I return database object with IActionResult

I am trying to return the database object that I get from my service in an IActionResult API Call (c# web API project). Whenever I attempt to do that I get this error: System.Text.Json.JsonException: A possible object cycle was detected. This can…
austin_wilcox21
  • 47
  • 7
0
votes
1 answer

Bulk insert using dotConnectForPostgreSQL

Do we have any bulk copy or bulk insert mechanism into PostgreSQl by using dotConnectForPostgreSQL provider from C#? I am trying to insert the data(multiple sheets with lakhs of records) from xlsx to PostgreSQl by using c#. But didn't find any…
Goli Someshwar
  • 3
  • 3
0
votes
1 answer

Special characters insertion into PostgreSQL with dotConnectForPostgreSQL provider

As part of requirement, we have to insert special characters data into PostgreSQL table by using c# queries(ORM). Getting the error while committing the trasnaction. "invalid byte sequence for encoding "UTF8": 0xc3 0x5f" Special characters:…
Goli Someshwar
  • 3
  • 3
0
votes
2 answers

LINQ avoid OUTER APPLY Oracle 11g

When running the LINQ Query below against Oracle 11g instance, it will throw an OUTER APPLY not supported error. var shipmentDetails = ( from r in _db.XXF_SHIPMENT_DETAILs where r.SHIP_TO == tradingPartnerId && r.PICKUP_DATE >= pickUpDate …
Geovani Martinez
  • 2,053
  • 2
  • 27
  • 32
0
votes
0 answers

ASP.NET Core, Devart, Windows Service

Hy everbody, I created a ASP.NET Core Web App which i run as a Windows Service. That is working fine until i started to use Devart as DB-Provider for my Oracle-Database. As soon as is include the Nuget-Package Devart.Data.Oracle.EFCore in my Project…
Roman
  • 11
  • 3
0
votes
0 answers

Entity Framework 6 code first DbContext issue with multiple DbContext ( .NET 6 )

I am getting below error System.InvalidOperationException : The default DbConfiguration instance was used by the Entity Framework before the 'DbConfig' type was discovered. An instance of 'DbConfig' must be set at application start before using any…
yogesh kumar Firke
  • 11
  • 2
0
votes
0 answers

How Can I know when TScSSHShell > ScSSHShellAsyncReceive has finish recieving data from remote device?

I use the Devart SecureBridge components Pack to connect to firewall (cisco, srx...) using SSH. I use the TScSSHShell.WriteString to execute commands and then monitor the result on the OnAsyncReceive event and I need to know when the event has…
David
  • 1
  • 1
0
votes
1 answer

Devart Oracle Entity Framework 4.1 performance

I want to know why Code fragment 1 is faster than Code 2 using POCO's with Devart DotConnect for Oracle. I tried it over 100000 records and Code 1 is way faster than 2. Why? I thought "SaveChanges" would clear the buffer making it faster as there…
Jonna
  • 1,625
  • 1
  • 18
  • 38
0
votes
1 answer

How to configure the Devart LinqConnect Database Context with Dependency Injection

I have a Library project that I store all business logic for a Backend API service. Included in that library is the Database Context provided by Devart. How can I setup a Transient Service in my Startup.cs that will allow me to specify the…
austin_wilcox21
  • 47
  • 7
0
votes
2 answers

Enyim Serialization Error Linq

I'm using Devart to execute DB object and Store Procedure mapping. Now i want to store in cache (using Enyim by MemCached) a Store Procedure object result. When i'm trying to do that i have this kind of error (in short: type Devart.Data.Linq.a in…
Luigi Saggese
  • 5,299
  • 3
  • 43
  • 94
0
votes
1 answer

How to get the operation type in devart MysqlDependency

I know I can get the table name that recently changed using Devart MysqlDependency by using the following code. void dependency_OnChange(object sender, Devart.Data.MySql.MySqlTableChangeEventArgs e) { string tableName=e.TableName; } But I want…
Hamreen Ahmad
  • 522
  • 5
  • 21
0
votes
1 answer

Web app suffers slow performance after upgrading to Oracle 19c

I have a c# MVC web application (.NET 4.52) using an older version of Devart LinqConnect to scaffold the database etc. The app has been around for 10 years with an Oracle 11g backend database without issue. Our DBA team exported the schema/database…
Sulphy
  • 766
  • 2
  • 9
  • 29
0
votes
0 answers

How to or where is the reference of the db parameter to its database context column on a DB interceptor method?

The purpose is to intercept queries to and from the database where if a certain column is detected it would encrypt/decrypt the value, for example an SSN column. We're using EF6 with Devart MySQL. I've been able to use the method "ReaderExecuting"…
johnsabre
  • 355
  • 2
  • 7
0
votes
2 answers

How to find the source of a big memory consumption in a Delphi application?

I am experiencing a non normal memory consumption from my application written in Delphi 10 Seattle. It is a client server fat client type of application using SDAC's Devart as DB component. I am not aware of specific tools, but I would like to know…
UnDiUdin
  • 14,924
  • 39
  • 151
  • 249
1 2 3
…
25 26