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

Include method in LINQ is used for Left Join?

I'm using Entity Framework 6, DotConnect for Oracle and i have these 2 queries: First one, using a simple join (LINQ and Output SQL): LINQ: var joinQuery = Db.Products .Join(Db.Product_Categories.AsEnumerable(), p => p.ProductID, pc…
Daniel Moreira
  • 430
  • 4
  • 17
3
votes
2 answers

Convert a MySQLGuid (from Devart dotConnect for MySQL) to String in SQL

I'm using Devart's DotConnect product to connect an .net application to a MySQL Database. Everything is working pretty well, but I have an issue when working with SQL in the database. The application uses Guids for row id's in the database (having…
Richard Comish
  • 197
  • 2
  • 20
3
votes
1 answer

Error "column c.CreatedOn does not exist..." in PostgreSQL logs during code first context initialization using the Devart dotConnect provider

I'm getting the following error in my PostgresSQL logs whenever my context is initialized: 2014-06-03 09:51:25 PDT ERROR: column c.CreatedOn does not exist at character 10 2014-06-03 09:51:25 PDT STATEMENT: SELECT c."CreatedOn" FROM…
Chris
  • 1,533
  • 2
  • 17
  • 33
3
votes
2 answers

StoreGeneratedPattern not working with DevArt Entity Framework?

I wrote a simple test program which will access the default HR model on an Oracle Express in direct mode using DevArt dotConnect for Oracle v. 6.8.0.350: using (var ctx = new HREntities()) { var locNew = new LOCATION(); locNew.CITY =…
Alexander Schmidt
  • 5,631
  • 4
  • 39
  • 79
2
votes
0 answers

After upgrade to EF Core 2.2 => 3.1, Guid ID no longer generated by DbSet.Add()

I'm upgrading from EF Core 2.2 to EF Core 3.1. I have an entity Patient with a GUID Id: class Patient { public Guid Id { get; set; } public string FirstName { get; set; } public string LastName { get; set; } } A DbSet is defined for…
realmikep
  • 593
  • 1
  • 6
  • 22
2
votes
2 answers

Call Oracle stored procedures using devart dotConnect

I'm new in Entity Framework and trying to call oracle stored procedures, but without success. So Here is my question: How to call oracle stored procedures using devart dotConnect? For example, I have stored procedure: procedure get_problems(res out…
Vano Maisuradze
  • 5,829
  • 6
  • 45
  • 73
2
votes
2 answers

dotConnect for Oracle Hebrew problem - gibberish - getting ¿¿¿¿

I'm trying to create EF through Devart dotConnect with an Oracle database that includes Hebrew chars. In regedit: NLS_LANG = HEBREW_ISRAEL.IW8ISO8859P8 In web.config:
Tzvi Gregory Kaidanov
  • 3,080
  • 3
  • 26
  • 33
2
votes
2 answers

Porting Oracle associative arrays to Postgres and wrapping the data access using npgsql

It is great to get prompt replies on the npgsql queries. Thanks to its owner! I am trying to port a sproc that took in array valued parameters to postgres with similar abstraction/semantics. I am wondering how one would shape the pgsql sproc and use…
postgres_rookie
  • 73
  • 1
  • 11
2
votes
1 answer

Disadvantages when using dotConnect for Oracle in comparison to SQL Server?

I am currently evaluating dotConnect for Oracle as an alternative to switching to SQL Server at my company altogether. We are currently developing ASP.NET MVC2 applications with datasets and oracle, but we would like to switch to entity framework…
Christopher
  • 517
  • 1
  • 4
  • 15
2
votes
0 answers

dotConnect with EntityFramework Core returns Collection was modified; enumeration operation may not execute

I have an application using ASP.Net Core RC2 and Entity Framework Core RC2, and using the dotConnect for Oracle driver (dotConnect doesn't support EF Core 1.0 yet). I am trying to run 8 GETs concurrently, for different records, and I'm getting this…
Ricardo Smania
  • 2,939
  • 2
  • 26
  • 35
2
votes
1 answer

Multiple EF6 DbContext for one DbConfiguration in ASP.NET 5

I'm trying to port my MVC 5 application to MVC 6. I'm using Devart dotConnect for MySql and Oracle. I have trouble configuring my application. Right now I have the following entries:
Shadow
  • 2,089
  • 2
  • 23
  • 45
2
votes
3 answers

dotConnect or "sqlite.phxsoftware.com" for using Entity Framework with SQLite

Which is the better choice out of dotConnect or "sqlite.phxsoftware.com" for using Entity Framework with SQLite (in C#)?
Greg
  • 34,042
  • 79
  • 253
  • 454
2
votes
1 answer

Oracle UDT with EntityFramework Support

is there any support for oracle user defined data types with Entityframework 5 or 6 (devart dotConnect or ODP.Net) ?
Mohamad Alhamoud
  • 4,881
  • 9
  • 33
  • 44
2
votes
2 answers

Database connection string and collation

Is it possible to set connection collation within MySql connection string and how, since there's a default setting on the server that's used for new connections. Two things I can't do: Can't call SET COLLATION_CONNECTION after I open a connection,…
Robert Koritnik
  • 103,639
  • 52
  • 277
  • 404
2
votes
1 answer

Use EDMX designer with PostgreSQL

Is there a way to use my existing EDMX and connect to PostgreSQL ? Also can I convert MSSql edmx to work with postges, coverting edmx to edmi is also an option? Thanks
khorvat
  • 1,630
  • 2
  • 20
  • 31
1
2
3
…
9 10