use as
[System.Data.Linq.Mapping.Function(Name = "[TRNS].[Get_PRGoods]")]
public System.Data.Linq.ISingleResult<PRGood> GetPRGoodsDetails(int PickupID)
{
System.Data.Linq.IExecuteResult result = this.ExecuteMethodCall(this, ((System.Reflection.MethodInfo)(System.Reflection.MethodInfo.GetCurrentMethod())), PickupID);
return ((System.Data.Linq.ISingleResult<PRGood>)(result.ReturnValue));
}