Skip to content

support db

ansonzhang edited this page Dec 16, 2019 · 4 revisions

提醒

目前的单数据库,使用哪个,就把哪个Db 的 Enabled 设置为 true,其他的设置为 false。

Sqlite

appsettings.json 中配置:

  "Sqlite": {
    "Enabled": true,
    "SqliteConnection": "WMBlog.db"//只写数据库名就行,我会拼接字符串
  },


SqlServer(已测试版本:2008 R2 及以上)

appsettings.json 中配置:

 "SqlServer": {
   "Enabled": true,
   "SqlServerConnection": "Server=.;Database=WMBlogDB;User ID=sa;Password=123;",
   "ProviderName": "System.Data.SqlClient"
 },


LocalDB(已测试版本:MSSQL)

appsettings.json 中配置:

 "SqlServer": {
   "Enabled": true,
   "SqlServerConnection": "Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=wm;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False",
   "ProviderName": "System.Data.SqlClient"
 },


MySql(已测试版本:8.0.18 及以上)

appsettings.json 中配置:

  "MySql": {
    "Enabled": true,
    "MySqlConnection": "Server=localhost; Port=3306;Stmt=; Database=wmblogdb; Uid=root; Pwd=456;"
  },



入门指南

前端项目

交流与反馈

  • FAQ page is a good place to see whether your question is already asked.
  • Ask a question in cnblogs if you need help.
  • Submit an issue if you found a bug or have a feature request.
  • Open a pull request when you prepared to contribute. Before that, it is encouraged to open an issue to discuss.

更新日志

Clone this wiki locally