Cake Build addin for executing sql scripts against a database

1. Implemented functionality
2. Referencing
3. Usage
4. Example
5. Plays well with
6. License
7. Share the love

• Execute a query against a database
• Contains a provider for MS Sql, MySql and PostgreSQL

Cake.SqlTools is available as a nuget package from the package manager console:

Install-Package Cake.SqlTools

or directly in your build script via a cake addin directive:

#addin "Cake.SqlTools"

#addin "Cake.SqlTools"

Task("Execute-Sql-Query")
    .Description("Execute a Sql query against a database.")
    .Does(() =>
{
    ExecuteSqlQuery("CREATE DATABASE Test", new SqlQuerySettings()
    {
        Provider = "MsSql",
        ConnectionString = "blah"
    });
});

Task("Execute-Sql-File")
    .Description("Execute a Sql query  against a database, from the contents of a file.")
    .Does(() =>
{
    ExecuteSqlFile("./Scripts/Restore-DB.sql", new SqlQuerySettings()
    {
        Provider = "MsSql",
        ConnectionString = "blah"
    });
});

RunTarget("Execute-Sql-Query");

A complete Cake example can be found here.

• Please be aware of the breaking changes that occurred with the release of Cake v0.22.0, you will need to upgrade Cake in order to use Cake.SqlTools v0.1.0 or above.

If your looking for a way to trigger cake tasks based on windows events or at scheduled intervals then check out CakeBoss.

Copyright (c) 2015 - 2016 Phillip Sharpe

Cake.SqlTools is provided as-is under the MIT license. For more information see LICENSE.

Please be aware that MySql.Data uses the GNU public LICENSE.

If this project helps you in anyway then please ⭐ the repository.