D-layer automatic generation tool : there is no consideration of the schema when getting the column.

[daisukenishino]

Problem of primary key acquisition function of Oracle (ODP.NET) (2)

At D-layer automatic generation tool (D層自動生成ツールにて)

There is a consideration of the schema when getting the table, but there is no consideration of the schema when getting the column. This problem occurs only in the auto-generated using the Oracle Database. テーブルを取得するスキーマの考慮されているが、列を取得するときに、スキーマは考慮されていない。この問題は、Oracleデータベースを使用した自動生成でのみ発生する。

[daisukenishino]

Problem of primary key acquisition function of Oracle (ODP.NET) (2)

At D-layer automatic generation tool (D層自動生成ツールにて)

In some execution environment, Phenomenon INDEX_OWNER column of schema information of the primary key is the empty string has been reported. Tentatively, to perform the following measures.

if (row1 ["INDEX_OWNER"]. ToString () == ""
     || Row1 ["INDEX_OWNER"]. ToString (). ToUpper () == userId.ToUpper ())
    {

if (row2 ["INDEX_OWNER"]. ToString () == ""
     || Row2 ["INDEX_OWNER"]. ToString (). ToUpper () == userId.ToUpper ())
    {

• Specification of GetScheme is not well understood. Also There is problem that specifications is different for each data provider.
• Can't get the primary key information using the GetScheme method in SQL Server. Therefore current situation is to get the primary key information by executing the SQL command. It should be noted, is not supported primary key acquisition function in DB other than SQL Server and Oracle.