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

Is Raise error is not working in Unidac Components with Sybase 12.5 Client Libraries

We are using Unidac Stored Proc Component in Delphi 10 with Sybase 12.5 drivers In Sybase proc we are raising error like below,i found it is retruning back but it not showing error message.Isthis not working in Unidac or any other issue? if @number…
SSE
  • 445
  • 2
  • 10
  • 29
1
vote
1 answer

Devart "Error on executing DbCommand."

Hi i've this kind of exception using Devart. I'm calling a store procedure in MySql. The Store procedure function if i call it by DB. using (dc = conn.GetContext()) { result = dc.StoreProcedure(pId).FirstOrDefault(); } return…
Luigi Saggese
  • 5,299
  • 3
  • 43
  • 94
1
vote
1 answer

Devart: System.TypeLoadException: Method not implemented in Type

I currently have the problem, that a legacy-software is running fine on my local machine, but when I deploy a new version, the application crashes for the customer. The application uses devart to connect to the used oracle-database. I have replaced…
mamen
  • 1,202
  • 6
  • 26
1
vote
1 answer

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 prompt me such exception: Store update, insert, or…
mannok
  • 1,712
  • 1
  • 20
  • 30
1
vote
0 answers

See prepared TMyQuery SQL string

I just want to preface this by saying I do not think it's possible, but I want to ask just to verify. Much like with PDO, we use the TMyQuery's 'params' property to prepare SQL statements prior to execution. Is it possible to see the 'final' SQL…
ConBran
  • 369
  • 2
  • 15
1
vote
1 answer

Register a DevArt LinqConnect model in a Blazor /.NET Core application

I can find 1000's of example of how to register an EF model in a Blazor .NET Core application but almost nothing for any other provider. I am using DevArt LinqConnect Model as my ORM but cannot find how to register it with the dependency injection…
Gary O. Stenstrom
  • 2,284
  • 9
  • 38
  • 59
1
vote
1 answer

Data Types problem while ingesting from Salesforce to Azure SQL using pyodbc in Python

I'm ingesting data from Salesforce to Azure SQL Database using Python with pyodbc. I make a first connexion with Salesforce as shown bellow: cnxn = pyodbc.connect('DRIVER={Devart ODBC Driver for Salesforce};User ID=xxx;Password=xxx;Security…
DSEB
  • 67
  • 1
  • 7
1
vote
1 answer

JIRA query using Delphi XE7 + SecureBridge

I try to retrieve some information from our JIRA (cloud) using TScHttpWebRequest component. The RequestUri is set to "https://takarekinfo.atlassian.net/rest/agile/1.0/issue/KE-7347?fields=customfield_10274". Filled the component Credentils…
tcxbalage
  • 696
  • 1
  • 10
  • 30
1
vote
1 answer

Devart T4 Editor Supporting Additional Extensions

Does anyone know if it is possible to associate the Devart T4 Editor for Visual Studio add-in to additional file extensions. I am currently creating some custom MVCScaffolding T4 templates and their file extension is .t4 However, it looks like the…
Paige Cook
  • 22,415
  • 3
  • 57
  • 68
1
vote
2 answers

How can I use custom expressions in DevArt LINQ to Entities and also use query comprehension syntax?

I've got a situation where I need to use a custom expression in a LINQ to Entities query (because I want to have custom logic that L2E wouldn't otherwise understand: var query = db.MyTable.Where(MyPredicateExpression) But I'd rather use query…
Joshua Frank
  • 13,120
  • 11
  • 46
  • 95
1
vote
1 answer

How can you retrieve the value of sys_guid() after an OracleCommand INSERT INTO

I want to retrieve the value of a certain column that contain an Oracle db generated sys_guid() within a transaction. public string GetGUID(OracleConnection connection) { string guid = ""; connection.Open(); OracleCommand cmd = new…
Adonis Pso
  • 25
  • 7
1
vote
2 answers

EFCore 3.0 Devart Provider With OracleDB doen't work raw sql

My project run on .net core 3.1, I use data provider Devart.Oracle also my project data stores on OracleDB 11g My problem when i try to get sequence with EFCore V3.0 like that; using (TransactionScope scope = new TransactionScope()) { …
errorau
  • 2,121
  • 1
  • 14
  • 38
1
vote
3 answers

Is there an advantage to use bound variables running Oracle single record update/insert?

I am being pestered by Oracle admin telling that Oracle can optimize better requests if I use bound variables instead of inline. The code is C# and using Devart Oracle provider, Oracle12c+. I understand that it can have an impact if you run a select…
Boppity Bop
  • 9,613
  • 13
  • 72
  • 151
1
vote
2 answers

Entity Framework, devArt, and Oracle VarChar params

Hello: I am using devArt's Oracle Connect to work with Entity Framework 4.1 POCO's and Oracle. I have a problem with certain queries where the Oracle column type is Char (fixed-length). The parameter that is used in the generated SQL query is…
JMarsch
  • 21,484
  • 15
  • 77
  • 125
1
vote
1 answer

EF configuration in Azure (v1) function

ProjectA includes EF code, and is normally hosted in MVC project. Now I'd like to "wrap" it in a Azure (v1) function (lets call ProjF), in order to expose on a consumptionplan (so we can scale the heavy calls). So I ref ProjA, fine. But how to get…
Toke Breer-Mortensen
  • 277
  • 2
  • 12
1 2 3
…
25 26