Contains several Extension Methods for the SqlKata library. Including but not limited to: - ToDbCommand() -- Create a System.Data.Common.DbCommand of a specified type from a Query object - AsInsert() -- Extension Overload that accepts a single Column+Value combination - AsUpdate() -- Extension Overload that accepts a single Column+Value combination Also contains helper objects that can assist with creating Select statements and WHERE clauses for evaluating single column conditions - The 'SelectStatementBuilder' will compile into a SqlKata Query. - The 'IWhereCondition' interface objects will apply their conditions to that Query.
$ dotnet add package RFBCodeWorks.SqlKata.ExtensionsThis library primarily contains extension methods for converting SqlKata.Query objects to System.Data.DbCommand objects.
This library also provides some helper objects that can be used to dynamically create SqlKata queries.
Interface that allows an object to apply a 'WHERE' clause to a SqlKata.Query
These objects represent the various 'operators' in use by the library, and ensure that a proper operator (such as '=') is supplied to the query builder.
These objects generate various types of 'Where' clauses. For example, the 'WhereNumericValue' class will accept a numeric value, a NumericOperator and a column name, then generate the following clause: "WHERE [Column] = Value" The actual sql being generated here though will be determined by the SqlKata.Compiler object that is used.