BigfootSQL by Mitch Labrador

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

 CriteriaBuilder

public class CriteriaBuilder
public class And

public class CloseGroup

public class Literal

public class OpenGroup

public class Or

public List<object> CriteriaStack

public int MaxRecords

public bool HasCriteria { get; }

public string SortBy { get; set; }

public CriteriaBuilder()

public static CriteriaBuilder Create()

public CriteriaBuilder AddField(FieldCriteria fieldCritera)

public CriteriaBuilder AddLiteral(string sql)

public CriteriaBuilder AddLiteral(string sql, string[] formatValues)

public CriteriaBuilder AddToSortBy(string sort)

public CriteriaBuilder AND(FieldCriteria fieldCritera)

public CriteriaBuilder EndsWith(string fieldName, string value)

public CriteriaBuilder EqualTo(string fieldName, object value)

public CriteriaBuilder GreaterThan(string fieldName, object value)

public CriteriaBuilder GreaterThanOrEqualTo(string fieldName, object value)

public CriteriaBuilder IN(string fieldName, int[] values)

public CriteriaBuilder InRange(string fieldName, int from, int to)

public CriteriaBuilder InRange(string fieldName, DateTime from, DateTime to)

public CriteriaBuilder InRange(string fieldName, decimal from, decimal to)

public CriteriaBuilder IsNull(string fieldName, bool value)

public CriteriaBuilder LessThan(string fieldName, object value)

public CriteriaBuilder LessThanOrEqualTo(string fieldName, object value)

public CriteriaBuilder Like(string fieldName, string value, bool fullTextSearch)

public FieldCriteria NewField(string fieldName)

public CriteriaBuilder NotEqualTo(string fieldName, object value)

public CriteriaBuilder OR(FieldCriteria fieldCritera)

public CriteriaBuilder StartsWith(string fieldName, string value)