Click here to Skip to main content
15,040,090 members
Articles / Database Development

Stats

24.1K views
10 bookmarked

Input, Output and Input/Output SqlParameter Behavior Explained

Rate me:
Please Sign up or sign in to vote.
4.84/5 (13 votes)
1 Nov 2016CPOL12 min read
In this article, I will explain the sometimes surprising behavior of  the ADO.NET SqlParameter and particularly the effects of ParameterDirection, null value and DBNull.Value on how the parameter is sent to the database.

Views

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Bob Crowley
Software Developer (Senior) EVO Payments International
United States United States
Full stack developer on .Net and related technologies with heavy emphasis on back-end API development and integrations.

Comments and Discussions