TableSqlQuery<TTable> 类

命名空间

ShadowSql.Tables

程序集

ShadowSql.dll

sql查询表

public class TableSqlQuery<TTable> : DataFilterBase<TTable, SqlQuery>, IDataSqlQuery, IDataFilter, ITableView, IWhere, ISqlEntity where TTable : ITable

类型参数

TTable

继承

object

GetFieldBase

ViewBase

TableViewBase

FilterBase

DataFilterBase<TTable, SqlQuery>

TableSqlQuery<TTable>

实现

IDataSqlQuery

IDataFilter

ITableView

IWhere

ISqlEntity

Derived

DapperTableSqlQuery<TTable>

继承成员

DataFilterBase<TTable, SqlQuery>._source

DataFilterBase<TTable, SqlQuery>.Source

DataFilterBase<TTable, SqlQuery>.GetFields()

DataFilterBase<TTable, SqlQuery>.GetField(string)

DataFilterBase<TTable, SqlQuery>.GetCompareField(string)

DataFilterBase<TTable, SqlQuery>.NewField(string)

DataFilterBase<TTable, SqlQuery>.WriteSource(ISqlEngine, StringBuilder)

DataFilterBase<TTable, SqlQuery>.WriteFilter(ISqlEngine, StringBuilder)

FilterBase.WriteSource(ISqlEngine, StringBuilder)

FilterBase.WriteFilter(ISqlEngine, StringBuilder)

FilterBase.FilterPrefix(ISqlEngine, StringBuilder)

FilterBase.WriteCore(ISqlEngine, StringBuilder)

ViewBase.GetFields()

ViewBase.GetCompareField(string)

GetFieldBase.GetField(string)

GetFieldBase.NewField(string)

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

扩展方法

ShadowSqlServices.ToSingle(IDataFilter, IFieldView)

ShadowSqlServices.ToSingle(IDataFilter, string)

DapperShadowCoreServices.Count(ITableView, IExecutor, object?)

DapperShadowCoreServices.CountAsync(ITableView, IExecutor, object?)

DapperShadowCoreServices.LongCount(ITableView, IExecutor, object?)

DapperShadowCoreServices.LongCountAsync(ITableView, IExecutor, object?)

ShadowSqlCoreServices.AsExists(ITableView)

ShadowSqlCoreServices.AsNotExists(ITableView)

ShadowSqlCoreServices.Field(ITableView, string)

ShadowSqlCoreServices.Fields(ITableView, params IEnumerable<string>)

ShadowSqlCoreServices.Strict(ITableView, string)

DapperShadowServices.ToDapperDelete<TSource>(TableSqlQuery<TSource>, IExecutor)

DapperShadowServices.ToDapperSelect<TTable>(TableSqlQuery<TTable>, IExecutor)

FieldQueryServices.FieldBetweenValue<TQuery, TValue>(TQuery, string, TValue, TValue)

FieldQueryServices.FieldBetween<TQuery>(TQuery, string, string, string)

FieldQueryServices.FieldEqualValue<TQuery, TValue>(TQuery, string, TValue)

FieldQueryServices.FieldEqual<TQuery>(TQuery, string, string)

FieldQueryServices.FieldGreaterEqualValue<TQuery, TValue>(TQuery, string, TValue)

FieldQueryServices.FieldGreaterEqual<TQuery>(TQuery, string, string)

FieldQueryServices.FieldGreaterValue<TQuery, TValue>(TQuery, string, TValue)

FieldQueryServices.FieldGreater<TQuery>(TQuery, string, string)

FieldQueryServices.FieldInValue<TQuery, TValue>(TQuery, string, params IEnumerable<TValue>)

FieldQueryServices.FieldIn<TQuery>(TQuery, string, string)

FieldQueryServices.FieldIsNull<TQuery>(TQuery, string)

FieldQueryServices.FieldLessEqualValue<TQuery, TValue>(TQuery, string, TValue)

FieldQueryServices.FieldLessEqual<TQuery>(TQuery, string, string)

FieldQueryServices.FieldLessValue<TQuery, TValue>(TQuery, string, TValue)

FieldQueryServices.FieldLess<TQuery>(TQuery, string, string)

FieldQueryServices.FieldLikeValue<TQuery>(TQuery, string, string)

FieldQueryServices.FieldLike<TQuery>(TQuery, string, string)

FieldQueryServices.FieldNotBetweenValue<TQuery, TValue>(TQuery, string, TValue, TValue)

FieldQueryServices.FieldNotBetween<TQuery>(TQuery, string, string, string)

FieldQueryServices.FieldNotEqualValue<TQuery, TValue>(TQuery, string, TValue)

FieldQueryServices.FieldNotEqual<TQuery>(TQuery, string, string)

FieldQueryServices.FieldNotInValue<TQuery, TValue>(TQuery, string, params IEnumerable<TValue>)

FieldQueryServices.FieldNotIn<TQuery>(TQuery, string, string)

FieldQueryServices.FieldNotLikeValue<TQuery>(TQuery, string, string)

FieldQueryServices.FieldNotLike<TQuery>(TQuery, string, string)

FieldQueryServices.FieldNotNull<TQuery>(TQuery, string)

FieldQueryServices.FieldParameter<TQuery>(TQuery, string, string, string)

