Does SqlCommand optimize parameterized sql statements?

Question

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

user151323 · Accepted Answer · 2009-09-02 09:20:49Z

2

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

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

answered Sep 2, 2009 at 9:20

user151323

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Does SqlCommand optimize parameterized sql statements?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related