public void GetScriptFromDefinedFolder()
        {
            var provider = new FileMigrationScriptsProvider(_folderFullPath);
            var scripts  = provider.GetScripts().ToList();

            scripts.Count.Should().Be(3);
            scripts[0].Should()
            .BeEquivalentTo(
                new ScriptInfo(provider)
            {
                Id   = 20190228001,
                Name = "InitDatabase",
                Path = GetFileFullName("20190228001_InitDatabase")
            });
            scripts[1].Should()
            .BeEquivalentTo(
                new ScriptInfo(provider)
            {
                Id   = 20190301001,
                Name = "AddPeopleTable",
                Path = GetFileFullName("20190301001_AddPeopleTable")
            });
            scripts[2].Should()
            .BeEquivalentTo(
                new ScriptInfo(provider)
            {
                Id   = 20190301002,
                Name = "AddProjectTable",
                Path = GetFileFullName("20190301002_AddProjectTable")
            });
        }
        public async Task LoadScript()
        {
            var provider = new FileMigrationScriptsProvider(_folderFullPath);
            var script   = await provider.GetScriptAsync(new ScriptInfo(provider)
            {
                Id   = 20190228001,
                Name = "InitDatabase",
                Path = GetFileFullName("20190228001_InitDatabase")
            });

            var expected = await File.ReadAllTextAsync(GetFileFullName("20190228001_InitDatabase"));

            script.Should().Be(expected);
        }