Closure in C#

After the success of Closure in Java we like to show you a good example in C# too.

C# has a very strong support for Lambda functions, because it needs to support the LINQ language constructs.

So defining a closure is quite easy. Best, it is possible to define a “delegate” , which is a typed function: the compiler will help you to avoid errors because will match the lambda function against the delegate.

The client code will look like
[csharp]FillInInputParamerers p = cmd => {
cmd.Parameters.Add("@utenteDaProfilare", SqlDbType.VarChar);
cmd.Parameters["@utenteDaProfilare"].Value = username;
return cmd;
};
DataSet result = execStoredProcedure("sp_GetProfiliUtente", p, "Utenti");[/csharp]
The trick will use the CSharp delegate keyword:
[csharp][…]

#region Delegatori
/// <summary>
/// The Lambda function </summary>
public delegate SqlCommand FillInInputParamerers(SqlCommand input);

/// <summary>
/// Metodo per delegare la gestione degli errori e l’esecuzione della stored procedure
/// </summary>
/// <param name="storedProcedureName"></param>
/// <param name="function"></param>
/// <param name="srcTable"></param>
/// <returns></returns>
public DataSet execStoredProcedure(string storedProcedureName, FillInInputParamerers function, string srcTable)
{
DataSet result = new DataSet();
runtimeResult.Reset();

string sp = storedProcedureName;
SqlConnection conn = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand(sp, conn);
cmd.CommandType = CommandType.StoredProcedure;
// Delegate the parameters
cmd = function(cmd);

SqlDataAdapter da = new SqlDataAdapter(cmd);
try
{
conn.Open();
da.Fill(result, srcTable);
runtimeResult.OK();
}
catch (SqlException sqlEx)
{
result = null;
runtimeResult.KO(sqlEx.ErrorCode, sqlEx.Message, sqlEx.ToString());
}
catch (Exception ex)
{
result = null;
runtimeResult.KO(0, ex.Message, ex.ToString());
}
finally
{
if (conn != null)
conn.Close();
}
return result;
}

#endregion

[…][/csharp]
For more information take a look to the MS documentation