Example #1
0
 // ===============================================================================
 //                                                                     Constructor
 //                                                                     ===========
 public InternalProcedureHandler(IDataSource dataSource, String sql,
                                 IDataReaderHandler dataReaderHandler, ICommandFactory commandFactory,
                                 IDataReaderFactory dataReaderFactory, InternalProcedureMetaData procedureMetaData)
     : base(dataSource, sql, dataReaderHandler, commandFactory, dataReaderFactory)
 {
     this._procedureMetaData = procedureMetaData;
 }
 // ===============================================================================
 //                                                                     Constructor
 //                                                                     ===========
 public InternalProcedureCommand(IDataSource dataSource, IDataReaderHandler dataReaderHandler,
                                 ICommandFactory commandFactory, IDataReaderFactory dataReaderFactory,
                                 InternalProcedureMetaData procedureMetaData)
 {
     this._dataSource        = dataSource;
     this._dataReaderHandler = dataReaderHandler;
     this._commandFactory    = commandFactory;
     this._dataReaderFactory = dataReaderFactory;
     this._procedureMetaData = procedureMetaData;
 }
        protected String CreateSql(InternalProcedureMetaData procedureMetaData)
        {
            // StringBuilder sb = new StringBuilder();
            // sb.append("{");
            // int size = procedureMetaData.ParameterTypeSize;
            // if (procedureMetaData.HasReturnParameterType) {
            //     sb.append("? = ");
            //     size--;
            // }
            // sb.append("call ").append(procedureMetaData.ProcedureName).append("(");
            // for (int i = 0; i < size; i++) {
            //     sb.append("?, ");
            // }
            // if (size > 0) {
            //     sb = new StringBuilder().append(sb.toString().Substring(0, sb.length() - 2));
            // }
            // sb.append(")}");
            // return sb.toString();

            // The procedure name is SQL at CSharp!
            return(procedureMetaData.ProcedureName);
        }