ICompareField 接口

命名空间

ShadowSql.Identifiers

程序集

ShadowSql.Core.dll

比较运算字段

public interface ICompareField : ICompareView, ISqlValue, IOrderField, IView, IMatch, IOrderAsc, IOrderView, ISqlEntity

继承成员

IView.ViewName

IMatch.IsMatch(string)

ISqlEntity.Write(ISqlEngine, StringBuilder)

扩展方法

AggregateAsServices.AvgAs(ICompareField, string)

AggregateAsServices.DistinctCountAs(ICompareField, string)

AggregateAsServices.MaxAs(ICompareField, string)

AggregateAsServices.MinAs(ICompareField, string)

AggregateAsServices.SumAs(ICompareField, string)

ShadowSqlCoreServices.Aggregate(ICompareField, string)

ShadowSqlCoreServices.Avg(ICompareField)

ShadowSqlCoreServices.Between(ICompareField, string, string)

ShadowSqlCoreServices.Compare(ICompareField, string, string)

ShadowSqlCoreServices.DistinctCount(ICompareField)

ShadowSqlCoreServices.Equal(ICompareField, string)

ShadowSqlCoreServices.Greater(ICompareField, string)

ShadowSqlCoreServices.GreaterEqual(ICompareField, string)

ShadowSqlCoreServices.In(ICompareField, string)

ShadowSqlCoreServices.Less(ICompareField, string)

ShadowSqlCoreServices.LessEqual(ICompareField, string)

ShadowSqlCoreServices.Like(ICompareField, string)

ShadowSqlCoreServices.Max(ICompareField)

ShadowSqlCoreServices.Min(ICompareField)

ShadowSqlCoreServices.NotBetween(ICompareField, string, string)

ShadowSqlCoreServices.NotEqual(ICompareField, string)

ShadowSqlCoreServices.NotIn(ICompareField, string)

ShadowSqlCoreServices.NotLike(ICompareField, string)

ShadowSqlCoreServices.Sum(ICompareField)

ShadowSqlCoreServices.BetweenValue(ICompareView, ISqlValue, ISqlValue)

ShadowSqlCoreServices.BetweenValue<TValue>(ICompareView, TValue, TValue)

ShadowSqlCoreServices.Compare(ICompareView, CompareSymbol, ISqlValue)

ShadowSqlCoreServices.Compare(ICompareView, string, ISqlValue)

ShadowSqlCoreServices.CompareValue<TValue>(ICompareView, CompareSymbol, TValue)

ShadowSqlCoreServices.CompareValue<TValue>(ICompareView, string, TValue)

ShadowSqlCoreServices.Equal(ICompareView, ISqlValue)

ShadowSqlCoreServices.EqualValue<TValue>(ICompareView, TValue)

ShadowSqlCoreServices.Greater(ICompareView, ISqlValue)

ShadowSqlCoreServices.GreaterEqual(ICompareView, ISqlValue)

ShadowSqlCoreServices.GreaterEqualValue<TValue>(ICompareView, TValue)

ShadowSqlCoreServices.GreaterValue<TValue>(ICompareView, TValue)

ShadowSqlCoreServices.In(ICompareView, ISingleSelect)

ShadowSqlCoreServices.InValue<TValue>(ICompareView, params IEnumerable<TValue>)

ShadowSqlCoreServices.IsNull(ICompareView)

ShadowSqlCoreServices.Less(ICompareView, ISqlValue)

ShadowSqlCoreServices.LessEqual(ICompareView, ISqlValue)

ShadowSqlCoreServices.LessEqualValue<TValue>(ICompareView, TValue)

ShadowSqlCoreServices.LessValue<TValue>(ICompareView, TValue)

ShadowSqlCoreServices.LikeValue(ICompareView, string)

ShadowSqlCoreServices.NotBetweenValue(ICompareView, ISqlValue, ISqlValue)

ShadowSqlCoreServices.NotBetweenValue<TValue>(ICompareView, TValue, TValue)

ShadowSqlCoreServices.NotEqual(ICompareView, ISqlValue)

ShadowSqlCoreServices.NotEqualValue<TValue>(ICompareView, TValue)

ShadowSqlCoreServices.NotIn(ICompareView, ISingleSelect)

ShadowSqlCoreServices.NotInValue<TValue>(ICompareView, params IEnumerable<TValue>)

ShadowSqlCoreServices.NotLikeValue(ICompareView, string)

ShadowSqlCoreServices.NotNull(ICompareView)

ShadowSqlCoreServices.Desc(IOrderAsc)

方法

AggregateAs(string, string)

聚合别名(select使用) 别名不能直接参与逻辑运算

IAggregateFieldAlias AggregateAs(string aggregate, string alias)

参数

aggregate string

alias string

返回

IAggregateFieldAlias

AggregateTo(string)

聚合(逻辑运算使用)

IAggregateField AggregateTo(string aggregate)

参数

aggregate string

返回

IAggregateField