BigfootSQL by Mitch Labrador

<PackageReference Include="BigfootSQL" Version="1.0.1" />

 SqlHelper

public class SqlHelper
public interface ITypeConverter

public class SqlRecord

public string ConnectionString

public string ModuleQualifier

public string Owner

public string ProviderName

public string Qualifier

public string DebugSql { get; }

public List<DbParameter> Params { get; }

public StringBuilder RawBuilder { get; }

public SqlHelper()

public SqlHelper(string connectionString)

public SqlHelper(string owner, string qualifier, string moduleQualifier, string connectionString)

public static void AddTypeConverter(string typeName, ITypeConverter converter)

public static string ArrayToINint(int[] ps)

public static string ArrayToINint(string[] ps)

public static string ArrayToINstring(string[] ps)

public static string EscapeApostrophe(string sql)

public static string EscapeForLike(string value, bool escapeApostrophe)

public static List<T> FillCollection<T>(DbDataReader reader)

public static T FillObject<T>(DbDataReader dr)

public static Dictionary<string, string> GetTokens(string s, string startDelimiter, string endDelimiter)

public static Dictionary<string, string> GetTokens(string s, Dictionary<string, string> tokens, string startDelimiter, string endDelimiter)

public static object GetValue(Type fieldType, object value)

public SqlHelper Add(string sql)

public SqlHelper Add(SqlHelper sql)

public SqlHelper Add(string wherecolumn, object value)

public SqlHelper Add(string wherecolumn, object value, bool isSet)

public SqlHelper Add(string wherecolumn, string operator, object value)

public SqlHelper Add(string wherecolumn, string operator, object value, bool isSet)

public SqlHelper AddIf(bool condition, string wherecolumn, string operator, object value)

public SqlHelper AddParam(string name, object value)

public SqlHelper AddProcParam(string name, object value, bool addcomma = false)

public string AddTempParam(object value)

public string AddTempParam(object value, string prefix)

public SqlHelper AND()

public SqlHelper AND(string sql)

public SqlHelper AND(string column, object value)

public SqlHelper AND(string column, string operator, object value)

public SqlHelper AND_BETWEEN(string column, DateTime startValue, DateTime endValue)

public SqlHelper ANDISNOTNULL(string columnName)

public SqlHelper ANDISNULL(string columnName)

public SqlHelper AS(string columnName)

public SqlHelper BETWEEN(string column, object startValue, object endValue)

public SqlHelper BETWEEN(string value, string startColumn, string endColumn)

public SqlHelper CASE()

public SqlHelper CASE(string condition, string trueResult, string falseResult)

public void Clear()

public SqlHelper Contains(string wherecolumn, string value)

public SqlHelper CP()

public DbConnection CreateDbConnection(bool openConnection)

public DataSet DbExecuteDataset(CommandType commandType, string commandText, DbParameter[] commandParameters)

public int DbExecuteNonQuery(CommandType commandType, string commandText, DbParameter[] commandParameters)

public DbDataReader DbExecuteReader(CommandType commandType, string commandText, IEnumerable<DbParameter> commandParameters)

public object DbExecuteScalar(CommandType commandType, string commandText, DbParameter[] commandParameters)

public SqlHelper DECLARE(string varname, string vartype)

public SqlHelper DECLARE(string varname, string vartype, object value)

public SqlHelper DECLARE_TABLE(string varname, string columns)

public SqlHelper DELETEFROM(string sql)

public SqlHelper ELSE(string elseResult)

public SqlHelper END()

public SqlHelper EndsWith(string wherecolumn, string value)

public SqlHelper EXECUTE(string spname)

public SqlHelper EXECUTE(string spname, object[] ps)

public List<T> ExecuteCollection<T>()

public int ExecuteNonquery()

public T ExecuteObject<T>()

public object ExecuteScalar()

public T ExecuteScalar<T>()

public bool ExecuteScalarBool()

public decimal ExecuteScalarDecimal()

public int ExecuteScalarIdentity()

public int ExecuteScalarInt()

public string ExecuteScalarString()

public List<string> ExecuteStringCollection()

public Dictionary<string, object> ExecuteValues()

public SqlHelper FROM(string sql)

