4 support db

ansonzhang edited this page 2019-12-16 13:21:36 +08:00

Unescape Escape

Table of Contents

• 提醒
• Sqlite
• SqlServer（已测试版本：2008 R2 及以上）
• LocalDB（已测试版本：MSSQL）
• MySql（已测试版本：8.0.18 及以上）

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

提醒

目前的单数据库，使用哪个，就把哪个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;"
  },

入门指南

• 框架说明

• 快速运行

• 主要知识点

  • AOP
  • Appsettings
  • Async-Await
  • Authorization-Ids4
  • Authorization-JWT
  • AutoMapper
  • CORS
  • DI-AutoFac
  • DI-NetCore
  • Filter
  • GlobalExceptionsFilter
  • HttpContext
  • Log4
  • MemoryCache
  • Middleware
  • MiniProfiler
  • publish
  • Redis
  • Repository
  • SeedData
  • SignalR
  • SqlSugar
  • SqlSugar-Codefirst&DataSeed
  • SqlSugar-SqlAOP
  • Swagger
  • T4
  • Test-xUnit
  • Temple-Nuget

• API 地址

前端项目

• Blog.Vue
• Blog.Admin
• Nuxt.tibug

交流与反馈

• 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.

更新日志

• Change Log

有疑问，请自行查看博客园文章：https://www.cnblogs.com/laozhang-is-phi/p/9495618.html#autoid-1-0-0

或者加 QQ 群：867095512