O'Reilly logo

Essential ADO.NET by Bob Beauchemin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

3.6. Using Parameters

Parameters are confusing because there are so many different “standards” for them. Parameters are used mainly because of the way the query engine works (and caches) in relational databases. Consider these two queries:

select * from authors where au_fname = 'Bob'
select * from authors where au_fname = 'Fred'

When a SQL engine executes these commands, it goes through a three-step process (the absolute specifics may vary among databases):

1.
The command is parsed into a tree form, and the object names are resolved. This step catches mistakes such as spelling the keyword SELECT incorrectly or referring to a table or column that does not exist.
2.
The parsed tree form of the command is analyzed by the relational manager, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required