Accessing data from .NET

• Knowledge of C# programming at the GOC2125 course level
• Knowledge at ASPNET_INTRO, ASPNET_ADV or DOTNET_DB course level

• Expert commentary with practical demonstrations, computer exercises.

• Presentation of the material covered in printed or online form.

• .NET and relational databases

  • Entity Framework Core - model creation
    • Code First
    • Database First
    • Code second - taking an existing model into EF
  • Migration
    • Migration from command line and Visual Studio
    • Migration at application startup, generation of migration SQL batch
    • Migration editing, data transformation
    • Seeding data, populating dials
  • EF Core as database abstraction
    • Introduction to embedded database Sqlite, when to use it and when not to use it
    • Database independence - applications working against MS SQL and Sqlite
    • Backing up Sqlite database files
  • More advanced use of EF Core
    • Mapping to JSON structures
    • Mapping to stored procedures
    • General use of stored procedures from EF
  • Full-text search in Microsoft SQL Server
    • General operation of fulltext indexes in MS SQL
    • Query language for fulltext
    • Google-like syntax translator
    • Connection to Entity Framework

• .NET and non-relational data

  • Binary data storage
    • Storing binary data in a database
    • Storing binary data in the file system
    • Storing binary data in Azure Blob Storage
    • Using SAS (Shared Access Signatures)
    • FluentStorage - an abstraction for storing binary data and why to use it
  • Storing semistructured data - Azure Table Storage
  • Working with queues - Azure Queue Storage

Previous courses

ASP.NET I [ASPNET_INTRO]

Creation of database applications using ORM (Entity Framework) [DOTNET_DB]

Next courses

Introduction to MongoDB [MONGODB_INTRO]

Communication with server using AJAX and Fetch API [JS_AJAX]

DOM in JavaScript II: Advanced Techniques [JS_DOM2]

Angular I: Basics [JS_ANGULAR1]

Asynchronous and reactive programming in JavaScript [JS_ASYNC]

React I: Basics [JS_REACT1]

Introduction to Vue.js [JS_VUE1]

TypeScript - type checker for JavaScript [JS_TS1]

jQuery Framework [JS_JQUERY]

Creating JS applications using the WebSocket protocol [JS_WEBSOCKET]

Automated testing of JS applications using the Jest library [JS_TEST_JEST]

Introduction to the Svelte framework [JS_SVELTE1]

Introduction to Solid.js framework [JS_SOLID1]

Parallel, Asynchronous and Multithreaded Applications [GOC407]

Security in ASP.NET Applications [GOC3314]

ASP.NET - Application development in Blazor [ASPNET_BLAZOR]