15,881,092 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View Python questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Artificial Intelligence
Artificial Intelligence
Neural Networks
Machine Learning
Deep Learning
ML.Net
Big Data
Data Science
Tensorflow
ChatGPT
Internet of Things
Internet of Things
Arduino
Edge Device
Raspberry-Pi
Wearables
IoT Edge
Industrial IoT
DevOps
DevOps
Agile
Automation
Continuous Build
Continuous Delivery
Continuous Deployment
Continuous Integration
Deployment
Git
Installation
Integration Testing
Load Testing
Quality Assurance
TFS
Unit Testing
Testing
Containers
Containers
Docker
Kubernetes
Virtual Machine
High Performance Computing
High Performance Computing
GPU
Parallel Processing
Parallelization
Vectorization
Hosted Services
Hosted Services
AWS
Cordova
ExtJS
Google Cloud
Microservices
PhoneGap
Serverless
Storage
Web Hosting
WordPress
Azure
Security
Security
Blockchain
Cryptography
Encryption
Identity
Identity Server
Web Development
Web Development
Blazor
CSS3
Flask
HTML5
Kestrel
LESS
Nginx
Node.js
React
SCSS
Spring
Vue.js
ASP.NET
CSS
Apache
HTML
IIS
XHTML
Mobile Apps
Mobile Apps
Flutter
Ionic
iOS
Nativescript
React Native
Xamarin
Windows Mobile
Android
Desktop Programming
Desktop Programming
Cocoa
Electron
QT
Universal Windows Platform
X11
Windows Forms
ATL
MFC
Swing
Win32
WTL
WPF
XAML
System
Database Development
Database Development
Data Visualization
Elasticsearch
Lucene
MariaDB
MongoDB
NoSQL
PostgreSQL
Redis
MySQL
SQL Server
Productivity Apps and Services
Productivity Apps and Services
LibreOffice
OpenOffice
Sharepoint
Team Communication Tools
Biztalk
Microsoft Office
SAP
Game Development
Game Development
Doom
Kinect
Playstation 4
Playstation 5
Unity
Unreal
XBox
Multimedia
Multimedia
Audio
Image Processing
Video
Audio Video
DirectX
GDI
GDI+
OpenGL
General Programming
General Programming
Algorithms
Compression
Computational Geometry
Emulation
Exceptions
File
Internet
Localization
Memory Management
Optimization
Parser
Performance
Regular Expressions
Sorting
State Machines
Architecture
Design / Graphics
Printing
String
Threads
Usability
Programming Languages
Programming Languages
ASM
Bash
Basic
COBOL
Dart
Go
Haskell
Kotlin
Lua
Pascal
R
Razor
Rust
Scala
Swift
Typescript
Objective C
Visual Basic
VBScript
C++
C#
F#
FORTRAN
Java
Javascript
Perl
Python
Ruby
SQL
PHP
PowerShell
XML
Articles by Bob Crowley (Article: 1, Technical Blogs: 3, Tip/Trick: 1)
Article: 1, Technical Blogs: 3, Tip/Trick: 1
Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects
Average article rating: 4.84
Database Development
Input, Output and Input/Output SqlParameter Behavior Explained
1 Nov 2016 Updated:
1 Nov 2016
Rating: 4.84/5 Votes: 13 Popularity: 5.39
Licence: CPOL Views: 33,560
Bookmarked: 9
Downloaded: 0
Please
Sign up or sign in
to vote.
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.
Average blogs rating: 4.96
DevOps
Testing
Organizing Service Mocks in Unit Tests [Technical Blog]
5 Nov 2017 Updated:
6 Nov 2017
Rating: 5.00/5 Votes: 2 Popularity: 1.51
Licence: CPOL Views: 7,041
Bookmarked: 6
Downloaded: 0
Please
Sign up or sign in
to vote.
Minimize mocking code while still providing all necessary scenarios to exercise your business logic unit tests
Programming Languages
C# 6.0
Custom Serilog Sink Development [Technical Blog]
16 Jan 2017 Updated:
16 Jan 2017
Rating: 5.00/5 Votes: 1 Popularity: 0.00
Licence: CPOL Views: 12,361
Bookmarked: 3
Downloaded: 0
Please
Sign up or sign in
to vote.
Custom Serilog Sink Development
Web Development
ASP.NET
Using HttpClient As It Was Intended (Because You’re Not) [Technical Blog]
1 Jul 2017 Updated:
1 Jul 2017
Rating: 4.89/5 Votes: 32 Popularity: 7.36
Licence: CPOL Views: 63,990
Bookmarked: 50
Downloaded: 0
Please
Sign up or sign in
to vote.
Using HttpClient as it was intended
Average tips rating: 3.86
Database Development
Dynamic ORDER BY with multiple criteria in T-SQL [Tip/Trick]
28 May 2013 Updated:
28 May 2013
Rating: 3.86/5 Votes: 3 Popularity: 1.84
Licence: CPOL Views: 34,901
Bookmarked: 8
Downloaded: 0
Please
Sign up or sign in
to vote.
How to use a CASE statement in ORDER BY to avoid dynamic SQL
Average reference rating:
No reference articles have been posted.
Average project rating:
No projects have been posted.
Bob Crowley
Software Developer (Senior)
EVO Payments International
United States
Full stack developer on .Net and related technologies with heavy emphasis on back-end API development and integrations.
Submit an article or tip