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

Will EF precompiled views work with Oracle and Devart?

We found an interesting article about improving performance of Entity Framework by using "precompiled views": http://neverindoubtnet.blogspot.ch/2012/03/squash-entity-framework-startup-time.html We have tried this - we use the EF Power Tools…
chiccodoro
  • 14,407
  • 19
  • 87
  • 130
0
votes
1 answer

What Provider DLL does the EntityConnection use to create its StoreConnection

I setup an object context like this: public MyObjectContext(....) : this(contextName, new EntityConnection(connectionString)) The connection string is a connection string to an Oracle database. I use DevArt as a provider btw. Everything works fine.…
patrickuhlmlann
  • 342
  • 2
  • 4
  • 14
0
votes
1 answer

DBForge hangs server with thousand of records

First, I have a table with 1500 records I'm using MySQL 5.0.54. I'm using dbForge for MySQL 5.0.97 The table: CREATE TABLE IF NOT EXISTS s_users( user_id MEDIUMINT(9) NOT NULL, employee_id INT(11) NOT NULL, surname VARCHAR(50) NOT NULL, …
TechFanDan
  • 3,329
  • 6
  • 46
  • 89
0
votes
0 answers

Preventing Deadlock in Multi User Environment

The current situation: We develop a program to manage multiple e-Commerce Shops. Editing an order is a task that includes many tables and therefore it's neccessary to use transactions. If the last query fails, all the previous changes must be…
SvenFinke
  • 1,254
  • 3
  • 15
  • 30
0
votes
1 answer

Batch Move Data from TADOTable to MySQL TMyTable

I am trying to import a table from an old database (MS Access) to MySQL server using CRBatchMove using Delphi 2007. The program fetches data from the legacy database over an ODBC connection and stores it on the local hard drive using…
ssh
  • 943
  • 1
  • 14
  • 23
0
votes
1 answer

PostgreSQL Connection random errors

I'm running a set of tests using NUnit. Each test does connect to PostgreSQL database and does something there. Sometimes I'm getting NullReferenceException with this stack trace: at Devart.Data.PostgreSql.o.a(Byte[] A_0, Int32 A_1, Int32 A_2,…
kubal5003
  • 7,186
  • 8
  • 52
  • 90
0
votes
0 answers

How to kill running sql query in c#, using Devart?

I want to create my own sql tool and I have a little problem with terminating running queries. This tool will be executing every kind of sql query: select, insert, update etc... I'm using Devart with c#, winforms application. Here is my code: …
Marshall
  • 1,195
  • 6
  • 30
  • 47
0
votes
1 answer

conn.open() oracleException was unhandled

I'm developing a Windows CE app in C# and trying to connect to an Oracle database. I'm using CoreLab.Oracle reference. This is my code: using CoreLab.Oracle; namespace SmartDeviceProject1 { public partial class Form1 : Form { …
Werner van den Heever
  • 745
  • 6
  • 17
  • 40
0
votes
1 answer

DevArt dotConnect for Oracle with strange behavior on strings with EF 4.0

After I updated my project to Version 7.2.114 of DevArt I recognized that some queries will not return results although the generated SQL is returning results if executed directly in TOAD. If I switch back to Version 7.0.25 everything works fine. My…
Alexander Schmidt
  • 5,631
  • 4
  • 39
  • 79
0
votes
1 answer

Getting currently selected row in a devArt dotConnect DbDataTable (possibly DataTable)

I'm writing a control that will simplify some of the editing process in a dotConnect DbDataTable component. Part of the editing process is being able to call BeginEdit() and EndEdit() on the current row. Many articles make it clear that the current…
Jordy Boom
  • 620
  • 5
  • 18
0
votes
1 answer

Can't generate EF model correctly with Devart dotConnect for PostgreSQL product

I have problem when creating Entity Framework model from an existing PostgreSQL database with the Devart dotConnect for PostgreSQL product. This product offer 2 ways of generating EF model from a database and neither seems to work. When using an…
Etienne Desgagné
  • 3,102
  • 1
  • 29
  • 36
0
votes
0 answers

Devart entity developer with wrong provider?

We are using the devart dotconnect, entity developer and the developer tools for visual studio 2010. Last week I've got a new mashine and an upgrade from windows xp to windows 7. Before this upgrade, everything worked fine. But now, after I choose…
csteinmueller
  • 2,427
  • 1
  • 21
  • 32
0
votes
1 answer

Devart DotConnect for SQLite 4.2.77 upgrade difficulty with VB existing projects

I have just upgraded to DotConnect for SQLite 4.2.77 from a previous version (sorry, can't remember the version). In VB Express 2010, I have successfully gone through the manual installation of components as described in Help. However, when I open…
user1672999
  • 1
0
votes
2 answers

Persistence in wf4 WorkflowApplication: SQL Server vs ORACLE DevArt

We have a 24x7 application that deals with dozens of WF4 instances. We successfully implemented a persist & recovery strategy using SQL Instance Store persisting OnIdle, waiting for that status in the controlled shutdown and loading back in the…
The Beat
  • 150
  • 9
0
votes
2 answers

Represent View Without Key in Entity Framework

I'm using a model produced with Devart Entity Developer (.edml file, which I understand is mostly similar to .edmx) to generate Entity classes whose relations are initialized in a DbContext class. The database schema specifies no PK for View1, and…
ossek
  • 1,648
  • 17
  • 25
1 2 3
…
25
26