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
5
votes
3 answers

Devart.Data.Oracle.EFCore - How to use sequence to set PK column value?

I'm using Entity Framework Core 2.1.4 with Oracle 11 database and Devart.Data.Oracle.EFCore provider. Database first approach. I want to get from sequence value for ID column (primary key) on inserting without setting this explicitly every time. So,…
Felix
  • 164
  • 1
  • 8
5
votes
3 answers

Are there any .NET data providers for Oracle that do not require the Oracle Client to be installed?

I am developing a rich client application that will use the Entity Framework (with DevArt's DotConnect for Oracle) to connect to a central Oracle database. However, I have found that this scenario requires every client machine to have the Oracle…
YeahStu
  • 4,032
  • 5
  • 48
  • 69
5
votes
2 answers

OUTER APPLY is not supported by MySQL

I am using Entity Framework with MySQL. The following query results an error: var foobar = ctx.ArticleBase.OfType().Include("CreatedBy.Image.Location").ToList(); Error: "OUTER APPLY is not supported by MySQL" I also get the "CROSS…
Peter Stegnar
  • 12,615
  • 12
  • 62
  • 80
5
votes
2 answers

DevArt's dotConnect for Oracle vs DataDirect's ADO.NET data provider

Has anybody done a comparative analysis of dotConnect for Oracle from DevArt and the ADO.NET data provider from DataDirect. We are thinking of using the Entity Framework support available in these frameworks for a critical enterprise application.…
Chai
  • 482
  • 5
  • 11
5
votes
4 answers

Delphi support for SQLite manifest typing

SQLite has the interesting "feature" of letting you store anything in any field regardless of its data type. http://www.sqlite.org/different.html#typing I'm having to read some externally created SQLite files that were created by (ab)using this…
LachlanG
  • 4,047
  • 1
  • 23
  • 35
5
votes
2 answers

Should I be worried about Version Conflicts?

I recently updated my devArt dotConnect for Oracle components from version 6.? to 7.2 All seems to work fine. However, on compiling I see I've got the warning: "Found conflicts between different versions of the same dependent assembly." I don't know…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
4
votes
2 answers

Entity Framework 4.3.1 always run all migrations on Update-Database

I have created an initial migration with Add-Migration. When I run Update-Database on an empty DB it creates all tables, including adding an entry in the __MigrationHistory table. Now I run Update-Database again just to test, and instead of "No…
ciscoheat
  • 3,719
  • 1
  • 35
  • 52
4
votes
1 answer

Entity Framework translating number(1) to Boolean help?

Im using Devart dotConnect for Oracle - Entity Framework + .NET 3.5. When i create the Entities, the framework change those colums type number(1) into bool. I read that it is a feature of every kind of entity framework. But i don't want it.. We use…
Jaime Yule
  • 981
  • 1
  • 11
  • 20
4
votes
0 answers

Retrying User Transactions with Database in Entity Framework 6 (Connection Resiliency)

I am attempting to implement retries on my database connections, which I've gotten working, but it's broken the user-initiated transactions I have as well. Specifically, I see errors like the following: The configured execution strategy…
Volt Cruelerz
  • 73
  • 7
4
votes
2 answers

Entity Framework join nullable join columns

My Devart Entity Framework provider takes the following linq to entities. from p in context.BEAT_CONTACT join cl in context.COMPASS_LOCATIONS on p.GAZETEER_KEY equals cl.GAZETTEER_KEY //on new { bcdid = p.GAZETEER_KEY.Value } //equals new { bcdid =…
Dilbert
  • 53
  • 1
  • 8
4
votes
1 answer

Devart MySQL 6.10.96 or MySQL Connector 6.3.6?

Just wondering whether anyone has any views on whether DevArt MySQL is > MySQL Connector ? In the past, when I have used MySQL - the MySQL Connector really sucked for C# ASP.NET development work. Can anyone please provide an opinion on whether its…
Tom
  • 41
  • 2
4
votes
2 answers

EF Core Include method not working

I recently updated to asp.net core 2.0. Since upgrading all my Linq queries using Include Method are failing, it is not translated properly to SQL. For instance this: var entities = helpTopicRepository.Entities.Include(x =>…
capiono
  • 2,875
  • 10
  • 40
  • 76
4
votes
2 answers

Delphi: How to get the query that is passed to the server when parameters are used

I have a query with parameters inside a Devart TMSQuery.SQL. Something like select * from customers where customer = :CustomerID in code I do // Delphi sqlcustomer.ParamByName('CustomerID').asinteger := 4; sqlcustomer.open; I want to debug and see…
UnDiUdin
  • 14,924
  • 39
  • 151
  • 249
4
votes
1 answer

PostgreSQL doesn't save full DateTimeOffset

I have run into what seems like an error with either PostgreSQL or the Devart database connection library. The following is a simple test app I created: using System; using System.Collections.Generic; using System.Linq; using System.Text; using…
GBreen12
  • 1,832
  • 2
  • 20
  • 38
4
votes
2 answers

Using VCL for the web (intraweb) as a trick for adding web interface to a legacy non-tiered (2 tiers) Delphi win32 application does make sense?

My team is maintaining a huge Client Server win32 Delphi application. It is a client/server application (Thick client) that uses DevArt (SDAC) components to connect to SQL Server. The business logic is often "trapped" in Component's event handlers,…
UnDiUdin
  • 14,924
  • 39
  • 151
  • 249
1
2
3
…
25 26