Connecting from .net windows form(stand alone application) to oracle database

I am trying to connect from .net windows application to oracle database. Do we have to install oracle cl开发者_如何学Goient in every system where the application is running to connect to the remote oracle database..

Thanks in advance

You need to go and grab the Oracle Data Provider which will enable you to query Oracle databases using standard ADO.NET access patterns.

You don't need to "install" it, but you do have to provide the appropriate DLLs with your assembly.

You will need to have either the full Oracle database client installed (or the instant client) on each workstation in order to communicate with an Oracle database server.

This is completely separate to the "OracleClient" ADO.net classes.

Check answers to question: Connection C# to Oracle for list of possible solutions for interfacing to Oracle.