v2.3.0

Available on NuGet at https://www.nuget.org/packages/IntegrationTestingLibraryForSqlServer

• Added .net standard 2.0 as additional target framework
• Added ability to grant SQL Auth user to a database
• Added helper classes to make it easier to create objects

v2.2.0

Available on NuGet at https://www.nuget.org/packages/IntegrationTestingLibraryForSqlServer

• Added ObjectPopulatedTableData class to allow for populating a TableData from an IEnumerable
• DBNull is now handled better when both passed as a string "DBNull" and conversion from null objects
• TableActions method added to DatabaseActions so that the connection string can be passed form DatabaseActions
• Minor additional properties and helper methods

v2.1.0

Available on NuGet at https://www.nuget.org/packages/IntegrationTestingLibraryForSqlServer

• Procedure and table definition classes now have strongly-typed collections for parameters and columns respectively
• New extension methods on new ProcedureParameterCollection and ColumnDefinitionCollection: AddStandard, AddInteger, AddBinary, AddDecimal, AddString.

v2.0.1

Available on NuGet at https://www.nuget.org/packages/IntegrationTestingLibraryForSqlServer

• Code generation for TableDefinition has been fixed

v2.0.0

Incorporated version two functionality:

• Columns and Procedures are now strongly-typed based on their characteristics
• Schemas are better supported
• Validation of values can now be done when they are set rather than at usage
• Support for C# Table Definition code generation (more to come!)
• Reworked Decimal vs Numeric differences
• Numerous code improvements and bug fixes

See migrating from v1 for breaking changes when upgrading.

v1.5.9

• Added proper validation for identity seed in ColumnDefinition

v1.5.8

Available on NuGet at https://www.nuget.org/packages/IntegrationTestingLibraryForSqlServer

• Added TableData comparers for booleans and numbers
• Aligned properties in ColumnDefinition and ProcedureParameter

v1.5.7

  * BREAKING CHANGE FOR DECIMAL COLUMNS WITH PRECISION AND SCALE.
  * Columns defined as Numeric in the database must be defined as Decimal in this library.
    This is because the SqlDataType Enum does not have a value for numeric.
  * SQL Decimals have a Precision (max number of digits) and a Scale (number of digits after the decimal point).
    In this library Precision maps to Size and Scale maps to DecimalPlaces for numeric/decimal columns.
    eg :-
    | Name          | Data Type | Size | Decimal Places |
    | DecimalColumn | decimal   | 10   | 5              |
    instead of :-
    | Name          | Data Type | Precision | Scale |
    | DecimalColumn | decimal   | 10        | 5     |

v1.5.6

Available on NuGet at https://www.nuget.org/packages/IntegrationTestingLibraryForSqlServer

• Added alternative strategies for checking view definitions in ViewCheck.VerifyMatch and VerifyMatchOrSubset

v1.5.5

Available on NuGet at https://www.nuget.org/packages/IntegrationTestingLibraryForSqlServer

• Added support for custom table data value transformations
• Added value transformer to support string to DBNull conversion