C#操作数据库

1. 添加命名空间System.Data.OracleClient引用
2. using System.Data.OracleClient;
3. 添加引用System.configuration
4.在app.config中添加配置

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  //连接数据库
    <connectionStrings>
        <add name="TestConn" connectionString="Data Source =(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)
             (HOST=127.0.0.1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)));Persist Security Info = True;User ID =scott ;Password=root;"/>
    </connectionStrings>
  
    <startup>
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.6.1" />
    </startup>
</configuration>

5.读取配置文件

private static readonly string ConnectionString = ConfigurationManager.ConnectionStrings["TestConn"].ConnectionString;

6.执行查询(首先安装Dapper)

/// <summary>
        /// Query 执行查询
        /// </summary>
        /// <typeparam name="T">泛型</typeparam>
        /// <param name="strSQL">SQL脚本</param>
        /// <param name="Parameters">参数</param>
        /// <returns>返回List</returns>
        public static List<T> Query<T>(string strSQL, object Parameters = null)
        {
            List<T> result = default;
            using (var con = new OracleConnection(ConnectionString))
            {
                con.Open();
                result = con.Query<T>(strSQL, Parameters).ToList();
                con.Close();
            }
            return result;
        }