This article covers sp getapplock / releaselock storage procedures and its use in a simple way including simple functions that can be used with Entity Framework and C#.
Entity Framework Core is a popular object relational mapping software on the market. The .NET Core provides an efficient method for writing queries in C# while EF Core is responsible for transforming it into a similar SQL language and executing it on a connected database.
(more…)
In this article, you’ll discover why lazy loading with Entity Framework is so beneficial and how you can implement it yourself.
Entity Framework Core allows users to execute raw SQL queries directly against the database for situations where the LINQ database is not a valid database query or unless the SQL has not been compiled properly or is not scalable enough.
Entity framework does a great job of detecting when a field changes on any object that it is tracking. These changes will be automatically saved when SaveChanges is executed. As I discussed in Why the Repository Pattern I like to create an example Generic Class that is type T where T is a Model or a User in my Entity Framework Context. This example will extend upon those context query to retrieve the modified entry.