sql - 如何在 vb.net 中设置 NOCOUNT

Question

在应用程序中设置“SET NOCOUNT ON”总是有利于应用程序的性能。但是我如何在 VB.net 项目的 vb.net 应用程序中设置它？这是我的代码

Dim myConn As OleDbConnection
Dim myAdapter As OleDbDataAdapter
Dim myDts As New DataSet
Dim strSql As String = "select * from table_issue"
myConn = New OleDbConnection(oldeb_connection_string)
myAdapter = New OleDbDataAdapter(strSql, myConn)
myAdapter.Fill(myDts,"table_issue")

标签： sqlvb.netoracle11gnocount

Answer 1

Dim strSql As String = "SET NOCOUNT OFF; select * from table_issue; SET NOCOUNT ON;"