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

Why individual delete calls with delete on cascade?

I've got two tables with an 1:n relation (one animal has many animal_events) and a delete on cascade in my database: CREATE TABLE animals ( Id INTEGER PRIMARY KEY AUTO_INCREMENT, Description VARCHAR(512), Timestamp …
nabulke
  • 11,025
  • 13
  • 65
  • 114
2
votes
0 answers

Why is the performance of dotConnect Universal so bad for both Oracle and PostgreSQL?

I have been doing some tests and comparing the performance of Devart's dotConnect Universal to ODP.Net & Npgsql when accesing an Oracle & PostgreSQL database respectively and its pretty disapointing. In both cases, dotConnect Universal is a lot…
VinceJS
  • 1,254
  • 3
  • 18
  • 38
2
votes
0 answers

C# select query being converted to Oracle SQL with unexpected unicode character causing "ORA-12704: character set mismatch" exception

I am using Oracle 11g Devart 8.5.592 EntityFramework 6.1.3 The following C# code: var testResults = _clientRepository.AsQueryable() .Select(c => "First" + (!string.IsNullOrEmpty("Second") ? ", " : "") + "Third") …
aleonj
  • 163
  • 2
  • 7
2
votes
1 answer

Multiple EF6 DbContext for one DbConfiguration in ASP.NET 5

I'm trying to port my MVC 5 application to MVC 6. I'm using Devart dotConnect for MySql and Oracle. I have trouble configuring my application. Right now I have the following entries:
Shadow
  • 2,089
  • 2
  • 23
  • 45
2
votes
0 answers

Oracle float values not exact on insert

A string value 58.83 is changed to 56,829999999999998 when inserted into a Oracle database FLOAT(126) column. We are using: .NET Entity Framework 6, Devart dotConnect for Oracle Professional version 8.4.171.0 and Oracle 11g Enterprise Edition…
Deakus
  • 51
  • 4
2
votes
1 answer

Any way to edit redshift tables in Excel?

I've been looking for a way to be able to edit AWS Redshift tables in Excel. I know with ODBC I can connect to a table and work with a readonly version. But does anybody know of a solution to write back? I found 2 addins that write back to Postgres…
Nicholas
  • 1,412
  • 1
  • 13
  • 17
2
votes
1 answer

Entity Framework: Server did not respond within the specified time out interval

I am trying to access remote Oracle database using vpn connection. Using Oracle Sql Developer tool I am able to connect the database. But when I use ADO.NET model and Devart dotconnect for Oracle, it gives me error that server did not respond with…
ThomasBecker
  • 388
  • 6
  • 20
2
votes
1 answer

Insert Into Statement causes ORA-01756: quoted string not properly terminated

Environment: DevArt Drivers for Oracle .NET 4.5 I'm trying to execute the following statement: INSERT INTO T_CUSTOMERS_T ("ID", "NAME1", "NAME2", "NAME", "STREET", "POSTAL", "CITY", "COUNTRY", "TEL",…
SeeSharp
  • 21
  • 3
2
votes
1 answer

Oracle UDT with EntityFramework Support

is there any support for oracle user defined data types with Entityframework 5 or 6 (devart dotConnect or ODP.Net) ?
Mohamad Alhamoud
  • 4,881
  • 9
  • 33
  • 44
2
votes
1 answer

How to Install DBMonitor

This is probably a really simple question, but here it is. I just renewed my license for the DevArt DBExpress driver for Firebird. The help file says I can use their freeware DBMonitor application with it but since I am using D2006, I have to use…
jrodenhi
  • 2,237
  • 1
  • 21
  • 31
2
votes
2 answers

error on run execute file : dbrtl70.bpl missing

I made an application with ADO Component and connect to Oracle with it, I don't have any problem when I run it in another machine. But, when I use ODAC component and TOraSession and connect with it via Direct Connect and run it in another machine I…
Hossein Vatani
  • 1,381
  • 14
  • 26
2
votes
1 answer

Use EDMX designer with PostgreSQL

Is there a way to use my existing EDMX and connect to PostgreSQL ? Also can I convert MSSql edmx to work with postges, coverting edmx to edmi is also an option? Thanks
khorvat
  • 1,630
  • 2
  • 20
  • 31
2
votes
2 answers

Greek charset is causing problems when retriving data though ADO from PostgreSQL

I am having a problem with the charset and the colleration of PostgreSQL. When I setup a new database I can choose between C, Greek_Greece.1253 and POSIX for Collation and Character Type. I choose UTF8 for encoding, Greek_Greece.1253 for…
Menelaos Vergis
  • 3,715
  • 5
  • 30
  • 46
2
votes
1 answer

How to have more than 1 many-to-many relationship

My problem is simple but I can't seem to get EF to understand my database schema (Oracle). Problem I want to model more than 1 M-M relationship see diagram below: As you can see I have a book and a journal - and I want to store a URI against both…
Vidar
  • 6,548
  • 22
  • 66
  • 96
2
votes
1 answer

DevArt Entity Framework deployment using MSDeploy

Scenario first :- I'm using Entity Framework to do some queries, to build my Models I'm trying DevArt Entity Developer inside a MVC3 project. I build the app upload to SVN and then a Continuous Integration server picks it up (Bamboo) builds and…
John Mitchell
  • 9,653
  • 9
  • 57
  • 91
1 2 3
…
25 26