gantrim

/* ESP Server receive and parse JSON
 
*/
#include "WiFiEsp.h"
#include <ArduinoJson.h>

#ifndef HAVE_HWSERIAL1
#include "SoftwareSerial.h"

// set up software serial to allow serial communication to our TX and RX pins

gantrim

# Create a Docker container using the microsoft/mssql-server-linux:2017-latest
# Automatically accept the EULA, set the password to <StrongPasswordYouSet> <-- Change this!
# for the sa user, and map port container port 1433 to host port 1433
docker run --name sql \
-e 'ACCEPT_EULA=Y' \
-e 'SA_PASSWORD=<StrongPasswordYouSet>' \
-p 1433:1433 \
-d microsoft/mssql-server-linux:2017-latest

gantrim

##### Useful Docker Commands #####

# List all containers
docker ps -a

# List Images that you've pulled down
docker image list

# Stop a container (replace <CONTAINER_NAME> with the name of your container
docker stop <CONTAINER_NAME>

gantrim

// Attempt # 1
{
	"ConnectionStrings": {
		"TestingDatabase": "Server=localhost:1433\\Database=<YourDatabaseName>;User=SA;Password=<StrongPasswordYouSet>;"
	}
}

// Attempt #2 - Specify sqlexpress as database
{
	"ConnectionStrings": {

gantrim

USE master
SELECT t1.name AS [Schema], t2.name AS [Table]
FROM sys.schemas t1
       INNER JOIN sys.tables t2 ON t2.schema_id = t1.schema_id
ORDER BY t1.name, t2.name

gantrim

{
	"ConnectionStrings": {
		"TestingDatabase": "Server=localhost:1433\\Database=<YourDatabaseName>;User=SA;Password=<StrongPasswordYouSet>;"
	}
}

gantrim

{
	"ConnectionStrings": {
		"TestingDatabase": "Server=localhost:1433\\sqlexpress;Database=<YourDatabaseName>;Trusted_Connection=True;User=SA;Password=<StrongPasswordYouSet>;"
	}
}

gantrim

{
	"ConnectionStrings": {
		"TestingDatabase": "Server=localhost,1433\\Database=<YourDatabaseName>;User=SA;Password=<StrongPasswordYouSet>;"
	}
}

gantrim

{
	"ConnectionStrings": {
		"TestingDatabase": "Server=localhost,1433\\Catalog=<YourDatabaseName>;Database=<YourDatabaseName>;User=SA;Password=<StrongPasswordYouSet>;"

	}
}

gantrim

# Change to your project directory
cd <Your_Solution_Directory>/<Your_Project_Directory>

# Add entity framework core packages
dotnet add package Microsoft.EntityFrameworkCore.SqlServer
dotnet add package Microsoft.EntityFrameworkCore.Design