DT071G - Programming in C# .NET

Development environment

• VS Code with the following extensions:
  • ms-dotnettools.csharp
  • jchannon.csharpextensions
• .NET 6.0 SDK
• ASP.NET Core Web API
• EF Core
• SQL Server
• SQL Server Management Studio (SSMS)

Setup

• Configure EF Core and add a database connection:
  • Create a database connection using SSMS.
  • Add the database connection string to appsettings.json or in a user-secret:

  "ConnectionStrings": {
    "DefaultConnection": "Data Source=(localdb)\\MSSQLLocalDB; Initial Catalog={db_name}; User ID={db_username}; Password={db_password};"
  }
  

  • Install EF tools: dotnet tool install --global dotnet-ef
  • Run the EF Core migrations: dotnet ef database update
• Add a signing key to appsettings.json or in a user-secret:

"TokenSettings": {
  "SigningKey": "{your_secure_signing_key_with_atleast_16_characters}"
}

• Run the application: dotnet run
• Test the application with Swagger: https://localhost:7177/swagger/index.html

Demo and essay

• Video demo
• Essay