FieldQueryServices.FieldValue<TQuery, TValue>(TQuery, string, TValue, string)

ShadowSqlCoreServices.Apply<Query>(Query, Func<SqlQuery, ITableView, SqlQuery>)

ShadowSqlCoreServices.Apply<Query>(Query, Func<SqlQuery, SqlQuery>)

ShadowSqlCoreServices.Exists<Query>(Query, ITableView)

ShadowSqlCoreServices.In<Query>(Query, ICompareView, ISingleSelect)

ShadowSqlCoreServices.NotExists<Query>(Query, ITableView)

ShadowSqlCoreServices.NotIn<Query>(Query, ICompareView, ISingleSelect)

ShadowSqlCoreServices.ToAnd<Query>(Query)

ShadowSqlCoreServices.ToOr<Query>(Query)

ShadowSqlCoreServices.Where<Query>(Query, AtomicLogic)

ShadowSqlCoreServices.Where<Query>(Query, params IEnumerable<string>)

ShadowSqlCoreServices.Where<Query>(Query, Func<ITableView, AtomicLogic>)

ShadowSqlServices.SqlGroupBy<TTable>(TableSqlQuery<TTable>, params IField[])

ShadowSqlServices.SqlGroupBy<TTable>(TableSqlQuery<TTable>, params IEnumerable<string>)

ShadowSqlServices.SqlGroupBy<TTable>(TableSqlQuery<TTable>, Func<TTable, IField[]>)

ShadowSqlServices.ToCursor<TTable>(TableSqlQuery<TTable>, int, int)

ShadowSqlServices.ToDelete<TSource>(TableSqlQuery<TSource>)

ShadowSqlServices.ToSelect<TTable>(TableSqlQuery<TTable>)

ShadowSqlServices.ToSingle<TTable>(TableSqlQuery<TTable>, Func<TTable, IFieldView>)

StrictQueryServices.StrictBetweenValue<TQuery, TValue>(TQuery, string, TValue, TValue)

StrictQueryServices.StrictBetween<TQuery>(TQuery, string, string, string)

StrictQueryServices.StrictEqualValue<TQuery, TValue>(TQuery, string, TValue)

StrictQueryServices.StrictEqual<TQuery>(TQuery, string, string)

StrictQueryServices.StrictGreaterEqualValue<TQuery, TValue>(TQuery, string, TValue)

StrictQueryServices.StrictGreaterEqual<TQuery>(TQuery, string, string)

StrictQueryServices.StrictGreaterValue<TQuery, TValue>(TQuery, string, TValue)

StrictQueryServices.StrictGreater<TQuery>(TQuery, string, string)

StrictQueryServices.StrictInValue<TQuery, TValue>(TQuery, string, params IEnumerable<TValue>)

StrictQueryServices.StrictIn<TQuery>(TQuery, string, string)

StrictQueryServices.StrictIsNull<TQuery>(TQuery, string)

StrictQueryServices.StrictLessEqualValue<TQuery, TValue>(TQuery, string, TValue)

StrictQueryServices.StrictLessEqual<TQuery>(TQuery, string, string)

StrictQueryServices.StrictLessValue<TQuery, TValue>(TQuery, string, TValue)

StrictQueryServices.StrictLess<TQuery>(TQuery, string, string)

StrictQueryServices.StrictLikeValue<TQuery>(TQuery, string, string)

StrictQueryServices.StrictLike<TQuery>(TQuery, string, string)

StrictQueryServices.StrictNotBetweenValue<TQuery, TValue>(TQuery, string, TValue, TValue)

StrictQueryServices.StrictNotBetween<TQuery>(TQuery, string, string, string)

StrictQueryServices.StrictNotEqualValue<TQuery, TValue>(TQuery, string, TValue)

StrictQueryServices.StrictNotEqual<TQuery>(TQuery, string, string)

StrictQueryServices.StrictNotInValue<TQuery, TValue>(TQuery, string, params IEnumerable<TValue>)

StrictQueryServices.StrictNotIn<TQuery>(TQuery, string, string)

StrictQueryServices.StrictNotLikeValue<TQuery>(TQuery, string, string)

StrictQueryServices.StrictNotLike<TQuery>(TQuery, string, string)

StrictQueryServices.StrictNotNull<TQuery>(TQuery, string)

StrictQueryServices.StrictParameter<TQuery>(TQuery, string, string, string)

StrictQueryServices.StrictValue<TQuery, TValue>(TQuery, string, TValue, string)

构造函数

TableSqlQuery(TTable, SqlQuery)

sql查询表

public TableSqlQuery(TTable table, SqlQuery query)

参数

table TTable

query SqlQuery

方法

Apply(Func<SqlQuery, TTable, SqlQuery>)

查询

public TableSqlQuery<TTable> Apply(Func<SqlQuery, TTable, SqlQuery> query)

参数

query Func<SqlQuery, TTable, SqlQuery>

返回

TableSqlQuery<TTable>

Where(Func<TTable, AtomicLogic>)

按逻辑查询

public TableSqlQuery<TTable> Where(Func<TTable, AtomicLogic> query)

参数

query Func<TTable, AtomicLogic>

返回

TableSqlQuery<TTable>