Skip to content

Instantly share code, notes, and snippets.

@booyaa
Created June 7, 2013 11:07
Show Gist options
  • Select an option

  • Save booyaa/5728562 to your computer and use it in GitHub Desktop.

Select an option

Save booyaa/5728562 to your computer and use it in GitHub Desktop.
Oracle + EF = BFF

Assumptions Oracle drivers are already configured. ODAC maybe a little different...

###Install EF

PM > Install-Package EntityFramework

###Add a connection to Oracle Server Explorer > Add new database connection (we'll assume TNSNAMES is configured correctly) Change the data source to Oracle (obvs)

Server: TNSNAME (the assumption is that your ConnString looks like this Data Source=tnsname_db_source;User ID=foo;Password=bar;Provider=OraOLEDB.Oracle.1;UseSessionFormat=True

UserName/Password same as connection string

###Wire up to EF

###Test code

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment