Northwind CRM .NET 9.0 Migration

This is a .NET 9.0 Migration Example.

• Database: MSSQL SERVER
• Backend: WEB API, DB First, Entity Framework, Domain Driven Design.
• UI: React.

Northwind REST WEB Api

Run in terminal

cd ./src/NorthwindApi
dotnet run

VS Code Debug Options:

It will run in local chrome browser

• either with SSL at the link https://localhost:7251/swagger/index.html
• or without SSL at the link http://localhost:5205/swagger/index.html

To make it run like this please add fallowing two files under the \src\NorthwindApi\.vscode folde.

tasks.json:

{
  "version": "2.0.0",
  "tasks": [
    {
      "label": "build",
      "command": "dotnet",
      "type": "process",
      "args": [
        "build",
        "${workspaceFolder}/NorthwindApi.csproj"
      ],
      "group": {
        "kind": "build",
        "isDefault": true
      },
      "problemMatcher": "$msCompile"
    }
  ]
}

launch.json

{
    "version": "0.2.0",
    "configurations": [
        {
            "name": ".NET Core Launch (web)",
            "type": "coreclr",
            "request": "launch",
            "preLaunchTask": "build",
            "program": "${workspaceFolder}/bin/Debug/net9.0/NorthwindApi.dll",
            "args": [],
            "cwd": "${workspaceFolder}",
            "stopAtEntry": false,
            "serverReadyAction": {
                "action": "openExternally",
                "pattern": "\\bNow listening on:\\s+(https?://\\S+)",
                "uriFormat": "%s/swagger/index.html"
            },
            "env": {
                "ASPNETCORE_ENVIRONMENT": "Development"
            },
            "sourceFileMap": {
                "/Views": "${workspaceFolder}/Views"
            }
        }
    ]
}

Northwind REACT UI

Run in terminal

cd ./src/northwind-frontend
npm run dev -- -p 5206

VS Code Debug Options:

It will run in local: http://localhost:5206/

tasks.json:

{
    "version": "2.0.0",
    "tasks": [
      {
        "label": "npm: dev (port 5206)",
        "type": "shell",
        "command": "npm run dev -- -p 5206",
        "options": {
          "cwd": "${workspaceFolder}"
        },
        "problemMatcher": [],
        "group": {
          "kind": "build",
          "isDefault": true
        }
      }
    ]
  }
  

launch.json

{
    "version": "0.2.0",
    "configurations": [
      {
        "name": "Run React Dev Server",
        "type": "pwa-node",
        "request": "launch",
        "runtimeExecutable": "npm",
        "runtimeArgs": ["run", "dev", "--", "-p", "5206"],
        "console": "integratedTerminal",
        "cwd": "${workspaceFolder}"
      }
    ]
  }

Northwind MCP SERVER

Architecture

Run in terminal

cd ./src/NorthwindMcpServer
dotnet run

VS Code Debug Options:

It will run in local: http://localhost:5207/

tasks.json:

{
  "version": "2.0.0",
  "tasks": [
    {
      "label": "build",
      "command": "dotnet",
      "type": "process",
      "args": [
        "build",
        "${workspaceFolder}/NorthwindMcpServer.csproj"
      ],
      "group": {
        "kind": "build",
        "isDefault": true
      },
      "problemMatcher": "$msCompile"
    }
  ]
}

launch.json

{
    "version": "0.2.0",
    "configurations": [
        {
            "name": ".NET Core Launch (web)",
            "type": "coreclr",
            "request": "launch",
            "preLaunchTask": "build",
            "program": "${workspaceFolder}/bin/Debug/net9.0/NorthwindMcpServer.dll",
            "args": [],
            "cwd": "${workspaceFolder}",
            "stopAtEntry": false,
            "launchSettingsProfile": "http",
            "serverReadyAction": {
                "action": "openExternally",
                "pattern": "\\bNow listening on:\\s+(https?://\\S+)"
            },
            "env": {
                "ASPNETCORE_ENVIRONMENT": "Development"
            }
        }
    ]
}

VSCode Copilot mcp.json

{
    "servers": {
        "Northwind-http-mcp-server": {
            "url": "http://localhost:5207/"
        }
    }
}