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
0
votes
1 answer

entity framework dotconnect for oracle command timeout

The default command timeout property in connection string is not working. I am trying with Entity Framework and have a default command timeout=60 in the connection string. It is not throwing an error after 60 sec. Is this a bug?
Jonna
  • 1,625
  • 1
  • 18
  • 38
0
votes
1 answer

Replace Devart DotConnect with MySQL Connector / Net - Visual Studio 2010

I am working on a Visual Studio 2010 Solution. This solution is a web-site comprised of multiple web apps (using JavaScript, ASP, etc.). Every time I compile, I get an error message stating that my DotConnect trial has expired. Instead of forking…
p1nr
  • 23
  • 4
0
votes
1 answer

Will EF precompiled views work with Oracle and Devart?

We found an interesting article about improving performance of Entity Framework by using "precompiled views": http://neverindoubtnet.blogspot.ch/2012/03/squash-entity-framework-startup-time.html We have tried this - we use the EF Power Tools…
chiccodoro
  • 14,407
  • 19
  • 87
  • 130
0
votes
1 answer

DevArt dotConnect for Oracle with strange behavior on strings with EF 4.0

After I updated my project to Version 7.2.114 of DevArt I recognized that some queries will not return results although the generated SQL is returning results if executed directly in TOAD. If I switch back to Version 7.0.25 everything works fine. My…
Alexander Schmidt
  • 5,631
  • 4
  • 39
  • 79
0
votes
1 answer

Getting currently selected row in a devArt dotConnect DbDataTable (possibly DataTable)

I'm writing a control that will simplify some of the editing process in a dotConnect DbDataTable component. Part of the editing process is being able to call BeginEdit() and EndEdit() on the current row. Many articles make it clear that the current…
Jordy Boom
  • 620
  • 5
  • 18
0
votes
1 answer

Can't generate EF model correctly with Devart dotConnect for PostgreSQL product

I have problem when creating Entity Framework model from an existing PostgreSQL database with the Devart dotConnect for PostgreSQL product. This product offer 2 ways of generating EF model from a database and neither seems to work. When using an…
Etienne Desgagné
  • 3,102
  • 1
  • 29
  • 36
0
votes
1 answer

Devart DotConnect for SQLite 4.2.77 upgrade difficulty with VB existing projects

I have just upgraded to DotConnect for SQLite 4.2.77 from a previous version (sorry, can't remember the version). In VB Express 2010, I have successfully gone through the manual installation of components as described in Help. However, when I open…
user1672999
  • 1
0
votes
1 answer

Cleanest Way to determine whether a row exists?

Is this the safest/optimal code for a simple "does the record exist" question: . . . // "oc" is an OracleConnection component const string sql = "SELECT COUNT(*) FROM CONGRESS WHERE IQ > WEIGHT"; //Most politicians have more pounds than sense try { …
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
2 answers

Why is the Ordered By disregarded?

I want my SQL to return all records for a given date, with the most recent one on top (the column I'm ordering by contains both date and time - contains entries such as "5/21/2012 11:48:04 AM"). I would think my sql (below) would do this. However,…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
1 answer

Does the Visual Studio 2010 EDMX Designer work with DevArt dotConnect?

I'm trying to switch over a model to use the DevArt dotConnect driver. It's actually worked before, but it seems to have reverted back to the default .NET Oracle drivers after I re-generated the model. What I did was open up the .edmx file in…
Mike Christensen
  • 88,082
  • 50
  • 208
  • 326
0
votes
2 answers

Why would a statement execute in Toad but not in my code?

Here is my code: private void UpdatePlatypus(String APetPlatypus) { oracleConnectionMainForm.Open(); OracleCommand ocmd = new OracleCommand(); ocmd.Connection = oracleConnectionMainForm; try { ocmd.CommandText =…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
2 answers

In what format does Oracle expect a date value, and how can I give Oracle what it wants?

"AVAILABLEDATE" is a column of type DATE. I can query the table via Toad and get results. However, in (Winforms/C#/dotConnect) code, it's not working. ocmd.Parameters.Add("AVAIL_DATE", getDateToQuery()); I'm pretty sure the problem is the way I'm…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
-1
votes
1 answer

Insufficient data left in message

When we are uploading excel with more than 50,000 records, facing issue like "Insufficient data left in message". I have verified the data with insert statement with previous statement and didn't see any difference. Could you please check and need…
Goli Someshwar
  • 3
  • 3
-1
votes
1 answer

DbSet Include Generates Incorrect SQL (Devart DotConnect Oracle)

I am using Devart DotConnect For Oracle with EF Core 2.0.1. When I execute code below Entity Framework generates wrong SQL. I am considering this as a bug, however I am not sure whether I am the one who is making mistake or not. And also, I need a…
Derviş Kayımbaşıoğlu
  • 28,492
  • 4
  • 50
  • 72
-1
votes
1 answer

How to add Devarts dotConnect provider to Entity Framework?

I'm trying to follow this Devarts tutorial of Entity Framework: http://www.devart.com/dotconnect/oracle/articles/tutorial_ef.html But when I try to create a connection of Entity Data Model, I cant find the dotConnect provider. I already add that…
Daniel Moreira
  • 430
  • 4
  • 17
1 2 3
…
9
10