Skip to main content
use-nancyfx-in-aspnet-core

Use NancyFx in ASP.NET Core

NancyFx is a lightweight, low-ceremony, framework for building HTTP based services on .NET and Mono. The goal of the framework is to stay out of the way as much as possible and provide a super-duper-happy-path to all interactions. Advantage of NancyFx is, it prefers conventions over configuration and supports DELETE, GET, HEAD, OPTIONS, POST, PUT and PATCH requests and provides a simple and elegant way to return response with just a couple of keystrokes. In this post, let’s find out how to use NancyFx in ASP.NET Core. (more…)

Read More

Shadow Properties with Entity Framework Core

How to use Shadow Properties with Entity Framework Core

As mentioned in my earlier post Quick summary of what’s new in Entity Framework Core 1.0, “Shadow Properties” is one of the new feature of Entity Framework Core. Shadow Properties are fields which are not part of your entity class so they don’t exist in your class but they do exist in entity model. In this post, let’s find out how to use shadow properties in Entity Framework Core. (more…)

Read More

Use HiLo to generate keys with Entity Framework Core

Use HiLo to generate keys with Entity Framework Core

Entity Framework Core supports different key generation strategies like identity, Sequence and HiLo. In my previous post, I talked about using SQL Server Sequence with EF Core to Create Primary Key. Database sequences are cached, scalable and address concurrency issues. But there would be a database round-trip for every new the sequence value. And in case of high number of inserts this becomes a little heavy. But you can optimize the sequence with HiLo pattern. And EF Core supports “HiLo” out of the box. So in this post, we will see how to use HiLo to generate keys with Entity Framework Core. (more…)

Read More

Use SQL Server Sequence in Entity Framework Core to Create Primary Key

Use SQL Server Sequence in Entity Framework Core to Create Primary Key

Entity Framework doesn’t support Sequence out of the box. However, there are ways to use it. But the good news is, Entity Framework Core supports Sequence out of the box. I also mentioned in my earlier post Quick summary of what’s new in Entity Framework Core 1.0. So in this post, let’s find out how to use SQL Server Sequence in Entity Framework Core to create primary key.
(more…)

Read More

How to execute Stored Procedure in Entity Framework Core

Entity Framework 6.x supports stored procedure mapping for CRUD operations. However, this is no longer available in Entity Framework Core. But there are still workaround exists in EF Core to execute stored procedures to get the data and for CRUD operations. In this post, we will see how to execute Stored Procedure in Entity Framework Core using the FromSql method to get the data and ExecuteSqlCommand method for CRUD operations. (more…)

Read More