Parameters.addwithvalue null

Connect and share knowledge within a single location that is structured and easy to search. I have following code for specifying parameters for SQL query. I am getting following exception when I use Code 1 ; but works fine when I use Code 2. In Code 2 we have a check for null and hence a if..

I'm tempted to add a method to dapper to get the IDataReader I find it easier to just write an extension method for the SqlParameterCollection that handles null values:.

Just in case you're doing this while calling a stored procedure: I think it's easier to read if you declare a default value on the parameter and add it only when necessary.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more.

Asked 9 years, 1 month ago. Active 1 year, 7 months ago. Viewed 70k times. Code 1 : command. LogID ; Code 2 : if logSearch. Is there a better code to handle this? LogID ; if logSearch. FillEntityFromRecord log, currentRecord ; logs. Improve this question. Community Bot 1 1 1 silver badge. What do you mean by better? Code 2 is the correct way to send a null value to a database.

Add a comment. Forgot your password? Ask a Question. Want to pass null value for Datetime. Please Sign up or sign in to vote. See more: ASP. I want to pass null value for datetime object.

Value to datetime object. DBNull to System. Posted 4-Mar pm tanuja karkar. Add a Solution. Declare the Datetime variable as nullable. Top Rated Most Recent. Accept Solution Reject Solution. If Allow Nulls is checked for the field. I hope the above information will be helpful. If you have more concerns, please let me know. Posted 5-Mar am Monjurul Habib. DateTime datatype shouldn't be null. Instead use DateTime.

Minvalue which stores the minimum value. Posted 5-Mar am m dhu. Monjurul Habib 5-Mar am. I should be more specific Cannot implicitly convert type 'System. DateTime The error raises when inserting null to datetime not null. In that sense it shouldn't be null, some value to be inserted.

A value type such as System. DataTime cannot accept null or DBNull value. AlanSB Jan Brady Kelly Jan PSU Steve 6-Jan Brady Kelly 6-Jan Go to top. Layout: fixed fluid. South Africa. First Prev Next. Thanks so much!! Member This saved me so much time as I was trying one thing after another to get around the null value parameter issue. You ROCK!!! Re: Oh, good, thanks. Though I expect some will put that whole Oh, good, thanks.

Though I expect some will put that whole thing in a loop. AddWithValue " Category", line. DBNull Same result, self documenting, don't have to deal with an extra namespace and may create inline code which is faster. Assuming, of course, that you aren't dealing with dealing with value types. Which draws the proposed extension into question anyway.