Category SQLite

Adding SQL localization data using an Angular 2 form and ASP.NET Core

This article shows how SQL localized data can be added to a database using Angular 2 forms which can then be displayed without restarting the application. The ASP.NET Core localization is implemented using Localization.SqlLocalizer. This NuGet package is used to save and retrieve the dynamic localized data. This makes it possible to add localized data […]

Creating and requesting SQL localized data in ASP.NET Core

This article shows how localized data can be created and used in a running ASP.NET Core application without restarting. The Localization.SqlLocalizer package is used to to get and localize the data, and also to save the resources to a database. Any database which is supported by Entity Framework Core can be used. Code: 2017.01.07: […]

Authorization Policies and Data Protection with IdentityServer4 in ASP.NET Core

This article shows how authorization policies can be used together with IdentityServer4. The policies are configured on the resource server and the ASP.NET Core IdentityServer4 configures the user claims to match these. The resource server is also setup to encrypt a ‘Description’ field in the SQLite database, so it cannot be read by opening the […]

ASP.NET Core 1.0 using SQL Localization

This article shows how to use SQL localization in ASP.NET Core using an SQL database. The SQL localization in the demo uses Entity Framework Core to access a SQLite database. This can be configured to use any EF core provider. Code: Library: NuGet package: 2016.11.22: Updated to .NET Core 1.1 2016.06.28: Updated […]

Experiments with Entity Framework Core and ASP.NET Core 1.0 MVC

The article shows some of the ways in which Entity Framework Core can be used together with ASP.NET Core 1.0 MVC. Both packages run on dotnet which makes it possible to run on Linux, Mac or Windows operating systems. The Entity Framework providers are implemented in separate data access projects using onion architecture. Code: […]

OAuth2 Implicit Flow with Angular and ASP.NET Core 1.1 IdentityServer

This article shows how to implement the OAuth2 Implicit Flow with an Angular client and IdentityServer4 hosted in ASP.NET Core 1.0. The code was built using the IdentityServer4.Samples. Thanks to everyone who helped in creating IdentityServer. Code: 2017.01.07: Updated to IdentityServer4 1.0.0 2016.12.18: Updated to IdentityServer4 rc5, ASP.NET Core 1.1 2016.12.04: Updated to IdentityServer4 […]

ASP.NET Core 1.1 with SQLite and Entity Framework Core

This article shows how to use SQLite with ASP.NET Core 1.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.07.01: Updated to VS2017 csproj and ASP.NET Core 1.1 2016.07.01: Updated to ASP.NET Core 1.0 RTM 2016.05.17: Updated to ASP.NET […]