APP.dicon
TestSelect.dicon
OracleEx.DaoInterceptor
OracleEx.dicon
"System.Data.OracleClient.OracleConnection"
"System.Data.OracleClient.OracleCommand"
"System.Data.OracleClient.OracleParameter"
"System.Data.OracleClient.OracleDataAdapter"
Oracle
appSettings['ConnectionString']
TransactionContext
System.Data.IsolationLevel.ReadCommitted
DTCTransactionStateHandler
TestSelectDao.cs
[Bean(typeof(TestSelect))]
public interface TestSelectDao {
//[Sql("SELECT * FROM T_INPUT_DAT")]
TestSelect[] SelectList();
}
TestSelect.cs
[Table("T_INPUT_DAT")]
public class TestSelect {
private String ymd;
private String itemcd;
private int seqno;
private byte[] inpdat;
[Column("YYYYMM")]
public String Ymd {
get {return ymd;}
set {ymd = value;}
}
[Column("ITEM_CD")]
public String ItemCd {
get {return itemcd;}
set {itemcd = value;}
}
[Column("SEQ_NO")]
public int SeqNo {
get {return seqno;}
set {seqno = value;}
}
[Column("INP_DAT")]
public byte[] InpDat {
get {return inpdat;}
set {inpdat = value;}
}
}
ボタンのクリックイベント
IS2Container container = S2ContainerFactory.Create(SingletonS2ContainerFactory.ConfigPath);
TestSelectDao GrDao = (TestSelectDao)container.GetComponent(typeof(TestSelectDao));
TestSelect[] dat = GrDao.SelectList();
SQLスクリプト
create table T_INPUT_DAT
(
YYYYMM VARCHAR2(6) not null,
ITEM_CD VARCHAR2(6) not null,
SEQ_NO NUMBER(10) not null,
INP_DAT SYS.XMLTYPE
)