EntityFramework-Plus icon indicating copy to clipboard operation
EntityFramework-Plus copied to clipboard

"Devart" doesn't necessarily mean "Oracle"

Open southlogan opened this issue 5 years ago • 2 comments

Description

In QueryFutureBatch.CreateCommandCombined, the substring "Devart" is incorrectly taken to be an indication that the db is Oracle.

I'm using Devart dotconnect for PostgreSQL. The command.GetType().FullName for this is "Devart.Data.PostgreSql.Entity.q".

My assumption would be that the line should be changed to:

var isOracleDevArt = command.GetType().FullName.Contains("Devart.Data.Oracle");

but I have no way of testing that that version will correctly detect Oracle.

Exception

System.ArgumentNullException: Value cannot be null. (Parameter 'type') at System.Linq.Expressions.Expression.Convert(Expression expression, Type type, MethodInfo method) at System.Linq.Expressions.Expression.Convert(Expression expression, Type type) at Z.EntityFramework.Plus.QueryFutureBatch.SetOracleDevArtDbType(Assembly assembly, DbParameter dbParameter, Object type) in D:\Users\Brian\Documents_NewWork\EntityFramework-Plus\src\shared\Z.EF.Plus.QueryFuture.Shared\QueryFutureBatch.cs:line 557

Further technical details

  • EF version: EF Core 3.1.3
  • EF Plus version: 3.045
  • Database Provider: Devart dotConnect for PostgreSQL 7.17.1612

southlogan avatar Apr 14 '20 17:04 southlogan

Hello @southlogan ,

Thank you for reporting.

Unfortunately at this moment, we only support Oracle for DevArt. I don't think we want to add more providers for now but we will certainly look at it eventually to support all providers DevArt support.

JonathanMagnan avatar Apr 14 '20 18:04 JonathanMagnan

Ok, thanks.

[CTS_Logo (3125x3750 cropped)] Brian Bell CTS Asset Management LLC www.ctsassetmanagement.comhttp://www.ctsassetmanagement.com/ (719) 578-3309 Office (303) 941-4207 Cell [cid:[email protected]]http://www.linkedin.com/in/brianbellmanagedfutures

Past performance is not NECESSARILY indicative of future results. Commodity trading involves substantial risk of loss.

From: Jonathan Magnan [email protected] Sent: Tuesday, April 14, 2020 12:51 PM To: zzzprojects/EntityFramework-Plus [email protected] Cc: Brian Bell [email protected]; Mention [email protected] Subject: Re: [zzzprojects/EntityFramework-Plus] "Devart" doesn't necessarily mean "Oracle" (#600)

Hello @southloganhttps://github.com/southlogan ,

Thank you for reporting.

Unfortunately at this moment, we only support Oracle for DevArt. I don't think we want to add more providers for now but we will certainly look at it eventually to support all providers DevArt support.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/zzzprojects/EntityFramework-Plus/issues/600#issuecomment-613618544, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AHDHJCRASSB3SNGL2FYBNATRMSWBJANCNFSM4MH5LV5A.

southlogan avatar Apr 14 '20 23:04 southlogan