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

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

Postby mlcmds » Wed 17 Apr 2013 12:07

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 ?
mlcmds
 
Posts: 5
Joined: Mon 30 May 2011 12:02

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

Postby MariiaI » Thu 18 Apr 2013 10:35

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.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

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

Postby mlcmds » Mon 22 Apr 2013 09:40

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
mlcmds
 
Posts: 5
Joined: Mon 30 May 2011 12:02

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

Postby MariiaI » Tue 23 Apr 2013 10:22

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).
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

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

Postby mlcmds » Thu 16 May 2013 10:01

With the Oracle Express edition bundled with LinqConnect is optimistic concurrency approach supported as documented at http://www.devart.com/linqconnect/docs/ChangeConflictException.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
mlcmds
 
Posts: 5
Joined: Mon 30 May 2011 12:02

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

Postby MariiaI » Mon 20 May 2013 05:22

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

Also, please refer to http://www.devart.com/linqconnect/docs/?UpdateChecks.html
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17


Return to LinqConnect (LINQ to SQL support)