SqlBatch.BatchCommands Properti

Definisi

Ruang nama:

Microsoft.Data.SqlClient

Rakitan:

Microsoft.Data.SqlClient.dll

Paket:

Microsoft.Data.SqlClient v5.2.0

Daftar perintah yang terkandung dalam batch dalam SqlBatchCommandCollection.

public:
 property Microsoft::Data::SqlClient::SqlBatchCommandCollection ^ BatchCommands { Microsoft::Data::SqlClient::SqlBatchCommandCollection ^ get(); };

public Microsoft.Data.SqlClient.SqlBatchCommandCollection BatchCommands { get; }

member this.BatchCommands : Microsoft.Data.SqlClient.SqlBatchCommandCollection

Public ReadOnly Property BatchCommands As SqlBatchCommandCollection

Nilai Properti

SqlBatchCommandCollection

Contoh

Contoh berikut membuat SqlConnection dan SqlBatch, lalu menambahkan beberapa SqlBatchCommand objek ke batch. Kemudian menjalankan batch, membuat SqlDataReader. Contohnya membaca hasil perintah batch, menulisnya ke konsol. Akhirnya, contoh menutup SqlDataReader dan kemudian saat SqlConnectionusing blok jatuh dari cakupan.

using Microsoft.Data.SqlClient;

class Program
{
    static void Main()
    {
        string str = "Data Source=(local);Initial Catalog=Northwind;"
        + "Integrated Security=SSPI;Encrypt=False";
        RunBatch(str);
    }

    static void RunBatch(string connString)
    {
        using var connection = new SqlConnection(connString);
        connection.Open();

        var batch = new SqlBatch(connection);

        const int count = 10;
        const string parameterName = "parameter";
        for (int i = 0; i < count; i++)
        {
            var batchCommand = new SqlBatchCommand($"SELECT @{parameterName} as value");
            batchCommand.Parameters.Add(new SqlParameter(parameterName, i));
            batch.BatchCommands.Add(batchCommand);
        }

        // Optionally Prepare
        batch.Prepare();

        var results = new List<int>(count);
        using (SqlDataReader reader = batch.ExecuteReader())
        {
            do
            {
                while (reader.Read())
                {
                    results.Add(reader.GetFieldValue<int>(0));
                }
            } while (reader.NextResult());
        }
        Console.WriteLine(string.Join(", ", results));
    }
}