web-development-course

Setup

# Clone the repo
git clone git@github.com:baradm100/web-development-course.git
cd web-development-course

# Install the ef tool
dotnet tool install --global dotnet-ef

# Install packages
dotnet restore

Run Migrations

dotnet ef database update

Add New Migration

dotnet ef migrations add InitialCreate

Run In Watch Mode

dotnet watch run

UML

Link

Connection Strings

We set under appsettings.Development.json a connection string to our local DBs, in order to run on the remote DB we just need to delete the ConnectionStrings segment

Local DB Connection String

Server=(localdb)\\mssqllocaldb;Database=aspLearningDB;Trusted_Connection=True;MultipleActiveResultSets=true

When Running MSSQL In A Container

Server=localhost;Database=aspLearningDB;User ID=sa;Password=yourStrong(!)Password

Backups & Restores

We're using this tool to create backups and restore the DB: sqribe.

How To Backup

For mac just run:

sqribe backup /data_source:"server=db.cs.colman.ac.il;User ID=csdb13a;Password=********;Database=CsDB13;" /objects:"all" /output_path:"~/Desktop/sqribe-backup"

How To Restore

For mac just run:

sqribe restore /script_path:"~/Desktop/sqribe-backup" /data_source:'Server=localhost;Database=aspLearningDB;User ID=sa;Password=yourStrong(!)Password;' /objects:"all"

For Windows just run:

sqribe restore /script_path:".\sqribe-backup"  /data_source:"Server=(localdb)\\mssqllocaldb;Database=aspLearningDB"