What's Changed

• FluentMigrator.MSBuild and FluentMigrator.DotNet.Cli now support .net 9.0
• Support for net6.0 and net7.0 is dropped, as it is end of life by Microsoft.
• FluentMigrator now has a detailed integration testing suite that runs tests on docker containers using images provided by every major database provider (where possible). Thanks to @PhenX
• Bug fixes
• Dependency updates
• Minor improvements

End of Life Support Changes

• Remove net6.0 and net7.0 support. Support net8.0 by @jzabroski in https://github.com/fluentmigrator/fluentmigrator/pull/1986

Bug fixes

• RawSql.Insert cannot be used as entire Where clause or Set clause in UpdateDataExpression/DeleteDataExpression by @PhenX in https://github.com/fluentmigrator/fluentmigrator/pull/1904
• Fix auto reversing with insert data by @AdrianoRNascimento in https://github.com/fluentmigrator/fluentmigrator/pull/1963
• Typo: No migration generator registerd -> "registered" by @jzabroski in https://github.com/fluentmigrator/fluentmigrator/pull/1926

Removing Code that has been marked Obsolete for 7 years :) 🥳

• Remove Obsolete DeleteIndexExpressionBuilder.CurrentColumn by @jzabroski in https://github.com/fluentmigrator/fluentmigrator/pull/1993
• Remove IAssemblyCollection and associated obsolete constructors/properties by @jzabroski in https://github.com/fluentmigrator/fluentmigrator/pull/1995
• Remove most of LegacyExtensions functionality by @jzabroski in https://github.com/fluentmigrator/fluentmigrator/pull/1997
• Remove IMigrationRunner.RunnerContext and MigrationRunner.RunnerContext by @jzabroski in https://github.com/fluentmigrator/fluentmigrator/pull/1999
• Remove obsolete ctor on DefaultConventionSet by @jzabroski in https://github.com/fluentmigrator/fluentmigrator/pull/2003
• Please Support .NET 9 in FluentMigrator.DotNet.Cli by @jzabroski in https://github.com/fluentmigrator/fluentmigrator/pull/2013

Dependency Injection improvements

• #1836: Support custom IVersionTableMetaData DI registration before AddFluentMigratorCore call by @warappa in https://github.com/fluentmigrator/fluentmigrator/pull/1842

Generator improvements

• Use database function to set the value of AppliedOn by @nathanpovo in https://github.com/fluentmigrator/fluentmigrator/pull/1847
  • This will especially help users who use preview scripts generated via the connectionless processor, for environments where scripts are reviewed by DBAs prior to being deployed to production.

MySQL improvements

• Added support for typeMap injection in MySqlGenerator by @maxc0de in https://github.com/fluentmigrator/fluentmigrator/pull/1914
• Correct AddMySql8 XML Documentation by @vermiceli in https://github.com/fluentmigrator/fluentmigrator/pull/1935
• Incorrect syntax for renaming a column with a default method in MySQL #1911 (Fix Column Renaming Syntax for MySQL 8) by @Cretesh-Anuj in https://github.com/fluentmigrator/fluentmigrator/pull/1945

FluentMigrator.MSBuild improvements

• Improve MicrosoftBuildLogger. by @teo-tsirpanis in https://github.com/fluentmigrator/fluentmigrator/pull/1905
• Add AllowDirtyAssemblies switch to MSBuild custom task by @jzabroski in https://github.com/fluentmigrator/fluentmigrator/pull/1903
• Address build failure from FluentMigrator.MSBuild sample by @jzabroski in https://github.com/fluentmigrator/fluentmigrator/pull/1906
• Add comment explaining use of TargetFrameworks vs. TargetFramework by @jzabroski in https://github.com/fluentmigrator/fluentmigrator/pull/1909
• Update FluentMigrator.Example.MSBuild.csproj by @jzabroski in https://github.com/fluentmigrator/fluentmigrator/pull/1913

Testing improvements

