Table 类

命名空间

ShadowSql.Identifiers

程序集

ShadowSql.Core.dll

表名对象

public class Table : Identifier, ITable, ITableView, IInsertTable, IIdentifier, IMatch, IUpdateTable, ISqlEntity

继承

object

IdentifierBase

Identifier

Table

实现

ITable

ITableView

IInsertTable

IIdentifier

IMatch

IUpdateTable

ISqlEntity

衍生

DapperTable

继承成员

Identifier.Match(string, string)

Identifier.AliasMatch(string, string, string)

IdentifierBase._name

IdentifierBase.Name

扩展方法

DapperShadowServices.ToDapperDelete(ITable, ISqlLogic, IExecutor)

DapperShadowServices.ToDapperTruncate(ITable, IExecutor)

DDLServices.ToCreate(ITable, IEnumerable<ColumnSchema>)

DDLServices.ToDrop(ITable)

ShadowSqlServices.GroupBy<TKey, TEntity>(ITable, Expression<Func<TEntity, bool>>, Expression<Func<TEntity, TKey>>)

ShadowSqlServices.GroupBy<TKey, TEntity>(ITable, Expression<Func<TEntity, TKey>>)

ShadowSqlServices.Join<TLeft, TRight>(ITable, ITable)

ShadowSqlServices.SqlGroupBy<TKey, TEntity>(ITable, Expression<Func<TEntity, bool>>, Expression<Func<TEntity, TKey>>)

ShadowSqlServices.SqlGroupBy<TKey, TEntity>(ITable, Expression<Func<TEntity, TKey>>)

ShadowSqlServices.SqlJoin<TLeft, TRight>(ITable, ITable)

ShadowSqlServices.Take<TEntity>(ITable, ISqlLogic, int, int)

ShadowSqlServices.Take<TEntity>(ITable, int, int)

ShadowSqlServices.ToCursor<TEntity>(ITable, ISqlLogic, int, int)

ShadowSqlServices.ToCursor<TEntity>(ITable, int, int)

ShadowSqlServices.ToDelete<TEntity>(ITable, Expression<Func<TEntity, bool>>)

ShadowSqlServices.ToDelete<TEntity, TParameter>(ITable, Expression<Func<TEntity, TParameter, bool>>)

ShadowSqlServices.ToInsert<TEntity>(ITable)

ShadowSqlServices.ToInsert<TEntity>(ITable, Expression<Func<TEntity>>)

ShadowSqlServices.ToInsert<TParameter, TEntity>(ITable, Expression<Func<TParameter, TEntity>>)

ShadowSqlServices.ToOrQuery<TEntity>(ITable)

ShadowSqlServices.ToQuery<TEntity>(ITable)

ShadowSqlServices.ToSelect<TEntity>(ITable)

ShadowSqlServices.ToSelect<TEntity>(ITable, ISqlLogic)

ShadowSqlServices.ToSelect<TEntity>(ITable, Expression<Func<TEntity, bool>>)

ShadowSqlServices.ToSelect<TEntity, TParameter>(ITable, Expression<Func<TEntity, TParameter, bool>>)

ShadowSqlServices.ToSqlOrQuery<TEntity>(ITable)

ShadowSqlServices.ToSqlQuery<TEntity>(ITable)

ShadowSqlServices.ToUpdate<TEntity>(ITable, ISqlLogic)

ShadowSqlServices.ToUpdate<TEntity>(ITable, Expression<Func<TEntity, bool>>)

ShadowSqlServices.ToUpdate<TEntity, TParameter>(ITable, Expression<Func<TEntity, TParameter, bool>>)

ShadowSqlServices.Where<TEntity>(ITable)

ShadowSqlCoreServices.Column(ITable, string)

ShadowSqlCoreServices.ToDelete(ITable, ISqlLogic)

ShadowSqlCoreServices.ToTruncate(ITable)

ShadowSqlServices.Multi(ITable, ITable)

ShadowSqlServices.SqlMulti(ITable, ITable)

ShadowSqlServices.ToSingle(ITable, IFieldView)

ShadowSqlServices.ToSingle(ITable, ISqlLogic, IFieldView)

ShadowSqlServices.ToSingle(ITable, ISqlLogic, string)

