Xledger.Sql 1.0.0

Xledger.Sql

Xledger.Sql on Github

Xledger.Sql provides tools for analyzing and transforming Transact SQL queries. This is provided in 3 main pieces:

1. Xledger.Sql.ScopedFragmentTransformer: a TSqlFragment visitor that tracks the scope of visits to ease context-aware rewrites.
2. Xledger.Sql.Extensions: providing a ReplaceScalar extension method to replace one scalar in its parent with a new scalar - without having to know exactly where in the parent the old scalar was present.
3. Xledger.Sql.ImmutableDom: an immutable version of Microsoft.SqlServer.TransactSql.ScriptDom to enable caching parts of a SQL DOM or structural comparison of them.

The tests in Xledger.Sql.Test demonstrate how to use this library.

Testing Locally

To generate a new NuGet package to verify that the package is sane.

1. Increment the <VersionSuffix> in Xledger.Sql/Xledger.Sql.csproj; or <VersionPrefix> if releasing a new major, minor, or patch version.
2. Run. For Release:

cls; dotnet clean; dotnet pack -c Release;
nuget init Xledger.Sql\bin\Release c:\packages;

For Debug:

cls; dotnet clean; dotnet pack;
nuget init Xledger.Sql\bin\Debug c:\packages;

3. Update the project that depends on Xledger.Sql.

dotnet add package Xledger.Sql --source c:\packages --prerelease

Running the Tests

dotnet test Xledger.Sql.Test

To list the available tests:

dotnet test Xledger.Sql.Test --list-tests