执行查询

• However , in this walkthrough , you will create and execute a query programmatically
  但是，在此演练中，将以编程方式创建并执行查询。
• You execute queries and stored procedures using tableadapters and command objects
  您使用tableadapter和命令对象执行查询和存储过程。
• The duration of the context switch is limited to the scope of the query being executed
  时，上下文切换的持续时间限制为执行查询的范围。
• A new plan must then be recompiled for the next connection that executes the query
  此后，必须为执行查询的下一个连接重新编译新的计划。
• The query optimizer typically selects the most efficient method when executing queries
  查询优化器在执行查询时通常会选择最有效的方法。
• Each time that a query is performed , a handle for the results of that query is associated with its
  每次执行查询时，查询结果的句柄都与其
• Event , and in the event , encode the parameter value before the query is executed
  事件，可以在该事件中，在执行查询之前对参数值进行编码。
• Therefore , implementing the query yourself can sometimes provide vast performance improvement
  因此，您自己执行查询有时可以大大提高性能。
• The final step is to create the method that performs the query and returns the dataset
  最后步骤是创建一个方法，该方法执行查询并返回数据集。
• Xquery benefits developers by reducing the amount of code needed to perform a query
  Xquery给开发人员带来的好处是减少了执行查询所需要的代码量。