/*
 * Example 1:
 * 
 * Note: This is code stub for article 
 * http://www.izsak.net/weblog/216/DbLayer
 * 
 */

public static T ExecuteReader<T>(String procedure, params SqlParameter[] parameters)
{
    SqlConnection conn = new SqlConnection("connection string...");
    SqlCommand cmd = new SqlCommand(conn, procedure);
    cmd.CommandType = CommandType.StoredProcedure;
    cmd.Parameters.AddRange(parameters);
    T ret = default(T);
    SqlDataReader reader = null;
    try
    {
        conn.Open();
        reader = cmd.ExecuteReader();
        // spracovanie údajov zo SqlDataReader
        // ...
    }
    catch (SqlException ex)
    {
        LogSqlException(cmd, ex);
    }
    finally
    {
        // vymazanie objektov
    }
    return ret;
}