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

Database returns null after successful connection with Devart in C#

I am trying to connect C# to an InterBase Database. I have downloaded and install Devart ODBC Driver for Windows and installed it. I configured the System DSN in control panel and got a Success message when I tested the connection. I generated a…
tck
  • 61
  • 5
1
vote
0 answers

Type used in a using statement must be explicitly convertible to 'System.IDisposable'

Using Entity Framework and Devart Entity Developer on an existing database. I brought the table needed into the Entity Designer model using the wizard. Saved the model - that creates the underlying code for EF. Now when I try to use: using (Document…
Eric Snyder
  • 1,816
  • 3
  • 22
  • 46
1
vote
0 answers

IQueryable returns inconsistent results

I have a relatively simple query which returns inconsistent results. Having a collection of id's (approx 3300), I want to query for the objects which have a child with that id. The relationship between my types is 1 to n. I do this in batches of…
1
vote
1 answer

Clear connection pooling in devart?

I have a Windows service application that connects to database every minutes. Somethimes i get this error: ORA-20110: ORA-06508: PL/SQL: could not find program unit being called Solution is close and reconnect database in plsql but i want to do…
Mennan
  • 4,451
  • 13
  • 54
  • 86
1
vote
3 answers

Have a problem with EF 4.0 and ObjectStateManager (i think)

I have a serious problem, i have an unique key on field in db, I use Oracle(Devart Provider). First time i preform an Insert -> (_objectSet.Add(entity)) via my repository it's ok, BTW: I use Code Only model and CTP5. Then if i want to insert it…
hackp0int
  • 4,052
  • 8
  • 59
  • 95
1
vote
1 answer

devart ssis mysql data flow

I have a data flow from excel to mysql database, and the destination table keeps giving the same error. I have reinstalled visual studio and ssis devart components still I get the same error even if I create a new project in visual studio. I even…
1
vote
2 answers

Transaction already exists error

I'm using EF Core and Devart's data provider library. I've hit an issue I can't figure out with handling user input errors smoothly. The error seems to be limited to adding a new entity to the context. Scenario User inputs an invalid value in a…
Felix Castor
  • 1,598
  • 1
  • 18
  • 39
1
vote
2 answers

Devart T4 Editor 1.0.9 fails to install for VS 2017 Pro

I've successfully installed this on another machine. Do you see what I need to do on my machine to get this installed? Here's the install log: 5/24/2018 9:55:57 AM - Microsoft VSIX Installer 5/24/2018 9:55:57 AM -…
Michael Mainer
  • 3,387
  • 1
  • 13
  • 32
1
vote
1 answer

Linq to Entities control table name resolution at runtime

I've implemented a content management system that deals with a certain kind of object, and now the client has introduced another kind of object, whose structure and behavior is exactly the same, but separate. They want to be able to switch modes,…
Joshua Frank
  • 13,120
  • 11
  • 46
  • 95
1
vote
1 answer

license not found issue devart postgres sql

i have developed an app using the devart dot connect control. I have deployed on the server, using iis. However, whenever i try to do anything with the database i get the license not found error. I have copied the license file into the bin and root…
Daniel Casserly
  • 3,552
  • 2
  • 29
  • 60
1
vote
2 answers

EF4 Oracle Identity Insert

Does anyone know if its possible to call an oracle's sequence.NextVal from ef4 without using StoredProcedure? I have an Oracle db from a client which I cannot modify, so stroedproc are not an option for me. I use ef4 ctp5. Thank!
1
vote
1 answer

Problem with Timestamp using .Net entity framework and Devart dotConnect for MySQL

I have the following table in my MySQL database : CREATE TABLE IF NOT EXISTS Benutzer ( Id INTEGER PRIMARY KEY AUTO_INCREMENT, Login VARCHAR(20) NOT NULL, Nachname VARCHAR(50) NOT NULL, Vorname …
shepard1
  • 55
  • 2
  • 7
1
vote
1 answer

Writing larg BLOB throws InvalidOperationException

I am having trouble writing large blobs to a MySQL-Database using the .net entity-framework. Blobs < 1MB work fine. If I try to write a blob > 1MB a InvalidOperationException with text "Connection must be opened." occurs. I am using: Visual Studio…
shepard1
  • 55
  • 2
  • 7
1
vote
1 answer

Can't Install DotConnect for PostgreSQL

I have "Incompatible version found" error with Details: "Devart.Data assembly version 5.0.1375.0 is found in Global Assembly Cache." When I'm running DotConnect for PostgreSQL v 7.4.521.0 Installation. But I have no any "Devart","DotConnect" etc…
Cloudswalker
  • 55
  • 10
1
vote
0 answers

How to connect to SQL Server using Windows authentication impersonating another user?

To express myself better i start by example. In my client server application there is a users table. Each user is mapped to a sql server user. The database is full of tables, anyway each user can query just 1 table. The table contains the following…
UnDiUdin
  • 14,924
  • 39
  • 151
  • 249