A database connectivity solution for Oracle built over ADO.NET architecture.
||21 March, 2012
dotConnect for Oracle is an enhanced database connectivity solution built over ADO.NET architecture and a development framework. With state of the art ORM solutions such as Entity Framework and LINQ to SQL, it introduces new approaches for designing applications and boosts productivity of database application development.
* Flexible Connectivity
dotConnect for Oracle can connect both through OCI and directly over TCP/IP. Applications written with dotConnect for Oracle do not require installation of Oracle Client software.
* Database Application Development Extensions
dotConnect for Oracle has a rich set of design time tools that leverage the development process greatly. Particularly, there are convenient design time component editors, wizards and managers, DDEX, and much more.
* Oracle Advanced Features Support
dotConnect for Oracle allows developers to harness full capabilities of the Oracle server. dotConnect for Oracle supports such Oracle-specific features as Advanced Queuing, Alerts, Pipes, Direct Path Loading, Change notifications, REF cursors, objects, packages, and others.
* ORM Support
dotConnect for Oracle offers enhanced ORM support with a bundled visual designer for ORM models - Entity Developer. dotConnect for Oracle supports Entity Framework v1 and v4, NHibernate, and LinqConnect (formerly LINQ to Oracle) - our own ORM solution, closely compatible to Microsoft LINQ to SQL, while extending the functionality with its own features.
dotConnect for Oracle supports Dynamic database creation and deletion for both Entity Framework v1 and v4. It provides wide support for stored procedures, Oracle-specific functions and types. For best performance, dotConnect for Oracle offers you configurable Batch Updates support in SubmitChanges. Entity Framework v4.1 features - Code First and DbContext API are supported in a new DbContext template with fluent mapping generation.