{
	[DataContract]
	public class AgentStoredProcMessage
	{
		/// <summary>
		/// An unique and agreed upon value that indicates to whom the message is to go to.
		/// </summary>
		[DataMember( IsRequired = true )]
		public string ConnectorId { get; set; }

		/// <summary>
		/// The name of the stored procedure without the schema name.  We will add the schema name when it is called.
		/// This value must not contain a period, space or whitespace (tabs, cr, lf).
		/// </summary>
		[DataMember( IsRequired = true )]
		public string Procedure { get; set; }

		/// <summary>
		/// An array of parameters.
		/// </summary>
		[DataMember( IsRequired = false )]
		public AgentStoredProcParam[] Params { get; set; }
	}
 

	[DataContract]
	public class AgentStoredProcParam
	{
		/// <summary>
		/// The name of the parameter.
		/// </summary>
		/// <remarks>
		/// It is unnecessary to include the leading @ character.
		/// </remarks>
		[DataMember( IsRequired = true )]
		public string Name { get; set; }

		/// <summary>
		/// The data value of the parameter.
		/// </summary>
		/// <remarks>
		/// This field is always a string and data will be converted to the appropriate data type.
		/// Dates should be in the format "yyyy-MM-dd" or any similar format that works for ALL
		/// locales (e.g. MM/dd/yyyy will not work in a Canadian system using dd/MM/yyyy date formats).
		/// Binary data should be in base64 encoded format.
		/// Numbers should be in an appropriate format but should not contain commas, currency symbols. Just
		/// digits, one decimal point, negative sign, possible exponent E.
		///
		/// Null data value should be "Value": null or the Value property is just omitted altogether.
		/// </remarks>
		[DataMember( IsRequired = false )]
		public string Value { get; set; }

		/// <summary>
		/// The SQL Server data type.
		/// </summary>
		/// <remarks>
		/// Valid values: any of the following SQL Server data types are supported:
		/// int
		/// bigint
		/// decimal
		/// numeric
		/// smallint
		/// bit (must be either "true" or "false")
		/// tinyint
		/// float
		/// real
		/// char
		/// nchar
		/// varchar
		/// nvarchar
		/// money
		/// date
		/// time
		/// datetime
		/// datetime2
		/// smalldatetime
		/// xml (see IsXmlDocumentFragment property below)
		///
		/// This is case insensitive.  The following are not supported, but you can
		/// use the suggested types instead:
		/// text (use varchar with max size)
		/// ntext (use nvarchar with max size)
		/// </remarks>
		[DataMember( IsRequired = true )]
		public string DataType { get; set; }

		/// <summary>
		/// The max size of the parameter.  Suggested for all string data.
		/// It is the precision size parameter for decimal and numeric data
		/// (the first size parameter). Use -1 when the size is 'max' (for
		/// example, varchar(max), nvarchar(max)).  The default for precision
		/// is 18 and for strings is 30 (even for char and nchar).
		/// </summary>
		[DataMember( IsRequired = false )]
		public int MaxSize { get; set; }

		/// <summary>
		/// The scale size of the parameter.  Used in decimal and numeric
		/// types (the second size parameter) only.  Default scale is 0.
		/// </summary>
		[DataMember( IsRequired = false )]
		public int Scale { get; set; }

		/// <summary>
		/// True if input/output and false if input only (the default).
		/// </summary>
		/// <remarks>
		/// There is no current way to retrieve output parameter values.
		/// </remarks>
		[DataMember( IsRequired = false )]
		public bool IsOutputParam { get; set; }

		/// <summary>
		/// Determines the XmlNodeType enum value that is used only for
		/// xml data type only.  Default of false uses Document while
		/// true uses DocumentFragment.
		/// </summary>
		[DataMember( IsRequired = false )]
		public bool IsXmlDocumentFragment { get; set; }
	}

}