TableSqlQuery 类

命名空间

ShadowSql.Tables

程序集

ShadowSql.Core.dll

sql查询表

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

继承

object

GetFieldBase

ViewBase

TableViewBase

FilterBase

DataFilterBase<SqlQuery>

TableSqlQuery

实现

IDataSqlQuery

IDataFilter

ITableView

IWhere

ISqlEntity

继承成员

DataFilterBase<SqlQuery>._source

DataFilterBase<SqlQuery>.Source

DataFilterBase<SqlQuery>.Filter

DataFilterBase<SqlQuery>.GetFields()

DataFilterBase<SqlQuery>.GetField(string)

DataFilterBase<SqlQuery>.GetCompareField(string)

DataFilterBase<SqlQuery>.NewField(string)

DataFilterBase<SqlQuery>.WriteSource(ISqlEngine, StringBuilder)

DataFilterBase<SqlQuery>.WriteFilter(ISqlEngine, StringBuilder)

FilterBase.FilterPrefix(ISqlEngine, StringBuilder)

FilterBase.WriteCore(ISqlEngine, StringBuilder)

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)

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(TableSqlQuery, params IField[])

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

ShadowSqlServices.ToCursor(TableSqlQuery, int, int)

ShadowSqlServices.ToDelete(TableSqlQuery)

ShadowSqlServices.ToSelect(TableSqlQuery)

ShadowSqlServices.ToUpdate(TableSqlQuery)

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(ITable)

查询表

public TableSqlQuery(ITable table)

参数

table ITable

TableSqlQuery(ITable, SqlQuery)

查询表

public TableSqlQuery(ITable table, SqlQuery query)

参数

table ITable

query SqlQuery

TableSqlQuery(string)

查询表

public TableSqlQuery(string tableName)

参数

tableName string

TableSqlQuery(string, SqlQuery)

查询表

public TableSqlQuery(string tableName, SqlQuery query)

参数

tableName string

query SqlQuery