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 )