Assets 3

.NET Standard 2.0 Release - works on .NET Framework 4.6.1+ and .NET Core 2.0+

DotNetSDB Change Log:

  • changed the project structure to support the new builds using NuGet
  • removed the .NET Framework 4.7.0 version
  • added the .NET Standard 2.0 version which works from .NET Framework 4.6.1+ and .NET Core 2.0
  • removed the obsolete SQL Types reference that is no longer required

@lilpug lilpug released this Nov 7, 2017 · 1 commit to master since this release

Assets 4

DotNetSDB Change Log:

  • fixed a bug in the return_compiled_sql_string function where if you used it multiple times it would duplicate the content rather than clear it down and compiled it again

  • optimised the internal library structure by changing from the old method of query inheritance to a full polymorphism style on the query objects

  • redesigned the internal query disposal structure to be more efficient

  • added a new conversion type to the SQL Server internal converter

  • have renamed all the functions in the internal conversion classes to be inline with the correct standardisation

  • have changed all query variables to properties as the query class is just being used to store data and is being accessed externally

  • have done quite a lot of optimisation throughout the project and have added all the required XML tags

  • renamed all the property functions in the Database Connector class to start with capitals for the correct standardisation

  • Merged the split convertors and put them into their own core class to remove duplicate code and to add additional options for the future

@lilpug lilpug released this Oct 24, 2017 · 5 commits to master since this release

Assets 4

Documentation has also been updated on the website with this release

DotNetSDB Change Log:

  • changed how stored procedures interact with DotNetSDB, rather than having their own segments they are now fully integrated. This means the unique stored procedure functions have been replaced with a simple add_stored_procedure function, this function can then be used along with any of the run methods

  • updated how connections are made and combined both SQL user and SQL windows connection objects into one main object with an additional option of a connection string

  • updated the filetable extension name to SQLServerFiletableExtension rather than SqlServerFiletableExtension

  • redesigned the internal command object to have its own core function rather than duplicated code in multiple functions

  • redesigned the internal core execution methods to throw exceptions if a user is trying to run both a stored procedure and a query at the same time

  • redesigned the internal deadlock retry function to have its own core function that gets called by the others rather than duplicated code

  • added windows authentication connection support for MySQL along with the added option of supplying a connection string

  • updated the connection objects to now use IDisposable to ensure any sensitive connection data is disposed of the moment the connection is finished

  • fixed a bug where the XML documentation was not displaying, this was due to how the DLLs get merged and then used in the NuGet package, this process has now changed and the NuGet package now references the SQL Server types and MySQL data DLLs via dependency options

  • changed the build process and removed the merge DLL process as its not really required for direct downloading and NuGet now manages our dependencies

@lilpug lilpug released this Jul 17, 2017 · 6 commits to master since this release

Assets 4

DotNetSDB Change Log:

  • made optimizations by switching strings that are building to StringBuilders for better memory and performance.
  • changed spelling mistake from sanatisation to sanitisation.

@lilpug lilpug released this May 26, 2017 · 8 commits to master since this release

Assets 4

Documentation has also been updated on the website with this release

DotNetSDB Change Log:

  • Changed the OutputManagementSettings to take in a TimeZoneInfo rather than a DateTime, this helps to ensure the timestamp is more accurate as we generate the DateTime using the TimeZone at runtime
  • Changed the sqlServer2008, sqlServer2012, sqlServer2014 and sqlServer2016 to all be the correct standards as everything else now "SQLServer2008, SQLServer2012, SQLServer2014 and SQLServer2016"
  • Fixed a bug in the name "MySLQCore" to "MySQLCore"
  • Added a PowerShell wrapper and example
  • Changed the assemblies copyright notice to add MIT in as it seems to have been missed out
  • Added a build for .NET Framework 4.7
  • Updated the Microsoft.sqlserver.types & MySQL.Data DLL versions

@lilpug lilpug released this Apr 11, 2017 · 11 commits to master since this release

Assets 3

Documentation has also been updated on the website with this release

DotNetSDB Change Log:

  • changed all the string.format tags to shorthand $"" versions
  • fixed some bugs in the FileTable extension section that still referenced old function names but as they its using a dynamic objects did not flag up.
  • added new update functions to the FileTable extension to be able to move directories and files to different folders or to the root structure.

@lilpug lilpug released this Mar 10, 2017 · 12 commits to master since this release

Assets 3

Documentation has now been fully released on the website with this release

DotNetSDB Change Log:

  • fixed a bug in the run_return_json() function which caused it to fail on the conversion before returning data back
  • fixed a bug in the run_bulk_copy() function which was making the function fail before even executing the query
  • updated the compiled folder names to match nuget packages correctly

@lilpug lilpug released this Mar 5, 2017 · 13 commits to master since this release

Assets 3

Documentation has been release but slight bits are still in development.

DotNetSDB Change Log:

  • removed the function string add_pure_sql_bind_array_to_string(object values) as it uses the array binding version and simply a string.join which can be done at application level
  • bug fix in the add_groupby function which was not detecting the table being passed.
  • changed add_update_fields = add_update_additions as we are adding fields and values so the function name is now more appropriate
  • changed the truncate_table return type from bool to void, it would always return true if no error occured so it made no difference having a return type
  • changed the table_get_fields function name to table_fields for a better standard
  • changed some of the virtual override structure methods to be in their own functions

SQL Server return functions are now their own functions and not an extra parameter:

  • add_delete(string tableName, bool returnDeleted = false) = add_delete_return(string tableName)
  • add_insert(string tableName, bool returnInsert = false) = add_insert_return(string tableName)
  • add_insert(string tableName, string field, bool returnInsert = false) = add_insert_return(string tableName, string field)
  • add_insert(string tableName, string[] fields, bool returnInsert = false) = add_insert_return(string tableName, string[] fields)
  • add_insert(string tableName, object values, bool returnInsert = false) = add_insert_return(string tableName, object values)
  • add_insert(string tableName, string field, object value, bool returnInsert = false) = add_insert_return(string tableName, string field, object value)
  • add_insert(string tableName, string[] fields, object values, bool returnInsert = false) = add_insert_return(string tableName, string[] fields, object values)
  • add_update(string tableName, string field, object value, bool returnUpdated = false) = add_update_return(string tableName, string field, object value)
  • add_update(string tableName, string[] fields, object values, bool returnUpdated = false) = add_update_return(string tableName, string[] fields, object values)

@lilpug lilpug released this Feb 28, 2017 · 14 commits to master since this release

Assets 3

fixed a bug which was caused by the cleaning up in 1.0.2, the bug caused parameter binding to start at the index of 0 instead of 1 in the "SanitisationProcess" functions.

@lilpug lilpug released this Feb 23, 2017 · 16 commits to master since this release

Assets 3

Change Log:

  • Changed the class name MysqlCore to MySQLCore to be more standard
  • Added an extra parameter for all the connection instances to be able to add extra connection string information if required, by default its null
  • Updated the connection core in both my MySQL and Sql Server instances to support the new connection string information if its passed
  • Massive changes to the name of parameters and internal functions to be in a standard format, the project had different variations of underscore and camelcase due to being built over many years "now a standard for public and private variables and methods"
  • Changed how strings are concatenated together, instead of using + symbols now use string.format as a standard for everything
  • Changed how the sql output method works as there was a bug which would only output the correct binding value once if it was used multiple times in a query.
  • Changed the function sql_real_output to return_compiled_sql_string for a more practical name