How to use Oracle Database in ASP.NET without Entity Framework?

Can someone tell me in a simple way how can I use Oracle db in my ASP.NET MVC 5 project? I'm tired of searching all the sites and I don't have a clear answer ...

+3


source to share


1 answer


I think this is an easy way to do it:



using System.Data.OracleClient;

        public string GetConnectionString()
        {
            String connString = "SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=YourHostName)(PORT=YourPort))(CONNECT_DATA=(SERVICE_NAME=YourServiceName)));uid=YourUserId;pwd=YourPassword;";
            return connString;
        }

        public void ConnectingToOracle()
        {
            string connectionString = GetConnectionString();
            using (OracleConnection connection = new OracleConnection())
            {
                connection.ConnectionString = connectionString;

                connection.Open();

                OracleCommand command = connection.CreateCommand();
                string sql = "select * from MyDatabase where name like '%John Paul%'";
                command.CommandText = sql;

                OracleDataReader reader = command.ExecuteReader();
                while (reader.Read())
                {
                    string myField = (string)reader["address"]; //Get the address of John Paul
                }
            }
        }

      

+4


source







All Articles