Entity Framework Core is the recommended ORM (object to database mapper) for .NET Core platform. It provides support for LINQ queries, entity relationships, change tracking and database migrations. EF Core supports SQL Server, SQLite, MySQL and PostgreSQL. It is ideal choice for CRUD applications built using ASP.NET Core MVC and other .NET choices. Well, deep… Read More »
We can unanimously agree Entity Framework 6 is stable and battle tested ORM library in .NET eco-system. Since, Entity Framework Core is a complete rewrite of EF6 and is a cross platform solution. Because of fundamental changes in EF Core, there is no straight forward way to move an EF6 code to EF Core except… Read More »
Left joins are such a common occurrence in data access programs. There is no direct LINQ operator or syntax mapped for left joins. However, there is an extension method DefaultIfEmpty() which can be employed to perform a left outer join using LINQ syntax. DefaultIfEmpty basically returns a single element sequence with associated type’s default value… Read More »