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

Devart Oracle provider direct mode issues with parametrized queries

I'm having some bizarre issues with parametrized queries in direct mode. Basically if I perform an insert on a table that already contains a unique row I get an insert exception which is expected. After the insert exception I use this same…
lhla
  • 1
  • 1
0
votes
1 answer

How to write mapping conditions in Devart's Entity Developer

Does anybody know how to use the "Conditions" feature in the "Mapping Details" option of the Model. I have tried adding Conditions like "IsDeleted = False" or "IsDeleted = 0" and nothing works. Just get errors. Many thanks.
SamJolly
  • 6,347
  • 13
  • 59
  • 125
0
votes
1 answer

Exception Devart.Data.Linq on a server "Devart.Data.Oracle.Linq.Provider"

I am trying to deploy my application on Windows server 2007 32 Bit. My application gave me this Exception Error on opening DbConnection. bei Devart.Data.Linq.LinqCommandExecutionException.CanThrowLinqCommandExecutionException (String message,…
Haifa Derouiche
  • 11
  • 1
  • 6
0
votes
1 answer

Inserting Spatial\Geometry in EF5 with dotConnect 6.7 for PostgreSQL

I installed the latest dotConnect for PostgreSQL. Im trying to insert a record in the Postgres DB. I have a geometry column what gives me errors. Here is the code: using (var context = new WKP_DBEntities()) { var Location =…
StefanHa
  • 727
  • 8
  • 19
0
votes
1 answer

DirectMode with Devart and FluentNHibernate and Oracle 10g

I have a Windows x64 installed on my machine, of course Oracle hadn't made a Driver for using their client in Oracle10g, this is seems to be a huge problem for me (stop whining).... So i actually have to connect to DB with Direct Mode. This is the…
hackp0int
  • 4,052
  • 8
  • 59
  • 95
0
votes
1 answer

Devart dotconnect - Is there a way to force the commit order?

I am using devart dotconnect for Oracle v7.7, and am getting a unexpected error. I am inserting a record into table A, and then another a number of records into table B where B has a foreign key to A, and I'm getting a parent key not found…
Ricardo Appleton
  • 679
  • 10
  • 22
0
votes
1 answer

What is the preferred method for assigning a connection in a DLL

I am using ODAC v8.2.8 or perhaps 9. with Delphi 5. I have an application which can launch a number of applications implemented as dlls. In order to share the launcher's database connection the AssignConnect() method is used. I have noticed one of…
Hugh Jones
  • 2,706
  • 19
  • 30
0
votes
1 answer

Devart always update the same entity

I have a problem with devart when it executes the context.SaveChanges() methods. For example if there is a problem during the update process (the length of the string is too long for the db field, i have an exception) and for each entity to be…
Etienne Arthur
  • 680
  • 1
  • 9
  • 17
0
votes
1 answer

devart dc.ExecuteQuery returns Object not set to an instance of an object

I've recently upgraded to devart 7.5 and a few functions are not working properly. Specifically, I've got a function that returns an IEnumerable: protected IEnumerable getTotals(decimal groupId, decimal budgetId) { using…
Ricardo Appleton
  • 679
  • 10
  • 22
0
votes
2 answers

oracle devart entity framework - added New column - now trigger system_id not changing to a unique new number?

oracle 10.4 devart dotConnect - 6.50... MVC2 project - web page User fills out form, then controller gets new entity, fills it out. saves database System_id before saving = 0 (its an int/number - so no cannot be null) Several other tables linked, so…
Maze
  • 401
  • 2
  • 8
  • 18
0
votes
2 answers

Assertion failure in DBAccess.pas

I am interested in upgrading a suite of software from ODAC v5 to v8.2.8. One app in particular is causing problems. This application loads one of a set of secondary applications implemented as dlls. LibHandle := LoadLibrary(PChar(dllname)); if…
Hugh Jones
  • 2,706
  • 19
  • 30
0
votes
1 answer

How to use PgSqlType with devart entity developer

I want to map the postgres type point to the Devart.Data.PostgreSql.PqSqlPoint structure. I found a table (devart PgSqlTypes) in which is stated for point: "May be represented as the PgSqlPoint class or the Srting". However in devart's Entity…
markus s
  • 1,024
  • 1
  • 11
  • 20
0
votes
1 answer

cannot load stored procedure in devart linqconnect

I have created a Devart linqconnect model called as shopping context and using mysql as the database.I am using trial version of Linqconnect. I have created a stored procedure clothingItems in the database , when i try to add the stored procedure…
Vishal Torne
  • 366
  • 5
  • 24
0
votes
1 answer

cannot load datacontext in devart linconnect

I have added devart linqconnect ORM to connect to the mysql database. it is a trial version though, i have created a shopping.iqml file in my application which automatically creates a model for the linq to mysql. when i write using…
Vishal Torne
  • 366
  • 5
  • 24
0
votes
1 answer

Using Code First and Database First Entity Framework with Devart

I have one website that uses EF 4.4 (.NET 4.0 version of EF 5.0) that uses Code First against an existing database. I use the Devart oracle data provider which requires a workaround because of casing issues with the model type. It makes the Devart…
Talonj
  • 2,228
  • 1
  • 16
  • 15
1 2 3
…
25 26