Stored Procedure Invocation Code Generator for VB, C# and JScript.NET

using System;
using System.Data.SqlClient;

namespace SPInvoke
{
	/// <summary>
	/// Summary description for Class1.
	/// </summary>
	class Class1
	{
		/// <summary>
		/// The main entry point for the application.
		/// </summary>
		[STAThread]
		static void Main(string[] args)
		{
			string connString = "Data source=localhost;Initial catalog=Northwind;Integrated Security=true";
			
			using (SqlConnection conn = new SqlConnection(connString))
			{
				conn.Open();

				GetCustomerOrderHistory.Result result = GetCustomerOrderHistory.Invoke(conn, "PERIC");

				foreach(Order order in result.Rows)
					Console.WriteLine(order.ProductName.Value + " : " + order.Total.Value);
			}
		}
	}
}