Database

// create a connection (actually, grab a connection from the connection pool)
using (SqlConnection conn = new SqlConnection(Utils.ConnectionString))
{
	// open it
	conn.Open();

	// build up the stored procedure command with parameters
	SqlCommand command = new SqlCommand("FxGetRates", conn);
	command.CommandType = CommandType.StoredProcedure;
	command.Parameters.Add("@date", SqlDbType.SmallDateTime).Value = valueDate;

	List<FxRate> results = new List<FxRate>();

	// get the results
	using (SqlDataReader reader = command.ExecuteReader())
	{
		int ord_assetId = reader.GetOrdinal("AssetId");
		int ord_domesticcurrencyid = reader.GetOrdinal("DomesticCurrencyId");
		int ord_foreigncurrencyid = reader.GetOrdinal("ForeignCurrencyId");
		int ord_marketdatasourceid = reader.GetOrdinal("MarketDataSourceId");
		int ord_rate = reader.GetOrdinal("Rate");

		while (reader.Read())
		{
			FxRate result = new FxRate();
			result.AssetId = reader.GetInt32(ord_assetId);
			result.DomesticCurrencyId = reader.GetInt32(ord_domesticcurrencyid);
			result.ForeignCurrencyId = reader.GetInt32(ord_foreigncurrencyid);
			result.MarketDataSourceId = reader.GetInt32(ord_marketdatasourceid);
			result.Rate = reader.GetDouble(ord_rate);
			results.Add(result);
		}
	}

	// and return
	return results.ToArray();