ASP.NET Core Database Programming

Enterprise database application development with ASP.NET Core, Entity Framework Core, ADO.NET and Object Relational Mapping (ORM), interacting with different data-sources including SQL, NoSQL, SQLite, MySQL, JSON, XML, Excel and etc.

Note: This is a work-in-progress book project, based on the latest stabled version of the framework. As in any work-in-progress project, frequent updates are expected.

Part-1: Introduction

  • Ch01: Introduction
    • Why ASP.NET Core
    • Pros
    • Cons
    • Prerequisites
  • Ch02: Data, data-management and databases
    • Data
    • Data security and privacy
    • Confidentiality, Integrity and Availability (CIA)
    • Data management
    • Data sources
    • Databases
  • Ch03: Database programming intro
    • Application is all about data
    • Structured and un-structured data
    • SQL and NoSQL
    • Databases 101
    • LINQ
    • Structured Query Language (SQL)
  • Ch04: Development environment
    • Windows 10 workstation
    • Visual Studio 2019
    • SQL Server Management Studio (SSMS)
    • Azure Data Studio
    • Visual Studio Code
    • Postman

Part-2: Foundation Knowledge

  • Ch05: ASP.NET Core Fundamentals
    • HTTP request and response
    • Middleware
    • Routing
    • Configuration
    • Security & data-access control
    • Debugging
    • Logging
    • Design patterns
      • Dependency injection
      • Option
      • Repository
  • Ch06: Data Sources
    • Microsoft SQL Server
    • LocalDB
    • Azure SQL database
    • MySQL
    • MariaDB
    • PostgreSQL
    • SQLite
    • CosmoDB
    • Other data sources
  • Ch07: Database programming 101
    • Connect to data sources
    • Entity Framework Core
    • ADO.NET
    • Object Relational Mapping (ORM)
    • LINQ
    • Structured Query Language (SQL)

Part-3: Database Application

  • Ch08: N-tier layered data access
    • Loosely coupled design
    • Normalized data
    • Don't trust the data
    • Data security checkpoints
    • Data privacy checkpoints
  • Ch09: Data Service Providers (WebAPI)
    • Entity Framework Core data service provider
    • ADO.NET data service provider
    • Using object relational mapping (ORM)
    • Testing WebAPI with Postman
  • Ch10: Data Consumers
    • JavaScript client
    • ASP.NET Webform client
    • ASP.NET Core MVC client
    • ASP.NET Core Razor client
    • Blazor server-side client
    • Blazor WebAssembly client

Part-4: Securing & Monitoring Data Access

  • Ch11: Securing data access
    • HTTPS
    • ASP.NET Core Identity
    • Authentication
    • Authorization
    • JSON Web tokens
    • Multi factor authentication
    • Data encryption
  • ch12: Logging and monitoring
    • Debugging and Logging
    • Monitoring and Logging
  • Ch13: External and third-party authentication
    • Facebook authentication
    • Google authentication
    • Twitter authentication
    • Azure AD authentication