Connecting with oracle without any dll reference

Question

Is it possible to connect asp.net with oracle database without adding or referring any DLL?. Please give any example.

ramji · Answer

Now i am trying to ASP.NET wiht oracle using oracle provider for oledb.I am using below connection string in web.config using System.Data.OleDb; namespace Test.Models { public class BaseDAL { string ConnectionString = ConfigurationManager.ConnectionStrings["Oracledb"].ToString(); public int Testoracle() { try { OleDbConnection myConnection = new OleDbConnection(ConnectionString); int recCount = 0; myConnection.Open(); return recCount; } catch (Exception ex) { throw ex; } finally { } } } } when i debug the above code it is showing error message "System.InvalidOperationException: The 'OraOLEDB.Oracle' provider is not registered on the local machine" . and connection is not established.But above dll is in my machine.

Mangesh G · Answer

Try entity framework where u can connect without using the Oracle dll

ramji · Answer

In this Link they are adding and referencing the "Oracle.DataAccess.dll." Is it possible to connect with oracle without adding any reference DLL.?

Mangesh G · Answer

http://www.c-sharpcorner.com/UploadFile/01a5f9/connect-the-oracle-database-server-without-oracle-client/ check this

Connecting with oracle without any dll reference

Answers (4)