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

DotConnect PostgreSQL Update Command

string finalResult = "Failed"; using (PgSqlConnection myConnect = new PgSqlConnection(Resources.MyResources.DotConnectNewConnectionString)) { try { myConnect.Open(); …
Eustace Zheng
  • 1
  • 2
0
votes
1 answer

Problems with inserting DbGeography values on Oracle and dotConnect

we have a model class with a DbGeography property. Now we want to make our system work on an oracle database and evaluating dotConnect by devart for this purpose. Initial migration was good enough and created an appropriate table and mapped the…
maxyha
  • 13
  • 5
0
votes
1 answer

VB.NET with pgSQL: How to change textbox type within SQL queries?

I've written a VB form on Visual Studio 2013 (.Net Framework 4.5.1) that opens and edits a pgSQL database. In order for the user to be able to search the table, I created a compobox from which the user can select the desired column to search and…
H. D. Afentoulidis
  • 1
0
votes
2 answers

Unable to find the requested .Net Framework Data Provider. PostgreSQL and Mono

I have a problem with my application wrote in Visual Studio. Build in Visual Studio is OK, but when I try to run on Mono. Server shows System.ArgumentException Unable to find the requested .Net Framework Data Provider. It may not be installed. I…
JaSHin
  • 211
  • 2
  • 16
  • 43
0
votes
1 answer

How to see the SQL generated by Entity Framework when using an Oracle database?

I'm using devArt dotConnect to talk to an oracle 11g database. In another project with SQL Server it was very easy to see the SQL that was generated using the debugging tools from Visual Studio. However this doesn't seem to work when the database is…
paddingtonMike
  • 1,441
  • 1
  • 21
  • 37
0
votes
1 answer

Runtime error while creating database context using dotConnect and Entity Framework 6

We're using DevArt dotConnect to connect to an Oracle backend. Our previous dev machines have all used dotConnect 8.4.254.4, which is what's checked into Subversion. I've set up a new dev machine and installed the newest version, which is…
Mike Christensen
  • 88,082
  • 50
  • 208
  • 326
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
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
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

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

OverflowException with dotConnection PostgreSQL

I've create model from databse using dotConnect for PostgreSQL, proffesional edition. Everything works fine exception one of the entity. Some of properties were generated as decimal. Sample property in my Entity: public…
user2160375
0
votes
1 answer

How to check if dotConnect for postgreSQL database connection is right

I've got a excel plugin connected to a PostgreSQL database server and all works well. There is a user interface to switch databases, but when somebody accidentally mistypes the database there are a lot of errors - ofcourse. I would like to check on…
DeniseMeander
  • 806
  • 2
  • 9
  • 28
0
votes
0 answers

EF6.1: Delay between query completed and connection close

We are using EF6.1 and dotConnect for Oracle. Trying to debug why our development performs poorly in one of customers server, I turned on the DatabaseLogger Interceptor feature to get the queries executed in DB and try to improve them. One thing…
Farlop
  • 690
  • 1
  • 6
  • 20
0
votes
1 answer

dotConnect: CROSS APPLY is not supported by Oracle Database 11g

I'm trying to execute this code block using devart dotConnect 8.4 + EF6.1: var menus = (from m in dbSet from p in m.RegraAcesso.Perfis from u in p.Usuarios where u.Id == userId &&…
Luciano Gerhardt
  • 93
  • 6
0
votes
1 answer

Oracle MERGE statement not 'sticking' using DevArt dotConnect for Oracle

I'm using an Oracle MERGE statement in dotConnect for Oracle, I know that the MERGE itself is fine as runs in P-Sql and SQL Developer, yet using the dotConnect and ExecuteNoQuery the query is apparently successful (no exceptions thrown) but the…
d sharpe
  • 189
  • 2
  • 12
1 2 3
…
9 10