Click here to Skip to main content
15,566,065 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi
I am working on WCF + Oralce database.

can anyone tell me how can i implment Oracle data access in Wcf. If possible can anyone send the resource links or code

Requirement : Asp.net(Client) ---> (WCF ---- DataAccess Layer --- Oracle Database)

Thanks,
Mani
Posted

1 solution

Hi,

Microsoft has a sample entity framework against Oracle database, see http://archive.msdn.microsoft.com/EFOracleProvider[^]. However it uses the deprecated System.Data.OracleClient api so it could be a good idea to convert it to use ODP.NET instead.

On the other hand Oracle has recently published a beta version of ODAC Entity Framework. It's still beta but looks very promising. You can have a closer look at here: http://www.oracle.com/technetwork/topics/dotnet/index-085163.html[^]. This supports wider range of Oracle's functionality.
 
Share this answer
 
Comments
Member 1258299 6-Apr-11 16:45pm    
HiI got it, but i dont want to use EF 4.0, i want to write simeple WCF serverice using Ado.net + Oracle
Wendelius 6-Apr-11 16:52pm    
Ok, so in that case I'd guess you have to do the DAL operations 'manually'. You add necessary references to the project, create a OracleConnection, OracleCommand, OracleDataReader etc (depending what the WCF service does) and use them to do the necessary steps. Is the problem that you're not familiar with ADO.NET.

Additional note: I think you should use ODP.NET. Microsoft isn't going to continue providing Oracle connectivity in .Net Framework directly so ODP.NET is replacing it.
Member 1258299 11-Apr-11 11:39am    
Thanks for you reply. Can you send some of the sample code and resource links
Wendelius 11-Apr-11 16:08pm    
ODP.NET documentation, examples and the package can be found here: http://www.oracle.com/technetwork/topics/dotnet/index-085163.html When you install it, there should be a directory containing several samples. And if I recall correctly those samples are also discussed in the documentation.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900