sql-connectionStrings

<connectionStrings>
  <add name="ClassReservatConnectionString" connectionString="server=localhost;user id=root;password=123456;database=classreservat;" providerName="System.Data.SqlClient" />
</connectionStrings>

   dbhelper

  "Dbs": {
    //"DbType": "Oracle",
    //"Connection": "Data Source=192.168.1.10/orcl;User ID=c##v3_base;Password=c##v3_base"
    "DbType": "MySql",
    "Connection": "server=www.wskxy.xyz;port=3306;user=hdf;password=123;database=hoteldb;"
    //"DbType": "SqlServer",
    //"Connection": "server =148.70.176.58;uid=kxy;pwd=Aa1234567;database=dbHelper"
  }

分页:

  Oracle:rownum

  Mysql:limit

  SqlServer:top

原文地址:https://www.cnblogs.com/wskxy/p/9206347.html