A database may contain various constructs - tables, views, stored procedures, functions, etc. We already have seen how tables can be mapped to C# EF core models, by defining a…
Sometimes applications have to perform multiple operations on the database. Traditionally, database level transactions are used by applications in order to ensure atomicity of such operations. In this article, let's…
In recent posts, I have been writing about EF Core concepts. EF Core code first approach allows to write C# code first and then this C# code can be then…
I am writing about .NET EF core since past few weeks and if you have followed the series, you may already have seen the article about what are migrations and…
Entity Framework core exposes some events via DbContext and we have seen how those events can be used. In this article, we are going to have a look at another…
We have seen how queries are evaluated and entities are tracked by EF Core. All operations performed on tracked entities are performed on an in memory instance of entity. The…
In one of the previous posts, we have seen the an approach which can be used to troubleshoot performance issues. In this article, let's try to understand how a query…
We have seen what is identity resolution and how it is used by EF core to track the entities in memory. AsNoTracking is very common option suggested to make querying…
In previous article, we have seen what a keyless entity means and how to declare a keyless entity. In this article, let's discuss about a related concept - identity resolution.…
Sometimes, we may need to declare EF core models which do not have primary keys. In this article, let's understand why such entities would be required and how to define…
In last article, we have some some basic tips which can be useful troubleshoot any issues in the applications which use .NET EF core. Now, let's have a look at…
Generally, applications using .NET and EF Core use LINQ statements to interact with underlying database. In this article, let's see some options which can be used to debugging those queries.…
