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

Delphi 11/UniDac - Why Program has ever increasing Memory consumption?

I have a Delphi 11 application that does basic Extract / Transform / Load. I am using UniDAC from DevArt for the database connections. I am running on Windows server... I am reading from an Oracle DB and writing to a MSSQL database. I have never…
G Bradley MacDonald
  • 105
  • 2
  • 9
2
votes
1 answer

c# getting suitable field from database by languages in linq connect model

I am using dotConnect for MySQL product of Devart. MySQL database structure likes this: I am getting data like this: public int user_id { get; set; } = 2; public string lang { get; set; } = "en"; // Depending on the situation, it may also be…
Johnny Wind
  • 151
  • 8
2
votes
0 answers

DropIndex ommits Schema while generating migration script for Oracle via EntityFramework CodeFirst

I have a problem with generating migration script from existing migration files, via command line, either Script-Migration or dotnet ef migrations script. The migration file contains the following: migrationBuilder.DropIndex( name:…
Piotr Lewandowski
  • 365
  • 3
  • 10
2
votes
1 answer

'Unable to load the specified metadata resource.' when updating from VS 2019 to 2022

When upgrading my C# project from using Visual Studio 2019 to Visual Studio 2022, I get a runtime error of "System.Data.Entity.Core.MetadataException: 'Unable to load the specified metadata resource.'" As far as I can tell, this is from the .csdl,…
Bennett Bishop
  • 31
  • 6
2
votes
1 answer

LINQ left join generates wrong SQL query

I have this LINQ query: from sol in context.SalesOrderLines join mpso in context.MulticlientsoParentChildsoRelations on sol.orderid equals mpso.parentsalesorderid into lmpso from mpso in lmpso.DefaultIfEmpty() join cso in context.SalesOrders on…
Daumantas Drukteinis
  • 45
  • 5
2
votes
2 answers

Delphi Devart SecureBridge POST Request

I am using the trial version of DevArt's SecureBridge product. I am trying to process POST, but somehow I could not print the request data. XML: test1 test2 Delphi: ScHttpWebRequest1.Method := rmPOST; …
Halil Han BADEM
  • 208
  • 1
  • 15
2
votes
1 answer

Problem with SQL Server or SQL query OR both

I have SQL query like this: DECLARE @cdate1 date = '20200401 00:00:00' DECLARE @cdate2 date = '20200630 23:59:59' SELECT DISTINCT ([hf].[id]) FROM ((([hf] JOIN [pw] AS [PP] ON [PP].[identity] = [hf].[id] AND…
Sergey
  • 21
  • 5
2
votes
1 answer

Issue with Devart that connects oracle where max pool size is 300

We are facing the below-mentioned error in one of our applications quite frequently. This is impacting the performance of the application. Can you please guide us in solving this issue? ERROR: System.InvalidOperationException: Timeout expired. The…
tanmoy dey
  • 21
  • 1
2
votes
0 answers

How to stop EF Core DbContext.SaveChanges auto committing transactions?

I'm using EF Core in a netcoreapp3 app. (I'm actually using DevArt's latest libs for Postgres but I don't think that's relevant here). If I begin a transaction (repeatable read in this case): var pg_conn =…
Adam Benson
  • 7,480
  • 4
  • 22
  • 45
2
votes
2 answers

Call Oracle stored procedures using devart dotConnect

I'm new in Entity Framework and trying to call oracle stored procedures, but without success. So Here is my question: How to call oracle stored procedures using devart dotConnect? For example, I have stored procedure: procedure get_problems(res out…
Vano Maisuradze
  • 5,829
  • 6
  • 45
  • 73
2
votes
2 answers

Distributed transaction already begun "ORA 02046 " when I use Link

I have a very big problem for me appears with a few steps when I use devart to connect to Oracle. Select on the following view in Oracle Code: create or replace view Test_View as select "ID","USR" from Test_Table@link_DB; ` Using LINQ CONNECT…
Homam
  • 23,263
  • 32
  • 111
  • 187
2
votes
2 answers

Using Devart or NHibernate

Dear All I have project which manage so much data. sometimes I must show data almost 1 million row. If I have 2 choice to solve it and I want to make it more faster when show data what technologies better I choose between Devart or NHibernate? I`m…
Gianni Rivera
  • 95
  • 2
  • 7
2
votes
1 answer

Coverting a TMyQuery dataset to TClientDataSet in Delphi

I make use of the Mydac components by devart (corelab) to access MySql from Delphi (2006) Very often I need to work with data in a TClientDataSet What is the best way to convert the dataset of a TMyQuery to TClientDataSet Currently I am…
Charles Faiga
  • 11,665
  • 25
  • 102
  • 139
2
votes
1 answer

How to access the search text in a TCRDBGrid component?

Is there a way to access the text entered in a Devart (Core Lab) TCRDBGrid search bar? I tried implementing the OnKeyDown event but the event didn't happen during entry in the search fields, only when the grid itself was selected. There are no other…
WileCau
  • 2,057
  • 1
  • 24
  • 34
2
votes
1 answer

Entity Framework 6 does not recognize mapped function in database model

I have a problem with Entity Developer and model defined function. Ealier I was mapping functions as a stored procedures because Entity Developer has no support for database functions as it goes. I was using solution mentioned in this topic from…
MichalT
  • 91
  • 4
1 2 3
…
25 26