C# (CSharp) IDbRoutine Examples

Example #1

File: ParameterInspector.cs Project: hbulzy/SqlServerDatabaseDocumentationGenerator

        public IList<Parameter> GetParameters(IDbRoutine routine)
        {
            IList<Parameter> results = null;

            if (routine is StoredProcedure)
            {
                results = this.queryForStoredProcedureParameters(routine as StoredProcedure);
            }
            else
            {
                if (routine is IUserDefinedFunction)
                {

                    results = this.queryForUserDefinedFunctionParameters(routine as IUserDefinedFunction);
                }

            }

            if (results != null && results.Count > 0 && routine is IDbObject)
            {
                for (int i = 0; i < results.Count; i++)
                {
                    results[i].Parent = routine as IDbObject;
                }
            }

            return results;
        }

Example #2

File: ParameterInspector.cs Project: waldeilton/SqlServerDatabaseDocumentationGenerator

        public IList <Parameter> GetParameters(IDbRoutine routine)
        {
            IList <Parameter> results = null;

            if (routine is StoredProcedure)
            {
                results = this.queryForStoredProcedureParameters(routine as StoredProcedure);
            }
            else
            {
                if (routine is IUserDefinedFunction)
                {
                    results = this.queryForUserDefinedFunctionParameters(routine as IUserDefinedFunction);
                }
            }


            if (results != null && results.Count > 0 && routine is IDbObject)
            {
                for (int i = 0; i < results.Count; i++)
                {
                    results[i].Parent = routine as IDbObject;
                }
            }

            return(results);
        }