Creating and Executing Parameterized Queries

home
ado.net
view story

3 Kicks

Creating and Executing Parameterized Queries(beyondrelational.com)

submitted by DPalkar(228) 2 years ago

In this post we’ll discuss how we can execute parameterized queries in .Net. At times when you can’t use the most recommended way to retrieve/update data through Stored Procedures, you can rely on parameterized queries. It is much safer and recommended than building a sql string dynamically, which is a bit more error prone as well as hard to maintain. Parameterized queries are queries that have one or more embedded parameters in sql statement which are also type safe. You build them separately and attach them into the sql statement.

add a comment |category: ADO.NET |Views: 9
Tweet