Creating Custom Execute Methods

[Gengaeldelse1]

I'm sorry if this has been asked before, but I would like to create some custom Execute methods for the project I'm working on.

What I'm trying to create are some methods that would allow my team members to save time in creating migrations by simplifying the Execute.Script() method.

What I would like for them to write is this:

Execute.Procedure("StoredProcedure");

Instead of:

Execute.Script(@"..\Scripts\Stored Procedures\StoredProcedure.sql");

Is this possible to do? If so, how?

[workgroupengineering]

See AutoScriptMigration

[Gengaeldelse1]

Unfortunately, this won't accomplish what I would like to do. Due to my companies SQL code standards, I can't change the names of 2000 sql scripts to be able to use AutoScriptMigration.

I'm essentially wanting to write an extension class so I can pre fill the folder path for various objects.

Something like this:

public class MigrationExtensions : ForwardOnlyMigration
{
    public void ExecuteProcedure(string input)
    {
        Execute.Script($@"..\Scripts\Stored Procedures\{input}.sql");

    }

However, when I have a migration inherit from MigrationExtensions instead of ForwardOnlyMigrations, I get an error when I try to execute migrate.exe:

Could not load file or assembly 'System.Runtime...

[workgroupengineering]

You can configure name convention implenting your IAutoNameConvention

this is default implementation.