How configure on SqlServer

[iamoldli]

How configure on SqlServer

[iamoldli]

In src/WebHost/conifg/db.json file，the Dialect property can configure database type，

0:SqlServer 1:MySql 2:SQLite

{
  "Logging": true,
  "Connections": [
    {
      "Name": "Admin",
      "Dialect": 0,
      "Database": "Nm_Admin",
      "ConnString": "Server=.;Database=Nm_Admin;Uid=sa;Pwd=sa;MultipleActiveResultSets=true;"
    },

[mtugnoli]

Thank you for your answer, but how create tables ?
I try to run on Visual Studio 2019 (in debug mode), but I see only a blank page
on http://localhost:5000/api/values

[iamoldli]

You should create the database first, the database file is in data directory，for sqlserver：data\SqlServer

Because the project is Front-end and Back-end separation, so you have to start the Front-end and back-end .

For Back-end, you can start the WebHost in visual studio， or open WebHost directory and powershell ,run dotnet watch run，then you can open http://localhost:6220/swagger/index.html and see the api document.

For Front-end, you need had install node.js, then open WebUI directory and run the following command

npm install
npm run serve

now, open http://localhost:5220

My English is not very good, please forgive me~