Exception when AddWithValue parameter is NULL

by

Annoying, isn’t it.

You can use:

command.Parameters.AddWithValue("@application_ex_id",
       ((object)logSearch.LogID) ?? DBNull.Value);

Or alternatively, use a tool like “dapper”, which will do all that messing for you.

For example:

var data = conn.Query<SomeType>(commandText,
      new { application_ex_id = logSearch.LogID }).ToList();

I’m tempted to add a method to dapper to get the IDataReader… not really sure yet whether it is a good idea.

More Related Contents:

  1. ExecuteReader requires an open and available Connection. The connection’s current state is Connecting
  2. MetadataException: Unable to load the specified metadata resource
  3. Get output parameter value in ADO.NET
  4. When should “SqlDbType” and “size” be used when adding SqlCommand Parameters?
  5. SQLite Database Locked exception
  6. Is it necessary to manually close and dispose of SqlDataReader?
  7. Populate data table from data reader
  8. When using Trusted_Connection=true and SQL Server authentication, will this affect performance?
  9. Difference with Parameters.Add and Parameters.AddWithValue
  10. SqlConnection SqlCommand SqlDataReader IDisposable
  11. Calling Oracle stored procedure from C#?
  12. Insert into C# with SQLCommand
  13. MultipleActiveResultSets=True or multiple connections?
  14. How to pass a table-value parameter
  15. How DataReader works?
  16. How to keep single SQL Server connection instance open for multiple request in C#?
  17. DataTable equivalent in Java [duplicate]
  18. How do I re-write a SQL query as a parameterized query?
  19. Check if a SQL table exists
  20. What is the difference between dataview and datatable?
  21. Reading a date using DataReader
  22. What ‘length’ parameter should I pass to SqlDataReader.GetBytes()
  23. How do I connect to a SQL database from C#?
  24. .net connection pooling
  25. Do we have transactions in MS-Access?
  26. prime number takes 0 arguments issue [closed]
  27. How to take a screenshot of a WPF control?
  28. Remove Row inside TableLayoutPanel makes a layout problem
  29. What’s the best way to represent System.Decimal in Protocol Buffers?
  30. Out of memory exception while updating zip

Leave a Comment