Sequence contains no elements?

I’m currently using a single query in two places to get a row from a database.

BlogPost post = (from p in dc.BlogPosts
                 where p.BlogPostID == ID
                 select p).Single();

The query is fine when retrieving the row to put data in to the text boxes, but it returns an error “Sequence contains no elements” when used to retrieve the row in order to edit it and put it back in to the database. I can’t understand why it might find an appropriate row in one instance but not another.

(Using ASP.NET MVC and LINQ)

Related Posts:

  1. Group by in LINQ
  2. Join/Where with LINQ and Lambda
  3. LINQ’s Distinct() on a particular property
  4. LEFT OUTER JOIN in LINQ
  5. ToList().ForEach in Linq
  6. Extension methods must be defined in a non-generic static class
  7. Proper Linq where clauses
  8. Extension methods must be defined in a non-generic static class
  9. Select distinct using linq
  10. Convert Linq Query Result to Dictionary
  11. Get single value from dictionary by key
  12. IEnumerable vs List – What to Use? How do they work?
  13. Sequence contains no matching element
  14. Cannot implicitly convert type ‘System.Collections.Generic.List< >‘ to ‘System.Collections.Generic.IList< >‘
  15. Linq select objects in list where exists IN (A,B,C)
  16. How do I concatenate two arrays in C#?
  17. Convert SQL to LINQ Query
  18. Sequence contains more than one element
  19. Quickest way to compare two generic lists for differences
  20. LINQ query on a DataTable
  21. Using .Select and .Where in a single LINQ statement
  22. Linq: GroupBy, Sum and Count
  23. Convert HTML to PDF in .NET
  24. How can I parse JSON with C#?
  25. How to fix No connection could be made because the target machine actively refused it 127.0.0.1:64527
  26. What does a lock statement do under the hood?
  27. Converting string to byte array in C#
  28. What is C# equivalent of in C++?
  29. How to use SQLite in Visual Studio 2017?
  30. How to convert byte array to string [duplicate]
  31. C# Java HashMap equivalent
  32. Configuration System Failed to Initialize
  33. Unity cannot convert from ‘string’ to ‘int’
  34. The request was aborted: Could not create SSL/TLS secure channel
  35. The located assembly’s manifest definition does not match the assembly reference
  36. Get current folder path
  37. Regex for numbers only
  38. foreach vs someList.ForEach(){}
  39. Access to the path is denied
  40. What does question mark and dot operator ?. mean in C# 6.0?
  41. How to jump in Unity 3d?
  42. Proper way to initialize a C# dictionary with values
  43. Incorrect string value: ‘\xEF\xBF\xBD’ for column
  44. How do I declare a DefaultValue attribute whose value is an array of strings?
  45. Unity3d restart current scene
  46. Get dictionary value by key
  47. Invalid URI: The format of the URI could not be determined
  48. Unity “The associated script can not be loaded” and “Win32Exception: The system cannot find the file specified”
  49. SQL Insert Query Using C#
  50. What is the difference between “@Scripts.Render” and “

    Recommended Hostings

    Cloudways: Realize Your Website's Potential With Flexible & Affordable Hosting. 24/7/365 Support, Managed Security, Automated Backups, and 24/7 Real-time Monitoring.

    FastComet: Fast SSD Hosting, Free Migration, Hack-Free Security, 24/7 Super Fast Support, 45 Day Money Back Guarantee.

© 2024 Read For Learn