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

Can't connect to postrgres using Visual Studio with dotConnect

When I try to connect to DataBase, I get error: Key word doesn't support: Host. int x = Int32.Parse(textBox1.Text); try { System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(); …
Artem Gunkin
  • 61
  • 1
  • 9
0
votes
1 answer

EntityFramework connection to Oracle using Devart not working

I am trying to connect to a oracle database using Devart, from an MVC application with EntityFramework. I downloaded and installed Devart dotConnect, and added the following in the web config:
CrazyDog
  • 321
  • 3
  • 17
0
votes
1 answer

How to dynamically group a list depending on role in asp.net mvc

Here is my scenario: We would like to have a page listing donors, depending on the user viewing the page we would like to group by the donor's giving level, or just their sort name. The twist that is throwing me is that we would like to group the…
Lloyd
  • 1,395
  • 6
  • 20
  • 37
0
votes
1 answer

C# TransactionScope with 2 different databases

I am working on distriuted transactions on Oracle databases. I have the following code, see below and 2 questions. targetConnection and sourceConnection are both Oracle databases and are located on different networks. 1) Which of the command will…
Zar
  • 11
  • 1
  • 3
0
votes
1 answer

Calling an Oracle stored procedure with Entity Framework code-first and DevArt Drivers

I have an Oracle stored procedure that I am trying to call with EF code-first (DbContext) using the DevArt Oracle drivers (latest version). I don't know why this has to be so hard (I wish I was using SQL Server), but I cannot make it work. I am…
0
votes
2 answers

Issue with Updating Changes in LINQ

I'm having an issue with updating the database. The app shows the updated value, but the database does not. No errors returned. My table has a PK. Using DotConnect for Oracle, but the LINQ syntax is the same. namespace ConsoleApplication1 { …
MAbraham1
  • 1,717
  • 4
  • 28
  • 45
0
votes
2 answers

Merge query returns -1 instead of number of rows merged

We have an old application that runs against an Oracle database and makes use of DataSets, DataTables and TableAdapters. It uses the now deprecated System.Data.OracleClient and we are looking to replace this dll with those from DevArt. I used the…
Sam
  • 1,358
  • 15
  • 24
0
votes
1 answer

Create TVirtualTable via Code only without drop component

Recently i want to export data using TscExcelExport. If i'm using TVirtualTable using Design Component, it works perfectly. EmpVT.First; EmpVT.Filtered := False; while not EmpVT.Eof do begin //Salary Virtual Table …
0
votes
1 answer

Which license is used by dotConnect Express for Oracle?

I have been looking for the license used/required by dotConnect Express for Oracle 8.4.201. I am using their nuget package: https://www.nuget.org/packages/dotConnect.Express.for.Oracle/8.4.201 Unfortunately, the nuget page does not include any…
Lasse Christiansen
  • 10,205
  • 7
  • 50
  • 79
0
votes
1 answer

Has INotifyPropertyChanging been removed from wp8.1 universal

Just been trying to convert my app from Windows Phone 8.0 to Windows Phone 8.1 Universal/store app. I was using Devart's LinqConnect to access my SQLite database and when I added the model to the project and did a compile and I received the…
Gaz83
  • 2,293
  • 4
  • 32
  • 57
0
votes
1 answer

Does DevForce 7.2.2 work with EF6 + Oracle ODAC Release 3 driver?

Our project is based on DevForce 7.2.2 + EF5 + Oracle ODAC Release 2 currectly. Oracle provide new ODAC Release 3 since Cristmas day, which supports EF6, so we plan to migarte to EF6. I installed new ODAC driver and EF6, add…
0
votes
3 answers

No Entity Framework provider found for the ADO.NET provider with invariant name 'Devart.Data.Oracle'

I'm using Devforce 7.2.4, Devart - dotConnect for Oracle 8.4.313, Entity Framework 6.1.2. I got that error when i set DevForceEnabled property to true on my model.edmx However I found the link =…
Molinari
  • 1
  • 1
  • 1
0
votes
1 answer

Function Return void How to Run with Open RIA Domain Service

I have few Functions & Procedures to Run from Silverlight project. I have mapped data in EF6. Now I want to Run these function Using OpenRIA Service. I tried giving annotation like Query, Update, Insert, Delete. One or other function does some of…
akirti
  • 179
  • 2
  • 15
0
votes
1 answer

Oracle database returns faulty rows from stored procedure using devart in C#

I have an oracle database with a stored procedure: PROCEDURE "CalculateChats" ( "In_Conf" IN NUMBER, "In_From" IN TIMESTAMP, "In_To" IN TIMESTAMP, "Out_Cursor" OUT "Cursor" ) AS BEGIN OPEN "Out_Cursor" FOR SELECT …
Magic-Mouse
  • 603
  • 10
  • 21
0
votes
1 answer

dotConnect Oracle: Same foreign key constraint name for multiple references to the same table

I have a rather complex database model (around 100 entities) in EF6 code first. One of these entities is called 'Base', another 'BaseAssociation'. 'BaseAssociation' establishes a many-to-many relation between 'Base' objects. Attached to the…
hoekki
  • 228
  • 1
  • 11