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
33
votes
15 answers

System.Data.MetadataException: Unable to load the specified metadata resource

My connection strings are as follows:
Meysam Savameri
  • 347
  • 2
  • 4
  • 8
12
votes
3 answers

CLOB vs. VARCHAR2 and are there other alternatives?

I am using DevArt's dotConnect and Entity Developer for my application. I've created the tables using the Entity-First feature. I notice that many of the column types are set to CLOB. I only have experience with MySQL and Microsoft SQL server, so I…
Extrakun
  • 19,057
  • 21
  • 82
  • 129
10
votes
6 answers

Can we control LINQ expression order with Skip(), Take() and OrderBy()

I'm using LINQ to Entities to display paged results. But I'm having issues with the combination of Skip(), Take() and OrderBy() calls. Everything works fine, except that OrderBy() is assigned too late. It's executed after result set has been cut…
Robert Koritnik
  • 103,639
  • 52
  • 277
  • 404
9
votes
5 answers

Set Devart's Code Compare as custom diff & merge tool in Sourcetree?

How to add Devart's Code Compare as custom diff & merge tool within Sourcetree?
Daniel Gartmann
  • 11,678
  • 12
  • 45
  • 60
8
votes
1 answer

Is this lambda? if not what is it?

a few days back i was trying the new ORM for delphi from Devart called EntityDAC, well i was reading the docs specific the LINQ part, when i saw something like: Linq.From(Emp).Where(Emp['Sal'] > 1000) got to say that wake me up the first moment i…
kabstergo
  • 761
  • 4
  • 16
8
votes
2 answers

How to call a Stored Procedure inside an oracle package with Entity Framework?

I have a package in oracle 11g as follow: CREATE OR REPLACE PACKAGE "HRS.PKG_TRAINING_SP" as TYPE T_CURSOR IS REF CURSOR; procedure GETPERSONNELTRAINIGLIST( personnel_Id_in in string, base_date_in in string, is_current_in in…
Amir
  • 714
  • 1
  • 13
  • 37
7
votes
2 answers

TransactionScope does not rollback inside wcf service method, does roll back if called directly

I am facing a problem that drives me crazy for couple of days now, hoping someone can help me. Here it is ; I'm using EF4 with oracle database, using dotConnect for oracle from devart as provider. I have wcf service method which calls DeleteCabinet…
rayback2
  • 81
  • 5
7
votes
1 answer

Linq to Entities and LEFT OUTER JOIN issue with MANY:1 relations

Can somebody tell me, why does Linq to Entities translate many to 1 relationships to left outer join instead of inner join? Because there's referential constraint on DB itself that ensures there's a record in the right table, so inner join should be…
Robert Koritnik
  • 103,639
  • 52
  • 277
  • 404
7
votes
1 answer

Unicode Parameter on Oracle Connectionstring

Why does not Oracle ODP recognize the parameter Unicode=true and Devart's Provider does? WHen I have data containing the string : "ñãõ,éóúý" , my asp.net application shows "???,????" if I'm using Oracle's ODP. WHen I try to put the attribute…
ClayKaboom
  • 1,833
  • 1
  • 22
  • 42
6
votes
1 answer

How to use DataTable (or similar) with Oracle DB

I've recently been dealing with some performance problems and am trying to figure out how to exponentially increase the performance of some calls to an Oracle DB. Technologies: .NET Core 2 Oracle DB Dapper (optional) Devart (optional) OracleManaged…
Kody
  • 905
  • 9
  • 19
6
votes
1 answer

Entity Framework - Why does EF use LEFT OUTER JOIN's in a 1-to-1 relationship?

Why does .NET Entity Framework produce SQL that uses a subquery and left outer join on a simple 1-to-1 relationship? I expected to see a simple join on the two tables. I'm using Devart Dotconnect for Oracle. Any ideas? Below is the output I see…
Taylor Leese
  • 51,004
  • 28
  • 112
  • 141
6
votes
2 answers

Postgresql with postGIS and entity framework, CHECK constraint issue

I have a postgresql database with postGIS and I'm using entity framework with dotconnect 6.7 for postgreSQL. With the following table in my database: CREATE TABLE geo ( the_geom geometry, id integer NOT NULL, CONSTRAINT primary_key PRIMARY…
user1815201
  • 463
  • 3
  • 16
6
votes
1 answer

How can I use LinqPad's generated context in Visual Studio

This is a follow-on from this question really: Moving From LINQpad to a Proper Visual Studio Project? ..but I'm not able to get it to work properly. An answer to that question suggestions dumping the context assembly out as a dll but although I have…
Neil Trodden
  • 4,724
  • 6
  • 35
  • 55
6
votes
3 answers

Concurrent reading and updating in a database table

I have an Oracle database that I access using Devart and Entity Framework. There's a table called IMPORTJOBS with a column STATUS. I also have multiple processes running at the same time. They each read the first row in IMPORTJOBS that has status…
L-Four
  • 13,345
  • 9
  • 65
  • 109
5
votes
1 answer

Poor performance getting clob field from Oracle in .Net

I am trying to read a clob column from oracle in .Net and observing very poor performance and lots of network traffic. I have tried ODP+OCI, devArt+OCI ways to access the data with the same results - it takes around 20 seconds to get 1000 rows in a…
neonknight
  • 121
  • 2
  • 5
1
2 3
…
25 26