Get list of SP parameters

Question

I'm writing a function to call a stored procedure given an IDictionary of arguments.

[Function(Name = "dbo.GetTrackingInfo")]
[ResultType(typeof(Shipment))]
[ResultType(typeof(Piece))]
[ResultType(typeof(Item))]
public IMultipleResults GetTrackingInfo(IDictionary<string, object> arguments)
{
    var method = (MethodInfo)MethodInfo.GetCurrentMethod();

    var argumentsArr = this.Mapping.GetFunction(method).Parameters
        .Select(p => arguments.ContainsKey(p.Name)
            ? NullableExtensions.Convert(arguments[p.Name], p.ParameterType)
            : null)
        .ToArray();

    return (IMultipleResults)this.ExecuteMethodCall(this, method, argumentsArr);
}

I expected Mapping.GetFunction(method).Parameters to return the parameters of the SP, but instead it returned the parameters of this method. Is there any simple way to get the parameters of the underlying SP?

casperOne · Accepted Answer · 2012-10-23 18:29:25Z

3

The Name property (as you've found out) returns the name of the function in the CLR space.

What you want to use is the MappedName property, defined as (emphasis mine):

Gets the name of the parameter in the database function.

Note that the call to the Parameters property on the MetaFunction class does return information about the parameters of the underlying SP; it's a mapping, so it has both the SP information along with the information about the CLR representation, associated with the same MetaParameter instance.

edited Oct 23, 2012 at 18:29

answered Oct 23, 2012 at 18:07

casperOne

74.7k19 gold badges189 silver badges262 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Get list of SP parameters

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related