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
2 answers

ASP.NET CORE 2.2 use dotConnect for MySQL as Provider and Entity Framework Extensions: The Provider could not be resolved

Community, I'm setting up the dotConnect for MySql Provider from Devart in combination with Entity Framework Extensions from zzzprojects. Unfortunately the connection is not stable, by using AddDbContextPool. The connection is stable by using…
Nick
  • 1
0
votes
1 answer

'The ADO.NET provider with invariant name 'Devart.Data.Oracle' is either not registered in the machine or application config file

Ok, there already is a similar issue. It is, however not exactly the same and the solution I got was not derived from the other issue's solution. Here's my Web.Config setup:
Ricardo Appleton
  • 679
  • 10
  • 22
0
votes
1 answer

Kill query after command timout

I'm trying to kill query triggered by ADO.NET command on postgresql database, after command timeout: using (var command = new PgSqlCommand("public.timeout_test", connection)) { command.CommandTimeout = 10; command.CommandType =…
geek
  • 596
  • 8
  • 26
0
votes
1 answer

The specified metadata path is not valid after installing app

Using EF 6 and Devart Entity Design and DotConnect for SQLite. I am having issues with the embedded database location when running in debug, release and after installed. It works just fine to copy the database file to bin/Debug or bin/release and…
Eric Snyder
  • 1,816
  • 3
  • 22
  • 46
0
votes
1 answer

provider with invariant name 'Devart.Data.PostgreSql' is either not registered in the machine or application config file, or could not be loaded

I get this error message when using my API with PostGres database. "The ADO.NET provider with invariant name 'Devart.Data.PostgreSql' is either not registered in the machine or application config file, or could not be loaded. See the inner exception…
Bastien Vandamme
  • 17,659
  • 30
  • 118
  • 200
0
votes
1 answer

Entity Framework not cascade deleting

In short EF default is to delete cascade. I have a parent/child relationship I set up using Entity Developer by Devart. It is set to delete cascade. The parent table looks like this: CREATE TABLE `Tools` ( `ToolNumber` TEXT, `ToolID` INTEGER…
Eric Snyder
  • 1,816
  • 3
  • 22
  • 46
0
votes
1 answer

Ef core creates subquery instead of join in Query Filters or TPH

I have the entity configured to always be queried with with property "DELETED"='N'. In EF 6, I could do: modelBuilder.Entity().Map(m => m.Requires("DELETED").HasValue("N")) SELECT `n`.`id`. FROM `OtherEntity` AS `n` LEFT JOIN `MyEntity`…
Shadow
  • 2,089
  • 2
  • 23
  • 45
0
votes
1 answer

'Collection type for payload data type MSG_TYPE does not exist.'

I am dequeueing an Oracle Advanced Queue succesfully through the following code: OracleQueue oracleDequeueQueue = new OracleQueue("QUEUENAME", oracleConnection); OracleQueueMessage msg = oracleDequeueQueue.Dequeue(); if (msg != null &&…
STORM
  • 4,005
  • 11
  • 49
  • 98
0
votes
1 answer

Prevent concurrency violation in MySQL and Devart MySQL Connector

I have inherited support for an application used by a number of charities. The application uses an Access database for local storage and has a web based interface with a MySQL database. The application syncs data to the MySQL database using a Devart…
bendataclear
  • 3,802
  • 3
  • 32
  • 51
0
votes
1 answer

postgresql custom cast to match different case types

Some backgrounds, I am using: Entity framework 6.1 Devart.Data.PostgreSql 7.11.1229 Devart.Data 5.0.2021 Postgresql 9.2 Because of some abstract OO modeling, EntityFramework is forced to perform some unions over different tables, some of which…
gajus
  • 15
  • 4
0
votes
1 answer

How to change NCLOB to NVARCHAR2(150 CHAR) via DevArt using code first?

Googling 2-nd day and figure out that can't find how to convert NCLOB to NVARCHAR2(150 CHAR) using DevArt and Code First approach in .NET & Oracle. Can anybody help me?
BorHunter
  • 893
  • 3
  • 18
  • 44
0
votes
1 answer

Does dotConnect for SQLite support Mono?

Does the dotConnect provider for SQLite from Devart support Mono? Google seems to say it does, but their own compatibility page says it does not. I'm looking to use Code First on Mono with SQLite.
David Pfeffer
  • 38,869
  • 30
  • 127
  • 202
0
votes
0 answers

Cascade deleting one-to-one linked entities in EntityDAC

Using Delphi XE5 and Devart EntityDAC ORM. I have two entities linked one-to-one: Project( Id, Name, ... ) and ProjectSchedule ( Id, ProjectId, ... ); In general schedule's fields may be easily inluded in Project table but I separated it for further…
AvoiDFaTE
  • 97
  • 9
0
votes
3 answers

EF4 Code only ctp5: how set connectionstring devart oracle?

hi i have devart oracle provider 6(BETA), and want use code only ctp5...how i can set connectionstring for oracle?i started now with Code only and i need use oracle, anyone can help me?
Stefhan
  • 610
  • 1
  • 5
  • 17
0
votes
1 answer

Delphi, Master-Detail with DetailFields in the where condition (not in select-part)

I am using master-detail connection to show a list of assigned columns of a detail-table. In addition i want to show a second grid with not assigned detail columns Example Master-Table t_human: idHU, nameHU (like John, Oscar, ...) Detail-Table…
Stephan Kallnik
  • 1
  • 1
  • 1
1 2 3
…
25 26