SqlBinder

Free and open-source library that helps you create complex and reusable SQL.

APACHE-2.0 License

Stars
23

Bot releases are visible (Hide)

SqlBinder - Latest Release

Published by bawkee over 5 years ago

  • SqlBinder is now on .Net Standard 2.0.
  • Tutorial was lagging behind, it is up to date now.
  • All the samples (including the Demo App) are now on .Net Framework 4.7.
  • Extended the Dapper samples.
  • After a year, SqlBinder hasn't changed much, moving to Beta.
SqlBinder - v0.2.0-alpha

Published by bawkee over 6 years ago

  • Many new SetCondition overloads added for simplicity. Overloads accepting ranges are now in a separate method with its own overloads SetConditionRange.
  • Null handling in aforementioned methods has been improved, it is ignored where it makes no sense (rather than throwing ArgumentException). Where both behaviours may be desired, ignoreIfNull argument has been added. The idea is to allow a condition to be passed with a single line of code.
  • New flag/prefix has been added to scopes so now you may specify +{ORDER BY ...} in a query and what this is means is that this specific scope won't be automatically connected by AND with its previous sibling.
  • Default ConditionValue implementations now all use <> negation operator (T-SQL standard) instead of !=.
SqlBinder -

Published by bawkee over 6 years ago

  • Polished the API. From this point on, software using SqlBinder should be forward compatible with later version.
  • Developed a new parser and processor that doesn't rely on Regex. While Regex is very fast it was suboptimal for this scenario and the performance has been more than doubled.
SqlBinder - First preview

Published by bawkee over 6 years ago

This is first public pre-release with downloadable binaries.