drapper oracle,dapper一个连接oracle的类 这两个方法是干什么的

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

public string SqlField()

{

string sql = @"

SELECT

COL.COLUMN_ID F_NUMBER,

COL.COLUMN_NAME F_COLUMN,

COL.DATA_TYPE F_DATATYPE,

COL.DATA_LENGTH F_LENGTH,

NULL F_IDENTITY,

CASE UC.CONSTRAINT_TYPE

WHEN 'P' THEN

1

ELSE

NULL

END F_KEY,

CASE COL.NULLABLE

WHEN 'N' THEN

0

ELSE

1

END F_ISNULLABLE,

COL.DATA_DEFAULT F_DEFAULTS,

COMM.COMMENTS AS F_REMARK

FROM

USER_TAB_COLUMNS COL

INNER JOIN USER_COL_COMMENTS COMM ON COMM.TABLE_NAME = COL.TABLE_NAME

AND COMM.COLUMN_NAME = COL.COLUMN_NAME

LEFT JOIN USER_CONS_COLUMNS UCC ON UCC.TABLE_NAME = COL.TABLE_NAME

AND UCC.COLUMN_NAME = COL.COLUMN_NAME

AND UCC. POSITION = 1

LEFT JOIN USER_CONSTRAINTS UC ON UC.CONSTRAINT_NAME = UCC.CONSTRAINT_NAME

AND UC.CONSTRAINT_TYPE = 'P'

WHERE

COL.TABLE_NAME = : TABLENAME

ORDER BY

COL.COLUMN_ID";

return sql;

}

public string SqlTable()

{

string sql = @"

SELECT DISTINCT

COL.TABLE_NAME NAME,

0 RESERVED,

0 FDATA,

0 INDEX_SIZE,

NVL (T.NUM_ROWS, 0) SUMROWS,

0 FUNUSED,

TAB.COMMENTS TDESCRIPTION,

COLUMN_NAME PK

FROM

USER_CONS_COLUMNS COL

INNER JOIN USER_CONSTRAINTS CON ON CON.CONSTRAINT_NAME = COL.CONSTRAINT_NAME

INNER JOIN USER_TAB_COMMENTS TAB ON TAB.TABLE_NAME = COL.TABLE_NAME

INNER JOIN USER_TABLES T ON T.TABLE_NAME = COL.TABLE_NAME

WHERE

CON.CONSTRAINT_TYPE NOT IN ('C', 'R')

ORDER BY

COL.TABLE_NAME";

return sql;

}