SQLCommandBuilder效率

Question

我从msdn MSDN COMMAND BUILDER CLASS上摘录了这篇文章。在ASP.NET中快速插入、更新或删除表是否合适，否则效率会很低吗？！

 public static DataSet SelectSqlRows(string connectionString, string queryString, string tableName)
{
    using (SqlConnection connection = new SqlConnection(connectionString))
    {


        SqlDataAdapter adapter = new SqlDataAdapter();
        adapter.SelectCommand = new SqlCommand(queryString, connection);
        SqlCommandBuilder builder = new SqlCommandBuilder(adapter);

        connection.Open();

        DataSet dataSet = new DataSet();
        adapter.Fill(dataSet, tableName);

        //code to modify data in DataSet here

        builder.GetUpdateCommand();

       //Without the SqlCommandBuilder this line would fail
       adapter.Update(dataSet, tableName);

       return dataSet;
    }
}

Answer 1

你的代码在效率方面没有问题。一种建议是使用存储过程或参数化查询，而不是直接执行查询字符串，这将有助于防止SQL注入。

参考资料：

http://www.dotnetperls.com/sqlparameter

Answer 2

它将与您执行的底层SQL语句一样高效。