Posts

Showing posts with the label Oracle

ODP(Oracle Data Provider) Entity Framework and LINQ to Entities Installation Instructions, Setup, and Notes

Image
Hi All, I would like to share my experience of using Microsoft Entity Framework with Oracle Database.The main goal is using advance .Net Data Driven Architecture in Oracle. You can create Entity Data Model (EDM) from existing Oracle Database Schema by Entity Data Model Wizard or run LINQ query against database or call stored procedure . Oracle releases beta version of ODAC 11.2.0.2.30 (follow http://www.oracle.com/technetwork/topics/dotnet/downloads/odacefbetainstallinstructions-302527.html if the url is out-of-the date please ask google.com :)).This provider supports Microsoft Visual Studio 2010 with SP1. You can download and install easily.There is no serious problem during installation or integrating with Visual Studio Family.Just verify that C:\app\user>\product\11.2.0\client_ \Oracle.Key file has correct value.(ex path; C:\app\MuhammetATALAY\product\11.2.0\client_2) Here is step by step instruction: 1- Add New ADO.NET Entity Dta Model by right click project - Add - New Item 2-