Stack Overflow
Stack Overflow

Questions tagged [dotconnect]

dotConnect is an enhanced database connectivity solution built over ADO.NET architecture and a development framework with a number of innovative technologies.

dotConnect is an enhanced database connectivity solution built over ADO.NET architecture and a development framework with a number of innovative technologies.

Devart ADO.NET Data Providers product line includes high performance data providers for major databases and offers a complete solution for developing database-related applications and web sites.

dotConnect provides support ADO.NET Entity Framework and LinqConnect - an ORM solution that is similar to Microsoft LINQ to SQL, but has its own advanced features.

dotConnect products are available for Oracle, MySQL, PostgreSQL, SQLite, and SQL Server.

150 questions
1
vote
0 answers

npgsql postgresql functions to use in LINQ

Is there anything on npgsql similar to the SqlFunctions class, or the PgSqlFunctions available on dotConnect? I've been trying to create a dynamic sql expression using LINQ, but things like ToString or PadLeft can't be processed by LINQ. I really…
Bruno Santos
  • 724
  • 7
  • 19
1
vote
1 answer

the package of dotConnect for SQLite does not work for 64 bits C# project in VS2013?

This is a follow-up question from http://stackoverflow.com/questions/36166266/sqlite3-dll-cannot-be-used-in-c-sharp-application-in-vs2013-on-win-7/36169278#36169278 I installed dotConnect.Express.for.SQLite…
Lily
  • 295
  • 1
  • 4
  • 14
1
vote
1 answer

PgSqlParameter error using dotConnect Postgresql in Visual Studio

I have a stored procedure . The input is 'id', output 'n'. But when I try to run it in Visual Studio , I have an error: The value for the output parameter 'n' is absent in the command execution result. Here is my code: int id =…
Peter Kozlovsky
  • 633
  • 2
  • 10
  • 28
1
vote
0 answers

Type "OracleDbType.Int64" cannot be used in PL/SQL table parameter - devart dotConnect Express for Oracle

I am working on a project where I want to use int64 as return type for the elements in an array returned by a PL/SQL procedure. The procedure is invoked using the dotConnect Express for Oracle data provider version 8.5.521 (downloaded from nuget).…
Lasse Christiansen
  • 10,205
  • 7
  • 50
  • 79
1
vote
1 answer

Does App.config (or ApplicationName.exe.config) work in mono?

I'm trying to get EntityFramework 6 with dotConnect for Oracle working on Mono. I have also all app configuration defined in userSettings section. First thing I noticed is that my app has always default configuration, then I tried to make…
smokeing
  • 259
  • 1
  • 3
  • 13
1
vote
1 answer

Oracle Database Provider and dotConnect for Oracle -> how to make them generate SQL compatible with the Oracle version they are connected with?

I'm using .NET Entity Framework with Oracle. There are two main providers for Oracle database: one is the official release from Oracle ("ODP" - Oracle Database Provider) and another is the "Devart dotConnect for Oracle". In the documentation of both…
user1389591
1
vote
1 answer

Control datatype assignment for auto generated code

I am using DotConnect by Devart Oracle Edition Professional 8.4.215.0 to access tables in an Oracle database. I'm running into an issue where the auto generated code is interpreting NUMBER(3,0) data type as a boolean. I intended it to be values…
Felix Castor
  • 1,598
  • 1
  • 18
  • 39
1
vote
1 answer

dotconnect for postgres - Unknown parameter direction

I have problem with PgSqlCommandBuilder.DeriveParameters function. Sometimes it throws an exception “Unknown parameter direction.” without any visible reason. Problem occurs quite rarely. When I get a first exception, it throws always for all…
smolam
  • 21
  • 3
1
vote
1 answer

"Column not allowed here" in EF6 with TPH and Devart Oracle

When creating my DB schema with EF, Devart dotConnect generates the following SQL for my TPH class: CREATE TABLE "Types" ( ID NUMBER(10) NOT NULL, "Name" NVARCHAR2(50) NULL, "Discriminator" NVARCHAR2(128) DEFAULT (Undefined) NULL, …
hoekki
  • 228
  • 1
  • 11
1
vote
0 answers

Any method to use dotConnect without compiling the licence?

Im trying to use this http://www.devart.com/dotconnect/mysql/ with Indusoft Web Studio to connect from Windows CE to a MySQL database as its the only solution Ive found. The connection works (from what I see in the logs) but then a error message…
riahc3
  • 857
  • 4
  • 10
  • 23
1
vote
1 answer

Visual studio oddity toolbox click drag

So, I just installed dotConnect and in the wpf editor, if I select say a button then click and drag it to the window under construction in the designer, the option to select another control already there is lost. After that every time I click in…
Felix Castor
  • 1,598
  • 1
  • 18
  • 39
1
vote
1 answer

DevArt dotConnect for Oracle: EF Mapping TIMESTAMP WITH TIME ZONE to DateTimeOffset

Using Devart dotConnect for Oracle (8.2.103), when trying to build a EDMX model (Database first) with EF5, I can't find a way to get a TIMESTAMP WITH TIME ZONE column to be mapped into a DateTimeOffset instead of DateTime. How can I achieve that?
Farlop
  • 690
  • 1
  • 6
  • 20
1
vote
1 answer

dotConnect Oracle - migrations - Initial migration in two identical branches says differing model

I have just started testing migrations in several different team scenarios to make sure migrations will work as expected with git / multiple users / multiple branches. But I have run into an issue right off the bat. On branch 1 I added my Initial…
Jack
  • 9,156
  • 4
  • 50
  • 75
1
vote
1 answer

C# Linq "Entity with the same key '0' already added." when inserting multiple rows

I am trying to insert data in bulk, database is MySQL connection is done using Devart LinqConnect. Here is a code: DataContext db = new DataContext(); List XYDList = new List(); // Data Type List xyToBeInsrted = new…
PawelW
  • 23
  • 5
1
vote
1 answer

Spatial/geometry types in Entity framework using postgresql and postGIS

I need geometry types in my Entity Framework application. I've tried to follow this tutorial but I have had some issues and I'm not sure if it is because the tutorial is old or if I'm doing something wrong. For example, under "Creating a New Entity…
user1815201
  • 463
  • 3
  • 16
1 2 3
…
9 10