Linq Connect Professional 4.2.222 and Oracle Dot net driver edition ??

[mlcmds]

What is the edition of Oracle dot connect driver is supplied with Linq Connect Professional 4.2.222. Are there any limitations to connecting to Oracle using the Linq Connect Professional 4.2.222 ?

[MariiaI]

LinqConnect Professional includes the Express edition of dotConnect for Oracle.
Express edition of dotConnect for Oracle bundled with LinqConnect provides basic connectivity features.
dotConnect for Oracle as a separate product has more advanced support for Oracle database and includes LinqConnect and Entity Framework support.
For more information about features of these products, please refer to:
http://www.devart.com/linqconnect/features.html
http://www.devart.com/dotconnect/oracle/features.html
http://www.devart.com/dotconnect/oracle/editions.html

If the information provided is not enough, please specify what features you are going to use in your work so that we are able to recommend you the most suitable product for you.

[mlcmds]

Hi Mariial,

Thanks for the reply.

To elaborate we intend using Linq Connect as the ORM for an ASP.NET MVC 4 app and working with an Oracle DB.
Developing a multi client web app in the Functional application area of Sales, Materials, Production, and Inventory. Aim to replace an existing app running on client server model.

Must support Integrity, Privacy, Transaction Persistence (aka locking etc..) in a multi client web scenario.

Is LINQCONNECT Professional alone enough for this with an Oracle DB and would I need any other edition of dotConnect other than express edition?

Hope this helps clarify my question.

Regards

Bala

[MariiaI]

Thank you for the additional information.
If you are going to work with Oracle only, dotConnect for Oracle Professional will provide a wider functionality for the scenario you are going to implement.
If, possibly in future, you will need to work with different databases it would be more suitable to use LinqConnect Professional (in this case, there is no need to purchase dotConnect for Oracle additionally, the Express edition bundled with LinqConnect will be enough).

JIC: pessimistic concurrency is not supported in LinqConnect, you could lock records manually in a query (for example, via the ExecuteCommand method).

[mlcmds]

With the Oracle Express edition bundled with LinqConnect is optimistic concurrency approach supported as documented at http://www.devart.com/linqconnect/docs/ ... ption.html
along with the ChangeConflictException ?

Thanks for pointing out that i could use the Execute command in case I want other locking options supported by the database.

Balachander

[MariiaI]

Yes, the optimistic concurrency approach is supported in LinqConnect as documented in http://www.devart.com/linqconnect/docs/ ... ption.html

Also, please refer to http://www.devart.com/linqconnect/docs/ ... hecks.html