Entity Framework 1 gives you some support for issuing SQL statements and Entity Framework 4 gives you more. Two caveats before we begin: First, in this column I'm not going to make an effort to come ...

This is not about saying EF is bad — it’s about sharing what I learned from real .NET projects where Entity Framework didn’t behave as expected. Here’s why I started moving back to raw SQL and Dapper ...

It's critical to understand that FromSql is much more limited than SqlQuery in terms of what it can return. SqlQuery, which was available from the DbContext's Database object, allowed you to submit ...

In Entity Framework 6, "flattening queries" refers to transforming LINQ expressions - especially those involving navigation properties and projections - to avoid generating inefficient or overly ...

This project set is designed for developers looking to deepen their understanding of C# and data management techniques. It covers a wide range of technologies and tools, including Entity Framework, ...