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
17
votes
3 answers

Large SQL transaction: runs out of memory on PostgreSQL, yet works on SQL Server

I have decided to move my C# daemon application (using dotConnect as ADO.NET provider) from SQL Server 2008 R2 to PostgreSQL 9.0.4 x64 (on Windows Server 2008 R2). Therefore I slightly modified all queries to match PostgreSQL syntax and... got stuck…
Proglamer
  • 173
  • 1
  • 1
  • 5
12
votes
3 answers

CLOB vs. VARCHAR2 and are there other alternatives?

I am using DevArt's dotConnect and Entity Developer for my application. I've created the tables using the Entity-First feature. I notice that many of the column types are set to CLOB. I only have experience with MySQL and Microsoft SQL server, so I…
Extrakun
  • 19,057
  • 21
  • 82
  • 129
10
votes
6 answers

Can we control LINQ expression order with Skip(), Take() and OrderBy()

I'm using LINQ to Entities to display paged results. But I'm having issues with the combination of Skip(), Take() and OrderBy() calls. Everything works fine, except that OrderBy() is assigned too late. It's executed after result set has been cut…
Robert Koritnik
  • 103,639
  • 52
  • 277
  • 404
9
votes
1 answer

The type System.DateTime is not a supported type. Change to use System.DateTimeOffset

We are creating a WebApi 2.2 service and are using the technologies listed above. Our backend datastore is MySql 5.6. We are using dotConnect for MySql to work with the data store. In the database, there is a RowVersion column with a type of…
A Bit of Help
  • 1,368
  • 19
  • 36
8
votes
1 answer

Connection pool management

I'm developing a high load web service that would provide as fast response as possible. The service should keep a bunch of connections to various databases for faster performance. I'm suggesting using connection pool for that. There may be…
kseen
  • 359
  • 8
  • 56
  • 104
8
votes
2 answers

ORA-00936: missing expression when reading from database with dotConnect driver and oracle database

I am using dotConnect driver for connecting to oracle database but i always get this error when i want to use parameters: ORA-00936: missing expression CODE: using (var cmd = conn.CreateCommand()) { conn.Open(); …
senzacionale
  • 20,448
  • 67
  • 204
  • 316
7
votes
2 answers

TransactionScope does not rollback inside wcf service method, does roll back if called directly

I am facing a problem that drives me crazy for couple of days now, hoping someone can help me. Here it is ; I'm using EF4 with oracle database, using dotConnect for oracle from devart as provider. I have wcf service method which calls DeleteCabinet…
rayback2
  • 81
  • 5
7
votes
1 answer

Linq to Entities and LEFT OUTER JOIN issue with MANY:1 relations

Can somebody tell me, why does Linq to Entities translate many to 1 relationships to left outer join instead of inner join? Because there's referential constraint on DB itself that ensures there's a record in the right table, so inner join should be…
Robert Koritnik
  • 103,639
  • 52
  • 277
  • 404
6
votes
2 answers

Postgresql with postGIS and entity framework, CHECK constraint issue

I have a postgresql database with postGIS and I'm using entity framework with dotconnect 6.7 for postgreSQL. With the following table in my database: CREATE TABLE geo ( the_geom geometry, id integer NOT NULL, CONSTRAINT primary_key PRIMARY…
user1815201
  • 463
  • 3
  • 16
5
votes
2 answers

DevArt's dotConnect for Oracle vs DataDirect's ADO.NET data provider

Has anybody done a comparative analysis of dotConnect for Oracle from DevArt and the ADO.NET data provider from DataDirect. We are thinking of using the Entity Framework support available in these frameworks for a critical enterprise application.…
Chai
  • 482
  • 5
  • 11
5
votes
2 answers

Should I be worried about Version Conflicts?

I recently updated my devArt dotConnect for Oracle components from version 6.? to 7.2 All seems to work fine. However, on compiling I see I've got the warning: "Found conflicts between different versions of the same dependent assembly." I don't know…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
5
votes
2 answers

Why is a DataRow recognized in one part of a method but not another (how can I dynamically add DataRows)?

With this code: OracleDataTable dt = PlatypusSchedData.GetAvailablePlatypi(); OracleDataTable outputDt = new OracleDataTable(); int iRows = 12; while (iRows > 0) { outputDt.Rows.Add(new DataRow()); // line 1 //var dr = new DataRow(); …
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
3
votes
1 answer

Why do I error out when trying to retrieve a result set with DotConnect components?

With the code below I get, "ORA-01036: illegal variable name/number" on the call to ExecuteReader: cmd.Parameters.Add("cur", Devart.Data.Oracle.OracleDbType.Cursor); cmd.Parameters["cur"].Direction =…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
3
votes
2 answers

How to generate and auto increment Id with EF Core Oracle

I use entity framework core 2 Code first to generate data in Oracle 11g, the entity provider is dotConnect, my POCO class is as follow: public partial class Favoritepage { [Key] [DatabaseGenerated(DatabaseGeneratedOption.Identity)] …
Nofield
  • 81
  • 1
  • 8
3
votes
1 answer

aspnetcore 2.0 with EF6 and dotConnect for oracle

I am trying to use Oracle using dotConnect for Oracle(v 9.4). Since aspnet core 2.0 has full support to reference older .net framework, I am trying to connect to database using a regular .net assembly(i.e assembly containing my DbContext is in…
int-i
  • 661
  • 1
  • 12
  • 28
1
2 3
…
9 10