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

Is there something problematic about this particular aliased SQL column?

Why would aliases be treated like aliens when used in a select statement? I can't imagine this is always the case, but I had to change this code: const string query = @"SELECT C.PLATYPUSCLIENTID, E.DEWDROPNAME FOGGY FROM DUCKBILLACCOUNT B, …
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
2
votes
1 answer

Why does this query give me "Object reference not set to an instance of an object"?

This code: string SidFinch = "Unknown SidFinch"; String sql = @"SELECT SidFinch FROM PlatypusDuckbillS WHERE PlatypusSTARTDATE = :Duckbilldate AND DuckbillID = :Duckbillid"; try { using (OracleCommand…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
2
votes
1 answer

Devart dotConnect For Oracle and Enterprise Library Custom Provider Mappings

I'm trying to get a simple proof-of-concept working using the trial of Devart's dotConnect for Oracle because we currently use the .Net framework OracleClient (due to be deprecated) but we also have a requirement to connect without the need for the…
Steve Pettifer
  • 1,975
  • 1
  • 19
  • 34
1
vote
3 answers

What format does Oracle expect for dates?

With the following C# code (using devArt's dotConnect for Oracle components): OracleParameter pRes = new OracleParameter("C_REF", OracleDbType.Cursor); pRes.Direction =…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
1
vote
2 answers

Telerik's OpenAccess ORM and DevArt's dotConnect for Oracle

Has anyone tried to connect to an Oracle DB using DevArt's dotConnect data provider among with OpenAccess ? OpenAccess works excellent with Oracle.DataAccess.Client, but how about dotConnect? Is it possible? Thanks!
Teslo.
  • 471
  • 2
  • 9
  • 22
1
vote
0 answers

Linq - Grouping by range results in "sub-query returns more than one row"

I am using the following LINQ to group by a variable range (as per question here) var ranges = new List { 5m, 10m, 20m }; var grouped = entities.PointTransaction.Where( x => x.UserInfo.College == collegeID && x.Amount…
Extrakun
  • 19,057
  • 21
  • 82
  • 129
1
vote
1 answer

Migrating data in an database created with EF code first (devart connector) to EFCore code first (sqlite)

The EFCore documentation is very specific on what to do, to migrated an EF based codebase to EFCore https://learn.microsoft.com/en-us/ef/efcore-and-ef6/porting/ . However, I could not find advice on how to bring the data stored in an sqlite database…
MatBab
  • 11
  • 1
1
vote
1 answer

Devart DotConnect got unexpected long decimal point for me while using entity framework 6 against Oracle

I have a record which contain a number in certain field: 25.99. Whenever I select this record using Devart DotConnect from my C# code it returns me 25.990000000000002. Therefore, my update statement prompt me such exception: Store update, insert, or…
mannok
  • 1,712
  • 1
  • 20
  • 30
1
vote
0 answers

How to Fix "Ora-02048" with TransactionScope is Required

I am receiving ORA-02048: attempt to begin distributed transaction without logging with TransactionScope with TransactionScopeOption is Required. I am testing the usage of TransactionScope with Required Option or requireNew Option for a very…
Nadeem Tabbaa
  • 39
  • 9
1
vote
1 answer

License error using Benchmark.NET + DevArt dotConnect for PostgreSQL

I'm working on an application consisting of several projects and using EntityFramework with dotConnect to run against PostgreSQL. I also have a license for dotConnect which successfully works in the main application. In parallel, I'm crafting a…
Dmitry Senin
  • 45
  • 1
  • 7
1
vote
2 answers

Setting connection string in code

I have an .NET MVC application which utilizes entity framework and a 3rd party provider to interact with an Oracle database. I need to be able to choose among two connection strings based on who is using the application. The 3rd party provider…
jollyRoger
  • 11
  • 2
1
vote
1 answer

license not found issue devart postgres sql

i have developed an app using the devart dot connect control. I have deployed on the server, using iis. However, whenever i try to do anything with the database i get the license not found error. I have copied the license file into the bin and root…
Daniel Casserly
  • 3,552
  • 2
  • 29
  • 60
1
vote
1 answer

Can't Install DotConnect for PostgreSQL

I have "Incompatible version found" error with Details: "Devart.Data assembly version 5.0.1375.0 is found in Global Assembly Cache." When I'm running DotConnect for PostgreSQL v 7.4.521.0 Installation. But I have no any "Devart","DotConnect" etc…
Cloudswalker
  • 55
  • 10
1
vote
0 answers

Suddenly Can't connect to SSH server Error fetching database list Connection Population Error using Red Gate MySQL Compare Devart dotConnect for MySQL

update 5/24/2017 sudo grep Kex /etc/ssh/sshd_config KexAlgorithms diffie-hellman-group-exchange-sha256 This is definitely enabled. end update 5/24/2017 Suddenly, can't connect to SSH server using Red Gate's MySQL Compare and MySQL Data Compare which…
Deane
  • 11
  • 3
1
vote
3 answers

Change Schema Name at Runtime in data context

So, I'm using dotConnect for Oracle. I used the template and wizard to create a model of the database (Database first approach). We have multiple databases that a single application needs to reference and unfortunately the schema naming which…
Felix Castor
  • 1,598
  • 1
  • 18
  • 39
1 2
3
…
9 10