Category SQLite

OAuth2 Implicit Flow with AngularJS and ASP.NET Core 2.0 IdentityServer4

This article shows how to implement the OAuth2 Implicit Flow with an AngularJS client and IdentityServer4 hosted in ASP.NET Core 1.1. The code was built using the IdentityServer4.Samples. Thanks to everyone who helped in creating IdentityServer. Code: History: 2017-08-15: Updated ASP.NET Core 2.0, Angular 4.3.6 Full history: Other posts in this series: OAuth2 […]

ASP.NET Core 2.0 with SQLite and Entity Framework Core

This article shows how to use SQLite with ASP.NET Core 2.0 using Entity Framework Core. EF Core can now create SQLite databases using Entity Framework migrations which was not possible in previous versions. Code: 2017-08-17: Updated to ASP.NET Core 2.0 and EF Core 2.0 2017-02-02: Updated to VS2017 csproj with EF Core msbuild 2017-07-01: […]

Web API OData V4 Using a Singleton Part 7

This post is part 7 of the Web API and OData V4 series. This article demonstrates how to use an OData singleton with Web API. The singleton class has a list of child entities which is used to select contained entities from the SQLite database. Part 1 Getting started with Web API and OData V4 […]

Web API OData V4 Using Contained Models Part 6

This post is part 6 of the Web API and OData V4 series. This article shows how Web API 2.2 with OData V4 can use contained EntityTypes in an OData model without defining the entities on the top level. In this example, the Player entity is the route entity set. The PlayerStats can then be […]

Web API OData V4 Using Unity IoC, SQLite with EF6 and OData Model Aliasing Part 5

This post is part 5 of the Web API and OData V4 series. This article shows how Web API 2.2 with OData V4 can be used together with Unity as an IoC, Entity Framework with SQLite for persistence and also creates an OData service which can do CRUD operations. OData Model Aliasing features are used […]

SignalR Message Buffers with SQLite

This post demonstrates how to set up a very basic message queue using SignalR with SQLite. This could be used to collect data from a measurement system or a client which is not always online but no data messages should be lost or the sequence of the messages. Code: Only the client contains a […]

using SQLite with Entity Framework 6 and the Repository Pattern

In this post, a Data access layer is implemented using the repository pattern together with entity Framework 6 and SQLite as a database. The post continues on from Getting started, using SQLite with .NET UPDATE 02.03.2014: Using the new SQLite version now with the SQLite provider. The xml app configuration needs to be changed […]