sql - 如何在没有 Entity Framework 的情况下在 ASP.NET 中使用 Oracle 数据库？

Question

谁能用简单的方式告诉我，如何在我的 ASP.NET MVC 5 项目中使用 Oracle 数据库？我尝试了不同的文章，但没有得到明确的答案......

Answer 1

我认为这是做到这一点的简单方法:

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
                }
            }
        }