Release 0.8.0

What's Changed since Release 0.7.2

• Decoupling Dapper by @carl-berg in #24
• Geography parameter handling by @carl-berg in #25
• Feature/static caching by @carl-berg in #26
• Default time value by @carl-berg in #27
• Handling default values (including null) for most sql server data types by @carl-berg in #29
• Stabilizing for 0.8.0 Release by @carl-berg in #30

Some details on the changes:

• Targeting netstandard2.1 to enable some more modern development
• No longer dependent on Dapper (we don't want to complicate things for users who might use a different version of Dapper)
• Better default support of SqlServer data types to help with nullable values (including geography).
• Static caching of schema and dependency tree is now enabled by default, but can be turned off using dude.DisableStaticCaching()
• Automatic handling of foreign keys is can now be enabled with either of these methods:
  • dude.EnableAutomaticForeignKeys() which enables automatic foreign keys, but not automatic inserts of missing dependencies
  • dude.EnableAutomaticInsertOfForeignKeys() which enables automatic foreign keys and automatic inserts of missing dependencies

Full Changelog: 0.7.2...0.8.0

Release 0.8.0 - Preview 5

Better support for inserting unspecified values or null. Covers these data types (support of these types before was only partial):

• bigint
• bit
• decimal
• int
• money
• numeric
• smallint
• smallmoney
• tinyint
• float
• real
• date
• datetime2
• datetime
• datetimeoffset
• smalldatetime
• time
• char
• text
• varchar
• nchar
• ntext
• nvarchar
• binary
• varbinary
• image
• uniqueidentifier

Release 0.8.0 - Preview 4

Added default value provider for time data type

Release 0.8.0 - Preview 3

Added a new decorator that can be used to help speed up big test suites by caching and preloading schema and dependency calculations on subsequent data dude creations. Configure it like so

Dude.Configure(ctx => x.InstructionDecorators.Add(new StaticCache(ctx)));

Release 0.8.0 - Preview 2

Bugfix to handle geography parameters during inserts

Release 0.8.0 - Preview 1

Some general maintenance done in this realease:

• Replaced Dapper as a reference with raw ado.net commands
• Updated target from netstandard2.0 to netstandard2.1 and replaced Task with ValueTask
• Changed abstraction IInstructionPreProcessor to IInstructionDecorator which can run both before and after instructions have been handled
• Replaced IDbConnection/IDbTransaction abstractions with DbConnection/DbTransaction to better utilize ado.net capabilities
• Caching dependency calculations in dependency service

Release 0.7.2

Added ability to use dynamic or dictionary data when inserting, like so:

dynamic dynamicData = new ExpandoObject();
dynamicData.A = "A string";
dynamicData.B = 5;

var dictionaryData= new Dictionary<string, object>
{
    ["A"] = "A string",
    ["B"] = 5,
};

new DataDude()
    .Insert("ATable", dynamicData)
    .Insert("ATable", dictionaryData)
    .Go(connection);

Release 0.7.1

This release contains:

• Handling of multiple go statements #21

Release 0.7

Bugfixes:
#18 Could not handle null inserts for data type text

Improvements:
#17 Will now clear instructions after successful .Go(...)

Release 0.6.0

Release notes

7b991fa

• Fixed bug introduced in 0.5.1 causing not all columns to be set
• Changed api slightly to simplify setting custom column values. New version works like so

await new DataDude()
    .ConfigureCustomColumnValue((column, value) => 
    {
        if (column.Name == "Active")
        {
            value.Set(new ColumnValue(true));
        }
    })
    .Insert("Employee")
    .Go(connection);

• Added default provider value for data type real
• Added type mappings for data types real and timestamp