public SqlHelper FROM(SqlHelper sql, string alias)

public Dictionary<string, object> GetObjectProperties(object data, string includeOnlyTheseProperties, string excludeTheseProperties)

public SqlHelper GO()

public SqlHelper GROUPBY(string sql)

public SqlHelper HAVING(string sql)

public SqlHelper IN(string columnname, int value)

public SqlHelper IN(string columnname, string value)

public SqlHelper IN(string columnname, string[] values)

public SqlHelper IN(string columnname, bool searchAsIntArray, string[] values)

public SqlHelper IN(string columnname, int[] values)

public SqlHelper IN(string columnname, SqlHelper sql)

public SqlHelper INNERJOIN(string sql)

public SqlHelper INNERJOIN(SqlHelper sql, string alias)

public SqlHelper INSERTDICTIONARY(string tableName, Dictionary<string, object> insertData)

public SqlHelper INSERTINTO(string tablename, string columns)

public SqlHelper INSERTOBJECT(string tableName, object data)

public SqlHelper INSERTOBJECT(string tableName, object data, string includeOnlyTheseColumns, string excludeTheseColumns)

public SqlHelper ISNOTNULL(string columnName)

public SqlHelper ISNULL(string columnName)

public SqlHelper LEFTJOIN(string sql)

public SqlHelper LEFTJOIN(SqlHelper sql, string alias)

public SqlHelper LIKE(string wherecolumn, string value)

public SqlHelper LIKE(string wherecolumn, string value, bool fullTextSearch)

public SqlHelper MergeSqlHelper(SqlHelper helperToMergeIn)

public SqlHelper New()

public SqlHelper ON(string sql)

public SqlHelper ON(string leftcolumn, string rightcolumn)

public SqlHelper OP()

public SqlHelper OP(string wherecolumn, object value)

public SqlHelper OpenParenthesis(string wherecolumn, object value)

public SqlHelper OR()

public SqlHelper OR(string sql)

public SqlHelper OR(string column, object value)

public SqlHelper OR(string column, string operator, object value)

public SqlHelper OR_BETWEEN(string column, DateTime startValue, DateTime endValue)

public SqlHelper ORDERBY(string sql)

public SqlHelper ORISNOTNULL(string columnName)

public SqlHelper ORISNULL(string columnName)

public SqlHelper OUTERJOIN(string sql)

public SqlHelper OUTERJOIN(SqlHelper sql, string alias)

public SqlHelper PAGE(int currentpage)

public SqlHelper SELECT(string sql)

public SqlHelper SELECT(string[] columns)

public SqlHelper SELECT_ALL_FROM(string tablename)

public SqlHelper SELECT_ALL_FROM(string tablename, int topCount)

public SqlHelper SELECT_COUNT_ALL_FROM(string tablename)

public SqlHelper SELECT_COUNT_ALL_FROM(SqlHelper query, string alias)

public SqlHelper SELECT_SCALARFUNCTION(string fname, object[] ps)

public SqlHelper SELECT_TOP(int max, string sql)

public SqlHelper SELECTPAGED(string columns, string pageorderby, int pageSize)

public SqlHelper SET()

public SqlHelper SET(string columnname, object value)

public SqlHelper SET_IDENTITY_INSERT_OFF(string tablename)

public SqlHelper SET_IDENTITY_INSERT_ON(string tablename)

public SqlHelper StartsWith(string wherecolumn, string value)

public string Translate(string sql)

public SqlHelper UNIONALL(string sql)

public SqlHelper UPDATE(string sql)

public SqlHelper UPDATEDICTIONARY(string tableName, Dictionary<string, object> updateData)

public SqlHelper UPDATEOBJECT(string tableName, object data)

public SqlHelper UPDATEOBJECT(string tableName, object data, string includeOnlyTheseColumns, string excludeTheseColumns)

public SqlHelper VALUES(string sql)

public SqlHelper VALUES(object[] ps)

public SqlHelper WHEN(string condition, string trueResult)

public SqlHelper WHERE()

public SqlHelper WHERE(string sql)

public SqlHelper WHERE(string columnname, object value)

public SqlHelper WHERE(string columnname, string operator, object value)

public SqlHelper WHEREOR()