SqlServerEFCore

SQL Server Connector Sample App - Entity Framework Core

ASP.NET Core sample app illustrating how to use Entity Framework Core together with Steeltoe SQL Server Connector for connecting to a Microsoft SQL Server service on CloudFoundry.

General prerequisites

1. Installed .NET Core SDK

Running locally

1. Optional: Updated your connection string in appsettings.development.json under SqlServer:Credentials:ConnectionString if not using LocalDB

Running on CloudFoundry

1. Installed CloudFoundry (optionally with Windows support)
2. Installed VMware Tanzu Cloud Service Broker

Create SQL Server Service Instance on CloudFoundry

You must first create an instance of the SQL Server service in an org/space.

1. cf target -o your-org -s your-space
2. cf create-service csb-azure-mssql small-v2 mySqlServerService

Alternatively, when using a user-provided service instead (replace values between pipes as appropriate):

1. cf target -o your-org -s your-space
2. cf cups mySqlServerService -p '{\"pw\": \"|password|\",\"uid\": \"|user id|\",\"uri\": \"jdbc:sqlserver://|host|:|port|;databaseName=|database name|\"}'

Publish App & Push to CloudFoundry

1. cf target -o your-org -s your-space
2. cd samples/Connectors/src/SqlServerEFCore
3. Push the app
   • When using Windows containers:
     • Publish app to a local directory, specifying the runtime:
       • dotnet restore --configfile nuget.config
       • dotnet publish -r win-x64 --self-contained
     • Push the app using the appropriate manifest:
       • cf push -f manifest-windows.yml -p bin/Debug/net6.0/win-x64/publish
   • Otherwise:
     • Push the app using the appropriate manifest:
       • cf push -f manifest.yml

Note: The provided manifest(s) will create an app named sqlserverefcore-connector and attempt to bind the app to SQL Server service mySqlServerService.

What to expect - CloudFoundry

To see the logs as you startup and use the app: cf logs sqlserverefcore-connector

On a Windows cell, you should see something like this during startup:

2016-07-01T07:27:49.73-0600 [CELL/0]     OUT Creating container
2016-07-01T07:27:51.11-0600 [CELL/0]     OUT Successfully created container
2016-07-01T07:27:57.73-0600 [APP/0]      OUT Hosting environment: development
2016-07-01T07:27:57.73-0600 [APP/0]      OUT Content root path:  /home/vcap/app
2016-07-01T07:27:57.73-0600 [APP/0]      OUT Now listening on: http://*:8080
2016-07-01T07:27:57.73-0600 [APP/0]      OUT Application started. Press Ctrl+C to shut down.

This sample will be available at http://sqlserverefcore-connector.[your-cf-apps-domain]/.

Upon startup, the app inserts a couple of rows into the bound SQL Server database. They are displayed on the home page.

---

See the Official Steeltoe Service Connectors Documentation for a more in-depth walkthrough of the samples and more detailed information.