OceanBase数据有2种模式MySql和Oracle
SqlSugarCore
SqlSugarClient db = new SqlSugarClient(new ConnectionConfig() { DbType = DbType.MySql, ConnectionString = "server=localhost;Database=SqlSugar4xTest;Uid=root;Pwd=haosql;", IsAutoCloseConnection = true, //个别特殊的数据库需要禁用Nvarchar MoreSettings=new ConnMoreSettings() { DisableNarvchar=true } });
Optimizer Hints 可以用在SQL语句中改变执行计划,懂这个的用 , 不懂的就先不要看了
db.Queryable<Order>().Hints("/*+ ... */").ToList();
Oracle模式下只能支持ODBC方式连接(推荐MYSQL模式),只支持最基本的CRUD分页等,不支持建表操作
SqlSugar.OceanBaseForOracleCore //需要升级到5.1.4.92-preview14+ SqlSugarCore
字符串
Driver={OceanBase ODBC 2.0 Driver};Server=172.19.9.9;
Port=2883;Database=XIR_TRD;User=XIR_TRD@Xpia2C6G#obtest:1650773680;
Password=aaAA11%%;Option=3;
SqlSugarClient db = new SqlSugarClient(new ConnectionConfig() { DbType = DbType.OceanBaseForOracle, ConnectionString = "...", IsAutoCloseConnection = true, //个别特殊的数据库需要禁用Nvarchar //MoreSettings=new ConnMoreSettings() { DisableNarvchar=true } }); //需要升级到5.1.4.92-preview+
2016 © donet5.comApache Licence 2.0