Category Archives: ORM

Global Query Filters in EF Core 2.0

Global Query Filters are a new addition to the arsenal of features in EF Core 2.0. This also implies that EF core team spearheaded by Diego Vega who are working diligently to bring EF Core at par with its Entity … Continue reading

Posted in ORM | Comments Off on Global Query Filters in EF Core 2.0

EF Core 2.1 Roadmap

Ever since the release of Entity Framework Core 1.0 back in July 2016, its been a constant churning of releases packed with new features. There’s no doubt Microsoft will give all the love to this shiny new tool called EF … Continue reading

Posted in ORM | Comments Off on EF Core 2.1 Roadmap

What package(s) do I need for EF Core 2.x?

First off, it is important to note that there are a couple of ways to download package(s). 1. You can use NuGet right from inside Visual Studio IDE 2. You can also use CLI (Command Line Interface) Here, I’ll demonstrate … Continue reading

Posted in ORM | Comments Off on What package(s) do I need for EF Core 2.x?

What is the difference between Delete and Truncate

There are a subtle difference between Delete and Truncate. Delete statement delete rows one row at a time while also logging each deleted row in the transaction log. TRUNCATE TABLE statement on the other hand quickly deletes all records in … Continue reading

Posted in ORM | Comments Off on What is the difference between Delete and Truncate

What is IDENTITY value and how does it work?

An IDENTITY is a system function that returns the last-inserted identity value. Let’s try it out in SQL Server Management Studio. Let’s create a table called Person with it’s IDENTITY starting position set to 1 with an increment value of … Continue reading

Posted in ORM | Comments Off on What is IDENTITY value and how does it work?