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

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

ASP.NET I [ASPNET_INTRO]

Next courses

ASP.NET - Application development in Blazor [ASPNET_BLAZOR]

Security in ASP.NET Applications [GOC3314]

Parallel, Asynchronous and Multithreaded Applications [GOC407]