Best way to check if object exists in Entity Framework? [closed]

by

If you don’t want to execute SQL directly, the best way is to use Any(). This is because Any() will return as soon as it finds a match. Another option is Count(), but this might need to check every row before returning.

Here’s an example of how to use it:

if (context.MyEntity.Any(o => o.Id == idToMatch))
{
    // Match!
}

And in vb.net

If context.MyEntity.Any(function(o) o.Id = idToMatch) Then
    ' Match!
End If

More Related Contents:

  1. ASP.NET MVC 2.0 Implementation of searching in jqgrid
  2. What’s the difference(s) between .ToList(), .AsEnumerable(), AsQueryable()?
  3. The specified type member ‘Date’ is not supported in LINQ to Entities Exception
  4. Entity Framework 4 / POCO – Where to start? [closed]
  5. Include Grandchildren in EF Query
  6. LINQ to Entities for subtracting 2 dates
  7. LINQ To Entities + Include + Anonymous type issue
  8. EF4 LINQ Ordering Parent and all child collections with Eager Loading (.Include())
  9. ORM Entities vs. Domain Entities under Entity Framework 6.0
  10. The type of one of the expressions in the join clause is incorrect in Entity Framework
  11. Linq to Entities, random order
  12. How do I detach objects in Entity Framework Code First?
  13. No executable found matching command “dotnet-ef”
  14. How to ensure proxies are created when using the repository pattern with entity framework?
  15. Entity Framework Code First – No Detach() method on DbContext
  16. Entity framework core update many to many
  17. Order navigation properties when using Include and/or Select methods with EF 4.1 Code-First?
  18. Package Manager Console Enable-Migrations CommandNotFoundException only in a specific VS project
  19. Instantiating a context in LINQ to Entities
  20. How to create index in Entity Framework 6.2 with code first
  21. How can I disable code first migrations
  22. DbSet.Find method ridiculously slow compared to .SingleOrDefault on ID
  23. Linq To Entities – how to filter on child entities
  24. An object with the same key already exists in the ObjectStateManager. The ObjectStateManager cannot track multiple objects with the same key
  25. What is the syntax for self referencing foreign keys in EF Code First?
  26. check constraint entity framework
  27. int to string in Entity Framework
  28. Entity Framework: Inheritance and Include
  29. Entity Framework – Get List of Tables
  30. Entity framework code first delete with cascade

Leave a Comment