C# method to return var

Question

I like to return var from my method. I manage to use dynamic, but then my try-catch-finally does not work. Could you improve my method to return var? I do not need to use dynamic, I am looking for the best method to return var.

Thank you so much in advance. Rune

public dynamic m_DEMO_Return_var_method(string vpSchemaName, string vpTableName)
{

    var var_List = new List<string>();

    //try
    //{

    DataTable iDataTable = new DataTable();

    var_List.Clear();
    foreach (DataRow iDataRow in iDataTable.Rows)
    {
        var_List.Add(iDataRow["COLUMN_NAME"].ToString());
    }

    var vColumnName = var_List.ToArray();

    return vColumnName;

    //}
    //catch (Exception im_Exception)
    //{
    //    return vColumnName;
    //}
    //finally
    //{
    //}
}

Answer 1

You can update your code as follows.

public dynamic m_DEMO_Return_var_method(string vpSchemaName, string vpTableName)
{

    var var_List = new List<string>();
    var vColumnName = var_List.ToArray();
    try
    {

        DataTable iDataTable = new DataTable();

        var_List.Clear();
        foreach (DataRow iDataRow in iDataTable.Rows)
        {
            var_List.Add(iDataRow["COLUMN_NAME"].ToString());
        }

        vColumnName = var_List.ToArray();

        return vColumnName;

    }
    catch (Exception im_Exception)
    {
        return null;
    }
    finally
    {
    }

    return vColumnName;
}

The method will return null if vColumnName variable will not contain any data or if any exception will occure.