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

I cannot use Devart with Entity Framework Core on SQL Server

I found that most of the dotConnect versions (Oracle, PostgreSQL, MySQL) are compatible with EFCore. However, seems that it does not work with SQL Server. Is there something I missed? I have been using Devart with EF Core on other project for a…
mannok
  • 1,712
  • 1
  • 20
  • 30
0
votes
1 answer

Switching Debug configuration to Release turns off Devart.Data.PostgreSql namespace

When I build Debug configuration, Devart.Data.PostgreSql is visible to my c# code. When I switch configuration to Release, it is "could not be found". The nuget package 7.7.832 (tried to upgrade to the latest 7.20, no dice) is still showing as…
Rixa Civad
  • 21
  • 2
0
votes
1 answer

how to generate the Repository and model/entity classes with all CRUD operations using database-first apporach in C#

I have a database for which I want to generate the repository and entity/model classes with all CRUD operations. To achieve this I found a tool, named Entity Developer (https://www.devart.com/entitydeveloper/download.html), which is generating all…
Das Khatri
  • 93
  • 6
0
votes
1 answer

Entity Framework, Oracle, DevArt, Context#ExecuteStoreQuery: System.Int32 constructed as System.Double?

I have an Entity-class having a Property of type Int32: on generating DDL using DevArt for ORACLE a NUMBER(10) column is generated. Reading and writing instances works flawlessly. However, on fetching instances of this Entity-class sending a custom…
Bart Strubbe
  • 107
  • 1
  • 7
0
votes
1 answer

Cannot SaveChanges in .NET 5 EF Core with Devart.Data.Oracle.EFCore

I'm currently working on an ASP .NET 5.0 application - I migrate the app from .NET3.1 to .NET 5.0. I use Entity Framework Core with Devart.Data.Oracle.EFCore to connect to an Oracle Database. I try to save a simple record with a string value, when I…
azzurro123
  • 521
  • 2
  • 10
  • 19
0
votes
1 answer

Set ID property explicitly

I have been using Sql Server with EF Core and I was able to do something like this ctx.Database.ExecuteSqlRaw("SET IDENTITY_INSERT Persons ON"); to explicitly set entity id during insert. I was using it for my tests. Now I am working with Oracle…
Aleksa
  • 2,976
  • 4
  • 30
  • 49
0
votes
1 answer

Delphi Devart dbExpress driver for Oracle Cloud Direct Mode "ORA-03113:end-of-file on communication channel"

We are currently using Delphi 13.3 and DevArt dbexpress for Oracle 7.2.1. We are looking to change our Oracle client server database to the the cloud. We looking into to moving to an Oracle Cloud Autonomous Database via Direct Connect...ie…
L. Piotrowski
  • 1,533
  • 1
  • 20
  • 35
0
votes
1 answer

.NET Core 3.1, Devart for Oracle, First Call to Database is very slow

Hy everybody, i need Help for the following Problem: I have a Single-Page-Application (REACT, Webpack) with .NET Core 3.1, Devart for Oracle 9.11.980. The first call to the Database is very slow (20 Seconds). I tested different Calls from my…
Roman
  • 11
  • 3
0
votes
1 answer

RestService with devart dotConnect for Oracle loses License information

We have a Rest Service (Asp.net MVC .net 4.7.1 / Asp.net Core) using Devart dotConnect for Oracle (Version 9.6.646.0.). Here occurs a strange phenomenon: After some time running fine (this may be after half an hour until some hours) the Services…
Rahel Braun
  • 1
  • 2
0
votes
1 answer

Trying to create a Quickbooks Online Journal Entry using Devart dotConnect for Quickbooks

I'm using a dotConnect for Quickbooks utility from Devart to create some General Journal Entries in Quickbooks Online using C# and Entity Framework. (dotConnect for Quickbooks is version 1.10 and Entity Framework is version 6) I found an article on…
BrandonRaney
  • 1
  • 1
0
votes
1 answer

LINQ-To-SQL : Efficient way to implement RANK()

I'm trying to port the following piece of SQL to LINQ and I'm able to achieve what I need. But I believe there should be a better way to do it as the SQL generated as a CROSS JOIN, which is not performant. SQL to port: SELECT bu_code, …
user2697452
  • 352
  • 1
  • 5
  • 14
0
votes
1 answer

EF core with Devart provider, Cursor sharing problem

We are live about 2 years with our WEB APIs and suddenly some high load made our one API work very slow and DBA says that it's because of Cursor sharing problem which itself is because of NLS parameters are changing. API just uses EF Core 2.1 with…
Dadroid
  • 1,444
  • 15
  • 16
0
votes
1 answer

How to disable caching in devart dotConnect for Orcale - .netCore 3.1

I have a licensed Devart dotConnect for Oracle. I'm struggling to get new data from my Entities because they are always returning cached data! And i can't find any way anywhere how to disable caching completely. Question is: How to completely…
Roshdy
  • 1,703
  • 3
  • 25
  • 34
0
votes
2 answers

'licensekey' is an invalid connection string attribute - OracleConnection

I'm using Dapper and getting this error while trying to connect to Oracle Database return new OracleConnection(_configuration.GetConnectionString("CONNECTIONNAME")); My ConnectionString looks like this: "ConnectionStrings": { …
Irina Ebanoidze
  • 1
0
votes
3 answers

EF - Mapping foreign key between DevArt EntityDeveloper & Syncfusion WinForm grid

I need some help to understand the best way to represent datas from SQL DB to SyncFusion grid control. The Animal table contains foreign keys for eye color, coat color... I can add the ObjectSet from ObjectContext generated by DevArt as DataSource…
Nolmë Informatique
  • 612
  • 6
  • 13
1 2 3
…
25 26