What happens internally if the statement cmd.Prepare() is executed in the Frontend

Posted by deccansoft on 9/18/2010 | Category: C# Interview questions | Views: 2215

The sql statements will be compiled and a cache copy of the same will be
created so that next time the result can be given using the cache copy
for different parameters.

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous question : In Sql server the parameters must begin with _____ ...

Next question > : Which is the top layer in the ADO.NET Entity Frame ...

Comments or Responses

More Interview Questions

Which is the top layer in the ADO.NET Entity Framework
can we enable or diasble the connection pool
Can we add relations between the tables in dataset
What is SQL injection
Which template must you provide, in order to display data in a Repeate ...
Which method do you invoke on the DataAdapter control to load your gen ...
Explain ACID rule of thumb for transactions.
What is the wildcard character in SQL