388 questions
0
votes
1
answer
44
views
Is it possible to support multiple Devart versions on a single GitLab Runner at the same time?
I'm looking to set up GitLab runners with the two different versions of Devart dotConnect at the same time. Most of our company projects have been updated to version 8.1.151.0, but some older projects ...
- 23
0
votes
1
answer
111
views
MyDAC fetches data despite FetchAll := False
I would like my dataset to not fetch the data as soon as it is opened. I set FetchAll := False but I can see in the MySQL server logs that it still does a SELECT *. How can I actually stop it from ...
- 383
0
votes
1
answer
113
views
DevArt postgres in AzureDevops
I'm working on a local build application that requires DevArt dotnet Connect for Postgres. I'm trying to set up the build pipeline in Azure DevOps, but I can't find the extension for Postgres in the ...
-1
votes
1
answer
168
views
T-SQL code for restoring a database doesn't work inside a Delphi query, but it works in SSMS
I am trying to restore a database which I use in a Delphi program.
When I try to do the restore, it doesn't show any errors and the T-SQL code passes, but there is no change in the database that I am ...
- 506
0
votes
1
answer
414
views
Masstransit EntityFramework Saga management
I have been trying to use the Devart Postgres EFCore library as this is used at the company I work at. The NpgSql lib works fine with Mass Transit from what I can tell.
However I almost immediately ...
- 2,011
0
votes
1
answer
1k
views
Byte array for GUID must be exactly 16 bytes long - Devart - Oracle
I'm having a problem when I insert a Guid value in an Oracle database (raw(16) field). I'm using the Devart library in my C# application to record records. The error occurs randomly because I use Guid....
1
vote
2
answers
151
views
EFCore 7 and Devart.Data.MySql.EFcore 9.1.134.7 Weird Query Syntax Errors
Having a very difficult time determining the root cause of this bug, not sure if its a devart connector issue or what.
I have two queries that are simply generating a list of data and outputting in a ...
- 2,457
2
votes
1
answer
92
views
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&...
- 145
0
votes
1
answer
169
views
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 ...
0
votes
2
answers
224
views
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 == ...
- 2,223
0
votes
0
answers
104
views
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 ...
- 1
1
vote
1
answer
361
views
Devart.Data.MySQL Entity Provider
I'm having an issue getting Devart.Data.MySQL set up as an Entity Provider.
What I have reached so far is this App.config: https://paste.mozilla.org/Q81ctALe
But all that does is throw this exception:
...
- 63
-1
votes
1
answer
218
views
Concurrency issue with EF 6 and Identity
I'm trying to create a MVC5 webapp, Asp.Net.Identity.Core (2.2.3), using DevArt MySQL drivers along with DevArt MySql Identity (8.21.2066.0) and EF 6
I'm having a concurrency issue when trying to add ...
- 43
0
votes
1
answer
107
views
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) {...
- 588
1
vote
1
answer
144
views
Migrating data in an database created with EF code first (devart connector) to EFCore code first (sqlite)
The EFCore documentation is very specific on what to do, to migrated an EF based codebase to EFCore https://learn.microsoft.com/en-us/ef/efcore-and-ef6/porting/ . However, I could not find advice on ...
- 11
0
votes
0
answers
128
views
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'...
- 353
0
votes
2
answers
489
views
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 ...
- 15.5k
3
votes
1
answer
495
views
'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 ...
3
votes
0
answers
1k
views
Unknown column in field list error using Complex types in EF Core 3
For context, I'm in the process of migrating our EF6 Db Context to EF Core 3. Why EF Core 3 only? Currently we're not able to upgrade to the latest EF Core version because of project constraints. We'...
- 75
0
votes
0
answers
665
views
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 ...
- 1,176
1
vote
1
answer
142
views
Devart DotConnect got unexpected long decimal point for me while using entity framework 6 against Oracle
I have a record which contain a number in certain field: 25.99. Whenever I select this record using Devart DotConnect from my C# code it returns me 25.990000000000002. Therefore, my update statement ...
- 1,868
2
votes
1
answer
173
views
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....
0
votes
1
answer
301
views
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 ...
- 11
2
votes
1
answer
1k
views
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;...
- 43
0
votes
0
answers
88
views
how to cast devart.Pgsqlarray to c# list<DateTime>
Simple question but I cant do it. I want something like this:
List<DateTime> date_range = (List<DateTime>)reader.GetPgSqlArray("date_array");
there is "date_array" ...
