DotNetDay18: Building Cross-Platform Server-Side Data APIs by Julie Lerman

DotNetDay18: Building Cross-Platform Server-Side Data APIs by Julie Lerman

Front ends are cool but mostly useless without data. Sure, some of your data sources provide REST APIs so you can just write queries directly against them but that is so old school. Instead, you can build back end APIs that address the specific data needs of your web application and relieve front end devs from tangling with database schema, query syntax and other distractions. In this session you’ll learn the basics of creating a back end API as well as some smart architectural guidance to make moving data between your front end and your data store. We'll start with an ASP.NET Core Web API, EF Core and a relational database, then look at a data API built with Azure Functions to support a Cosmos DB document database.



May 29, 2018


  1. Building Cross-Platform Server-Side Data APIs Julie Lerman @julielerman

  2. None
  3. Two Types of Data APIs ASP.NET Core Web API “Demo-ware”

    à Better architectural practices ASP.NET Core 2.1, EF Core 2.1, SQLite Serverless Data API Azure Functions via Azure Portal Integrate with Azure Cosmos DB
  4. Character Quote Entrance 1:* 1:1 Web API Domain Model


  6. üCreate a new character with just a name üCreate a

    new character with name and entrance üInsert a full character graph as a [valid] JSON object üAdd a quote to an existing character üAdd or replace an entrance to an existing character üRetrieve a list of character names with ID üRetrieve a full set of data for a single character Actions I Want My API to Enable
  7. A Trio of Azure Functions HTTPTrigger Body: Phone # Output

    to Collection 1: SampsonAte Collection 2: Subscribers HTTPTrigger Body: He Ate! Output to Cosmos DB Trigger Read from subscriber collection SMS to subscribers Cosmos DB Database
  8. Resources The code from this demo will be at

    Julie’s Pluralsight Author Page (newest courses: EF Core 2: Getting Started, EF Core 2: Mappings) ASPNetCore: EF Core: January 2018 MSDN Magazine Data Points column: Creating Azure Functions to Interact with Cosmos DB Azure CosmosDb: Azure Functions: Julie Lerman @julielerman