Steeltoe Documentation
  • Why Steeltoe
    Overview Microservices Cloud Web Applications Event Driven
  • Get Started
    Steeltoe Initializr Guides Documentation API Browser Blog
  • Projects
    Steeltoe Application Configuration Steeltoe Circuit Breakers Steeltoe Dynamic Logging Steeltoe Management Steeltoe Messaging Steeltoe Network File Shares Steeltoe Security Steeltoe Service Connectors Steeltoe Service Discovery Steeltoe Stream
  • Support
  • Community
Search Results for

    Table of Contents
    . . .

    Using Service Connectors with Microsoft SQL

    This tutorial takes you through setting up a .NET Core application with the Microsoft SQL service connector.

    Note

    For more detailed examples, please refer to the SqlServerEFCore project in the Steeltoe Samples Repository.

    First, start an MsSQL instance using the Steeltoe dockerfile.

    docker run --env ACCEPT_EULA=Y --env SA_PASSWORD=Steeltoe123 --publish 1433:1433 steeltoeoss/mssql
    

    Next, create a .NET Core WebAPI that interacts with MS SQL

    1. Create a new ASP.NET Core WebAPI app with the Steeltoe Initializr Steeltoe Initialzr - MS SQL Connector

    2. Name the project "MsSqlConnector"

    3. Add the "Microsoft SQL Server" dependency

    4. Click Generate to download a zip containing the new project

    5. Extract the zipped project and open in your IDE of choice

    6. Set the instance address in appsettings.json

      {
        "sqlserver": {
          "credentials": {
            "server": "127.0.0.1",
            "port": "1433",
            "username": "sa",
            "password": "Steeltoe123"
          }
        }
      }
      
      Tip

      Looking for additional params to use when connecting? Have a look at the docs

    Run the application

    • .NET cli
    • Visual Studio
    dotnet run <PATH_TO>\MsSqlConnector.csproj
    

    Navigate to the endpoint (you may need to change the port number) http://localhost:5000/api/values

    1. Choose the top Debug menu, then choose Start Debugging (F5). This should bring up a browser with the app running
    2. Navigate to the endpoint (you may need to change the port number) http://localhost:8080/api/values

    Once the app loads in the browser you will see a list of the default sys tables installed with MS SQL. "["spt_fallback_db","spt_fallback_dev","spt_fallback_usg","spt_values", "spt_monitor","MSreplication_options"]"

    X
    • Edit this page