C# (CSharp) AbpLib.SQL Queries示例

示例#1

 public Task <string[]> TableNames() => CN.SqlArray <string>(Queries.TABLENAMES(DATABASE));

示例#2

 public Task <string[]> ColumnNamesNOPK(string table) => CN.SqlArray <string>(Queries.AllColumnNames_NOPK(table));

示例#3

 public Task <string> GetDataType(string table, string field) => CN.SqlValue <string>(Queries.DATATYPE(table, field));

示例#4

 public Task <DateTime> LastUserChange(string table) => CN.SqlValue <DateTime>(Queries.LAST_USERUPDATE(DATABASE, table));

示例#5

 public Task <int> ROWCOUNT(string table) => CN.SqlValue <int>(Queries.ROWCOUNT(table));

示例#6

 public Task <int> ColumnCount() => CN.SqlValue <int>(Queries.COLUMN_COUNT(DATABASE, TABLE));