SqlCommand optimizes parameterized sql statements?

Question

I know in Java, using PreparedStatement with parameters, some JDBC drivers will optimize SQL queries by turning them into stored procedures so that all subsequent calls are faster. Does SqlCommand provide such optimization when accessing MS SQLServer?

Answer 1

You can call the .Prepare () command to perform this optimization.

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.prepare.aspx