SQlite script

Happy Hyena answered on March 30, 2022 Popularity 5/10 Helpfulness 1/10

answer SQlite script

SQlite script

Comment

string script = File.ReadAllText(@"E:\someSqlScript.sql");

// split script on GO command
IEnumerable<string> commandStrings = Regex.Split(script, @"^\s*GO\s*$", RegexOptions.Multiline | RegexOptions.IgnoreCase);

Connection.Open();
foreach (string commandString in commandStrings)
{
    if (!string.IsNullOrWhiteSpace(commandString.Trim()))
    {
        using(var command = new SqlCommand(commandString, Connection))
        {
            command.ExecuteNonQuery();
        }
    }
}     
Connection.Close();

Popularity 5/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: script sql sqlite

Link to this answer
Share Copy Link

Contributed on Mar 30 2022

Happy Hyena

0 Answers Avg Quality 2/10

SQlite script

Contents

More Related Answers

SQlite script

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.