TableSchema 类

命名空间

Shadow.DDL.Schemas

程序集

Shadow.DDL.dll

表结构

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

继承

object

IdentifierBase

Identifier

TableSchema

实现

ITable

ITableView

IInsertTable

IIdentifier

IMatch

IUpdateTable

ISqlEntity

继承成员

Identifier.Match(string, string)

Identifier.AliasMatch(string, string, string)

IdentifierBase._name

IdentifierBase.Name

扩展方法

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)

DDLServices.ToCreate(TableSchema)

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.ToSqlOrQuery<TTable>(TTable)

ShadowSqlServices.ToSqlQuery<TTable>(TTable)

ShadowSqlServices.ToUpdate<TTable>(TTable, ISqlLogic)

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

ShadowSqlServices.Where<TTable>(TTable)

DapperShadowServices.ToDapperDelete(ITable, ISqlLogic, IExecutor)

DapperShadowServices.ToDapperTruncate(ITable, IExecutor)

DDLServices.ToCreate(ITable, IEnumerable<ColumnSchema>, IEnumerable<IConstraint>)

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)

DapperShadowCoreServices.CountAsync(ITableView, IExecutor, object?, CancellationToken)

DapperShadowCoreServices.LongCountAsync(ITableView, IExecutor, object?, CancellationToken)

ShadowSqlCoreServices.Field(ITableView, string)

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

ShadowSqlCoreServices.Strict(ITableView, string)

构造函数

TableSchema(string, ColumnSchema[], IConstraint[], string)

表结构

public TableSchema(string tableName, ColumnSchema[] columns, IConstraint[] constraints, string schema = "")

参数

tableName string

表名

columns ColumnSchema[]

列

constraints IConstraint[]

约束

schema string

TableSchema(string, ColumnSchema[], string)

表结构

public TableSchema(string tableName, ColumnSchema[] columns, string schema = "")

参数

tableName string

columns ColumnSchema[]

schema string

属性

Columns

字段

public ColumnSchema[] Columns { get; }

属性值

ColumnSchema[]

Constraints

约束

public IConstraint[] Constraints { get; }

属性值

IConstraint[]

Keys

主键

public ColumnSchema[] Keys { get; }

属性值

ColumnSchema[]

Schema

架构

public string Schema { get; }

属性值

string

方法

AddColumns(params ColumnSchema[])

添加列

public void AddColumns(params ColumnSchema[] columns)

参数

columns ColumnSchema[]

GetColumn(string)

查找字段

public ColumnSchema? GetColumn(string columName)

参数

columName string

列名

返回

ColumnSchema