Learning OData with Microsoft ASP.NET Core OData and Microsoft OData Client

• OData is short for Open Data Protocol

• OData Version 1 was developed by Microsoft 20xx

• Current version 4 (or 4.01) supports REST principles and exchange payload via JSON

• Libraries used

  • Microsoft.AspNetCore.OData: OData service implementation
  • Microsoft.OData.Client: OData client implementation
  • Microsoft.EntityFrameworkCore.Sqlite: Database access via Entity Framework Core to a SQLite database file.

Preparation

• Please make sure you configure the path to the database file in the Startup.cs or leave to 'C:\temp\world.db'. Hint: If you want to change the content in the SQLite file without installing any applications you could use SQLite Online. A great offline SQLite tool is SQLiteStudio.
• Install the OData Connected Service extension to generate or regenerate the code for the client.
• This project uses SwitchStartupProject for VS 2019 to start both applications in Visual Studio at the same time.
• To test the URL's you could also use the insomnia-export.json with the Insomnia HTTP client (or API testing tool).

OData Service Implementation

Manual steps

• Create the project ASP.NET Core WebApi for .NET Core 3.1 without HTTPS