database.cake

#addin "nuget:?package=Cake.SqlServer"

var target = Argument("target", "Default");
var configuration = Argument("configuration", "Release");

Task("Testing-Database")
    .Does(() => 
    {
        LocalDbCreateInstance("v12.0", LocalDbVersion.V12);

        var masterConnectionString = @"data source=(LocalDb)\v12.0;";
        DropAndCreateDatabase(masterConnectionString, "MyProject-Testing");
        
        var connectionStrig = @"data source=(localdb)\v12.0;Database=MyProject-Testing";
        ExecuteSqlFile(connectionStrig, "./database/Database.sql");
        ExecuteSqlFile(connectionStrig, "./database/Data.sql");
        ExecuteSqlFile(connectionStrig, "./database/Updates.sql");
    });


Task("Create-Database")
    .Description("Creates database and installs schema")
    .Does(() => 
    {
        var masterConnectionString = @"data source=.\SQLEXPRESS;integrated security=SSPI;";

        var connectionStrig = @"data source=.\SQLEXPRESS;integrated security=SSPI;Initial Catalog=MyProject";

        DropAndCreateDatabase(masterConnectionString, "MyProject");
        ExecuteSqlFile(connectionStrig, "./database/Database.sql");
        ExecuteSqlFile(connectionStrig, "./database/Data.sql");
        ExecuteSqlFile(connectionStrig, "./database/Updates.sql");
    });



Task("Default")
    .IsDependentOn("Debug");

RunTarget(target);