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

How to store a field having datatype Number (35) (in Oracle database )in a variablein asp.net c#

I am having a field as Number35 in Oracle database.I need to use this FIELD in ASP.NET MVC APPLICATION. The application is using entity framework and devart oradeveloper tool to connect Oracle database. I am facing the issue that when .edml file…
0
votes
1 answer

Specify construct when querying with Devart.Data.Linq.DataContext.Query

I'm using Devart's Linq to sql in my project (not Entity Framework). Try to select from database with Query, or ExecuteQuery, but T deliberately don't have public parameterless constructor. Can I somehow overwrite how should a new instance of…
ntohl
  • 2,067
  • 1
  • 28
  • 32
0
votes
1 answer

Visual Studio 2015 - License information says no "license information needed" but it's wrong

I'm using Visual Studio 2015 with the latest devart dotConnect components (Version=9.4.348.0). When I include a reference (dll) which uses the devart components internally in a C#-project it should be possible to fix the license information like…
0
votes
2 answers

ORA-01450: maximum key length (6398) exceeded (Devart.Data.Oracle.OracleException)

First dataaccess method using entityframework fluent api , Dev Art in oracle database getting below error. actual table design : this query failing. CREATE TABLE DADeskSettings ( UserID NVARCHAR2(2000) NOT NULL, Password NVARCHAR2(2000) NOT…
anand
  • 307
  • 3
  • 14
0
votes
0 answers

Select multiple tables using asp .net core and Oracle 8i database

I am pretty much trying to do a query for multiple tables from an Oracle 8i database. Using Devart dotconnect to a .net core applicaiton. I am aware the joins were not available back then, but has anyone found a way to do this? I have tried the…
0
votes
1 answer

Transaction between different contexts using EF

I have a project that i want create an separation of concepts, related with db, with reuse propose. I use EF, with mysql(devart) connector, and I want to create a transaction, that creates a registry in some table and link this registry to other…
d4rc
  • 1
  • 3
0
votes
1 answer

Delphi and UniDAC embedded MySQL connect string

I have a problem with connecting Devart UniDac with embedded mySQL database. The code goes: basedir := GetCurrentDir + '\mysql'; UniConnection1.ProviderName := 'MySQL'; UniConnection1.Database :=…
Aleksandar
  • 48
  • 5
0
votes
2 answers

An error occurred while closing the provider connection…OCI invalid handle

I searched a lot trying to find why am I getting this error but no help, can you please advise. I am getting the following error when executing a linq query var test = (Linq query).ToList(); System.Data.EntityException: An error…
Mocas
  • 1,403
  • 13
  • 20
0
votes
1 answer

Why is Devart Entity Developer is removing the underscore in property names?

I am using devart entity developer and try to generate a model Database First approach with Fluent mapping. I would like to retain my table column names as is in classes and model store. My column names are having underscore in between example:…
0
votes
0 answers

dotconnect for postgresql performance seriously poor on a query

In Visual Studio 2015 3 - C# version 7.7.837 of the dotNetConnect from Devart for PostgreSQL EF 6.0 I either need to figure out how to fix the below performance issue or how to use the results from my ADO query - I will open another question on the…
Joe Ruder
  • 2,122
  • 2
  • 23
  • 52
0
votes
1 answer

how to start a instance of dbmonitor mysqlmonitor in a console application

This is probably simple, but I have not found how to do it. Needing to monitor my C# console application in vs 2015. The help file for dbMonitor states: "You can do it by dropping MySqlMonitor on form from toolbox or by creating it manually in…
Joe Ruder
  • 2,122
  • 2
  • 23
  • 52
0
votes
1 answer

Dealing with merge conflicts from model-first generated code

I am working on an MVC5 application where the Entity Framework data access layer is generated with Entity Developer. We keep source in Git (Git flow) and I have merge conflict issues every time the model changes in a feature when I try rebasing…
Vinyl Warmth
  • 2,226
  • 3
  • 25
  • 50
0
votes
1 answer

Getting value from sqlite with index

Edit: I am using Devart LinqConnect Model. I think it is an entity framework. So I am getting datas with LinqtoSQLiteDataContext _conn = new LinqtoSQLiteDataContext(); When I use var persons = _conn.persons;, it brings me all datas from person…
user1372430
0
votes
1 answer

PostgreSQL query (EF + Devart) fails in application, but works in PgAdmin

I have a problem with one of my SQL (PostgreSQL) queries generated by Entity Framework with Devart connector. After exactly 60 seconds (every time), I get an error: System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while…
Andrzej Gis
  • 13,706
  • 14
  • 86
  • 130
0
votes
1 answer

Devart.Data.MySql.MySqlDependency does not work on multiple connections

i have a problem concerning the Devart.Data.MySql.MySqlDependency class. I want to have two dependencies checking the database for changes, but some how i get the error: Net packets out of order: received[1], expected[7] I cannot handle this…
blueio22
  • 48
  • 7