SqlBatch Konstruktor

Definisi

Ruang nama:

Microsoft.Data.SqlClient

Rakitan:

Microsoft.Data.SqlClient.dll

Paket:

Microsoft.Data.SqlClient v5.2.0

Overload

SqlBatch()	Menginisialisasi baru SqlBatch.
SqlBatch(SqlConnection, SqlTransaction)	Menginisialisasi baru SqlBatch.

SqlBatch()

Menginisialisasi baru SqlBatch.

public:
 SqlBatch();

public SqlBatch ();

Public Sub New ()

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));
    }
}

SqlBatch(SqlConnection, SqlTransaction)

Menginisialisasi baru SqlBatch.

public SqlBatch (Microsoft.Data.SqlClient.SqlConnection connection, Microsoft.Data.SqlClient.SqlTransaction transaction = default);

new Microsoft.Data.SqlClient.SqlBatch : Microsoft.Data.SqlClient.SqlConnection * Microsoft.Data.SqlClient.SqlTransaction -> Microsoft.Data.SqlClient.SqlBatch

Public Sub New (connection As SqlConnection, Optional transaction As SqlTransaction = Nothing)

Parameter

connection

SqlConnection

SqlConnection yang mewakili koneksi ke instans SQL Server.

transaction

SqlTransaction

SqlCommand tempat SqlTransaction eksekusi.