Category Entity Framework

EF Core diagnosis and features with MS SQL Server

This article shows how Entity Framework Core messages can be logged, and compared using the SQL Profiler and also some of the cool new 1.1 features, but not all. All information can be found on the links at the bottom and especially the excellent docs for EF Core. Code: https://github.com/damienbod/EFCoreFeaturesAndDiag project.json with EF Core packages […]

IdentityServer4, Web API and Angular in a single ASP.NET Core project

This article shows how IdentityServer4 with Identity, a data Web API, and an Angular SPA could be setup inside a single ASP.NET Core project. The application uses the OpenID Connect Implicit Flow with reference tokens to access the API. The Angular application uses webpack to build. Code: VS2017 msbuild | VS2015 project.json 2017.02.15: Updated to […]

Setting the NLog database connection string in the ASP.NET Core appsettings.json

This article shows how the NLog connection string for the DatabaseTarget can be configured in the appsettings.json in an ASP.NET Core project and not the XML nlog.config file. All the NLog target properties can be configured in code if required and not just in the NLog XML configuration file. Code: VS2017 RC3 csproj | VS2015 […]

Implementing UNDO, REDO in ASP.NET Core

The article shows how to implement UNDO, REDO functionality in an ASP.NET Core application using EFCore and MS SQL Server. This is the first blog in a 3 part series. The second blog will implement the UI using Angular 2 and the third article will improve the concurrent stacks with max limits to prevent memory […]

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 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: https://github.com/damienbod/AspNet5Localization Library: https://github.com/damienbod/AspNet5Localization/tree/master/src/Localization.SqlLocalizer NuGet package: https://www.nuget.org/packages/Localization.SqlLocalizer/ Posts in this series ASP.NET Core MVC Localization […]

ASP.NET Core with PostgreSQL and Entity Framework Core

This article shows how to use PostgreSQL with ASP.NET Core 1.0 using Entity Framework Core. Code: VS2017 msbuild | VS2015 project.json Posts in this series: Experiments with Entity Framework Core and ASP.NET Core MVC ASP.NET Core with PostgreSQL and Entity Framework Core ASP.NET Core with MySQL and Entity Framework Core 2017.02.10: Updated to VS2017 and […]