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. Read More
Tag: .NET Core
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.
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. Read More
Quick summary of what’s new in Entity Framework Core 1.0
Entity Framework Core 1.0 has been already out and Microsoft has already started working on Entity Framework Core 1.1. One of the advantage of ASP.NET Core is cross-platform support similarly Entity Framework Core (EF Core) is also cross-platform version of Entity Framework. So here is a quick and short summary of what’s new in Entity Framework Core compared to its previous versions. Read More
DotNet 5.4 or .NET Platform Standards
Yes, you read it right “DotNet 5.4“. Create a nuget class library using Visual Studio 2015 and RC 1 update. And take a look at the Project.json file, you will be surprised to see “DotNet 5.4” in the framework section. Recently ASP.NET 5 was renamed to ASP.NET Core 1.0, then from where DotNet 5.4 came from? They are yet to release RC 2 for ASP.NET Core 1.0 and I was like “Have I really missed the release of Dotnet 5.1 to 5.3? “.
Read More
Difference between .NET Core and .NET Framework
Since the announcement of ASP.NET 5.0 ASP.NET Core 1.0 now, it has created confusion with the name and different flavors of new version of .NET. Some of my colleagues were also confused with naming and different flavor of it. So in this short post, let’s understand difference between .NET Core and .NET Framework.
Read More