• Use test containers to facilitate running various integration tests by @PhenX in https://github.com/fluentmigrator/fluentmigrator/pull/1931
• Feature/nunit testcasesource by @PhenX in https://github.com/fluentmigrator/fluentmigrator/pull/1984
• Add justification to all Assert.Ignore calls when processor is not en… by @PhenX in https://github.com/fluentmigrator/fluentmigrator/pull/2001

Dependency Bumps

• Bump Microsoft.Data.Sqlite from 8.0.8 to 8.0.10 in the database-driver-dependencies group by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1915
• Bump the core-dependencies group with 6 updates by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1916
• Bump NUnit.Console from 3.18.2 to 3.18.3 in the test-dependencies group by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1917
• Bump FSharp.Core from 8.0.400 to 8.0.401 in the other-dependencies group by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1918
• Bump Autofac from 8.1.0 to 8.1.1 in the core-dependencies group by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1923
• Bump the database-driver-dependencies group across 1 directory with 2 updates by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1928
• Bump JetBrains.Annotations from 2024.2.0 to 2024.3.0 in the other-dependencies group by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1930
• Bump Snowflake.Data from 4.1.0 to 4.2.0 in the database-driver-dependencies group by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1933
• Bump FSharp.Core from 8.0.401 to 9.0.100 in the other-dependencies group by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1938
• Bump the core-dependencies group with 7 updates by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1937
• Bump the database-driver-dependencies group across 1 directory with 4 updates by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1936
• Bump NUnit.Analyzers from 4.3.0 to 4.4.0 in the test-dependencies group by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1939
• Bump SourceLink.Embed.AllSourceFiles from 2.8.0 to 2.8.3 by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1947
• Update dependabot.yml by @jzabroski in https://github.com/fluentmigrator/fluentmigrator/pull/1970
• Bump SourceLink.Create.CommandLine from 2.8.0 to 2.8.3 by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1948
• add code coverage badge by @jzabroski in https://github.com/fluentmigrator/fluentmigrator/pull/1844
• Bump SourceLink.Copy.PdbFiles from 2.8.0 to 2.8.3 by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1946
• Bump the database-driver-dependencies group across 1 directory with 3 updates by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1956
• Bump the test-dependencies group across 1 directory with 4 updates by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1957
• Bump the test-dependencies group across 1 directory with 6 updates by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1972

Continuous Integration / Continuous Delivery improvements

• Update azure-pipelines.yml by @jzabroski in https://github.com/fluentmigrator/fluentmigrator/pull/1922
• Create GH Action to update TargetFramework weekly by @jzabroski in https://github.com/fluentmigrator/fluentmigrator/pull/1980
• Update update-targetframework.yaml by @jzabroski in https://github.com/fluentmigrator/fluentmigrator/pull/1985

Documentation improvements

• #1924 Replaced gitter.im references with github discussions by @MichaelPGudz in https://github.com/fluentmigrator/fluentmigrator/pull/1929
• Update README.md by @jzabroski in https://github.com/fluentmigrator/fluentmigrator/pull/1976

New Contributors

• @teo-tsirpanis made their first contribution in https://github.com/fluentmigrator/fluentmigrator/pull/1905
• @maxc0de made their first contribution in https://github.com/fluentmigrator/fluentmigrator/pull/1914
• @nathanpovo made their first contribution in https://github.com/fluentmigrator/fluentmigrator/pull/1847
• @MichaelPGudz made their first contribution in https://github.com/fluentmigrator/fluentmigrator/pull/1929
• @vermiceli made their first contribution in https://github.com/fluentmigrator/fluentmigrator/pull/1935
• @Cretesh-Anuj made their first contribution in https://github.com/fluentmigrator/fluentmigrator/pull/1945
• @AdrianoRNascimento made their first contribution in https://github.com/fluentmigrator/fluentmigrator/pull/1963

Help Wanted

The main area we could use help right now is with fluentmigrator/documentation repository and automating the documentation release process further. Additionally, fixing build related warnings for missing MSDoc comments would be extremely appreciated.

Full Changelog: https://github.com/fluentmigrator/fluentmigrator/compare/v6.2.0...v7.0.0