C#_SqlHelper

C#_sql使用助手

1.连接sqlserver，引入命名空间

using System.Data.SqlClient;

using System.Data;

2.连接oracle，引入包：Oracle.ManagedDataAccess.Client

using Oracle.ManagedDataAccess.Client;

 3.连接PgSql，引入包：Npgsql（注：使用4.1.9低版本，否则会报一堆找不到包的错）

using Npgsql;

class SqlHelper
    {
        //sqlserver数据库连接配置
        private static string connString = "Data Source=xxx.xxx.xxx.xxx;Initial Catalog=xxxxxx;User Id=xxxx;Password=xxxx";
        //oracle数据库连接配置
        private static string oracleConnString = "Data Source=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_