ShadowSqlServices.ToSingle(ITable, 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<TTable>(TTable, Func<TTable, ISqlLogic>, IExecutor)

DapperShadowServices.ToDapperSelect<TTable>(TTable, IExecutor)

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

DapperShadowServices.ToDapperUpdate<TTable>(TTable, ISqlLogic, IExecutor)

DapperShadowServices.ToDapperUpdate<TTable>(TTable, Func<TTable, ISqlLogic>, IExecutor)

ShadowSqlCoreServices.AddColums<TTable>(TTable, params IEnumerable<IColumn>)

ShadowSqlCoreServices.As<TTable>(TTable, string)

ShadowSqlCoreServices.Copy(Table, string)

ShadowSqlCoreServices.DefineColums<TTable>(TTable, params IEnumerable<string>)

ShadowSqlCoreServices.IgnoreInsert<TTable>(TTable, params IEnumerable<IColumn>)

ShadowSqlCoreServices.IgnoreInsert<TTable>(TTable, params IEnumerable<string>)

ShadowSqlCoreServices.IgnoreUpdate<TTable>(TTable, params IEnumerable<IColumn>)

ShadowSqlCoreServices.IgnoreUpdate<TTable>(TTable, params IEnumerable<string>)

ShadowSqlCoreServices.ToDelete<TTable>(TTable, Func<TTable, ISqlLogic>)

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

ShadowSqlServices.GroupBy<TTable>(TTable, ISqlLogic, params IField[])

ShadowSqlServices.GroupBy<TTable>(TTable, ISqlLogic, params IEnumerable<string>)

ShadowSqlServices.GroupBy<TTable>(TTable, params IEnumerable<string>)

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

ShadowSqlServices.GroupBy<TTable>(TTable, Func<TTable, ISqlLogic>, Func<TTable, IField[]>)

ShadowSqlServices.Join<LTable, RTable>(LTable, RTable)

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

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

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

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

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

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

ShadowSqlServices.SqlJoin<LTable, RTable>(LTable, RTable)

ShadowSqlServices.Take<TTable>(TTable, ISqlLogic, int, int)

ShadowSqlServices.Take<TTable>(TTable, int, int)

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

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

ShadowSqlServices.ToInsert<TTable>(TTable)

ShadowSqlServices.ToInsert<TTable>(TTable, ISelect)

ShadowSqlServices.ToMultiInsert<TTable>(TTable)

ShadowSqlServices.ToOrQuery<TTable>(TTable)

ShadowSqlServices.ToQuery<TTable>(TTable)

ShadowSqlServices.ToSelect<TTable>(TTable)

ShadowSqlServices.ToSelect<TTable>(TTable, ISqlLogic)

ShadowSqlServices.ToSelect<TTable>(TTable, Func<TTable, ISqlLogic>)

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

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

ShadowSqlServices.ToSqlOrQuery<TTable>(TTable)

ShadowSqlServices.ToSqlQuery<TTable>(TTable)

ShadowSqlServices.ToUpdate<TTable>(TTable, ISqlLogic)

ShadowSqlServices.ToUpdate<TTable>(TTable, Func<TTable, ISqlLogic>)

ShadowSqlServices.Where<TTable>(TTable)

构造函数

Table(string)

表名对象

public Table(string tableName)

参数

tableName string

表名

属性

Columns

列

public IEnumerable<IColumn> Columns { get; }

属性值

IEnumerable<IColumn>

InsertIgnores

插入忽略的列

public IEnumerable<IColumn> InsertIgnores { get; }

属性值

IEnumerable<IColumn>

UpdateIgnores

修改忽略的列

public IEnumerable<IColumn> UpdateIgnores { get; }

属性值

IEnumerable<IColumn>

方法

AddColumn(IColumn)

添加列

public void AddColumn(IColumn column)

参数

column IColumn

列

AddInsertIgnore(IColumn)

忽略插入的列

public void AddInsertIgnore(IColumn column)

参数

column IColumn

列

AddUpdateIgnore(IColumn)

忽略修改的列

public void AddUpdateIgnore(IColumn column)

参数

column IColumn

列

CheckTablePrefix(string, string)

判断是否含表名前缀

public static bool CheckTablePrefix(string table, string columName)

参数

table string

表

columName string

列名

返回

bool

DefineColumn(string)

定义列

public IColumn DefineColumn(string columnName)

参数

columnName string

列名

返回

IColumn

GetColumn(string)

查找列

public IColumn? GetColumn(string columName)

参数

columName string

列名

返回

IColumn