.Net 使用SqlSugar连接Oracle数据库

1、添加SqlSugar引用

2、添加Oracle.ManagedDataAccess引用

3、在Web.config配置数据库连接

 <connectionStrings>
    <add name="DefaultConnection" connectionString="Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\aspnet-test-20190316013328.mdf;Initial Catalog=aspnet-test-20190316013328;Integrated Security=True" providerName="System.Data.SqlClient" />
    <add name="default" providerName="Oracle.ManagedDataAccess.Client" connectionString="Data Source=127.0.0.1:1521/lis;User ID=sa;Password=123456" />
  </connectionStrings>

或者可以指向路径下的配置文件

 <connectionStrings configSource="Configs\connectionStrings.config" />

在Configs文件夹下面的connectionStrings.config配置数据源

<connectionStrings>
    <add name="DefaultConnection" connectionString="Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\aspnet-test-20190316013328.mdf;Initial Catalog=aspnet-test-20190316013328;Integrated Security=True" providerName="System.Data.SqlClient" />
    <add name="default" providerName="Oracle.ManagedDataAccess.Client" connectionString="Data Source=127.0.0.1:1521/lis;User ID=sa;Password=123456" />
</connectionStrings>

4、SqlSugar

 public  class Sqlhelp
    {
        public SqlSugarClient db;
        public Sqlhelp()
        {
            db = new SqlSugarClient(new ConnectionConfig()
            {
                ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["default"].ConnectionString,
                DbType = DbType.Oracle,//数据库类型
                InitKeyType = InitKeyType.Attribute,//从特性读取主键和自增列信息
                IsAutoCloseConnection = true,//开启自动释放模式和EF原理一样我就不多解释了
            });
        }  
    }