Class SqlScripExecutor

Namespace: DbExport.Providers.SqlClient

Assembly: DbExport.Api.dll

Represents an implementation of the IScriptExecutor interface for executing SQL scripts against a SQL Server database using a given connection string.

public class SqlScripExecutor : IScriptExecutor

Inheritance: object

SqlScripExecutor

Implements: IScriptExecutor

Inherited Members: object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Examples

This class is intended for use with SQL Server environments and supports SQL scripts containing CREATE DATABASE, USE, and CREATE TYPE commands.

Remarks

This class processes and executes SQL scripts, handling specific constructs such as database creation, database switching (USE statements), and user-defined type creation. The scripts are parsed and executed in multiple steps, ensuring proper handling of dependencies and execution order.

Methods

Execute(string, string)

Executes a SQL script against the specified database connection.

public void Execute(string connectionString, string script)

Parameters

connectionString string: The connection string used to connect to the database.
script string: The SQL script to be executed.