using System;

using System.Linq;

using System.Collections.Generic;

​

public class Program

{

    public static void Main()

    {

        const string DEFAULT = "default";

        // Report collection

        IList<ReportFilenameFormat> formatList = new List<ReportFilenameFormat>()

        {new ReportFilenameFormat()

        {Name = "a", OrganizationCode = "A"}, new ReportFilenameFormat()

        {Name = "b", OrganizationCode = "B"}, new ReportFilenameFormat()

        {Name = "c", OrganizationCode = "Default"}, new ReportFilenameFormat()

        {Name = "d", OrganizationCode = "Something"}, new ReportFilenameFormat()

        {Name = "e", OrganizationCode = "other"}};

        //Set test value

        string reportOrgCode = "z";

        //Original logic using C#

        ReportFilenameFormat selectedOrg = formatList.Where(x => x.OrganizationCode.ToLower() == reportOrgCode).FirstOrDefault();

        if ((selectedOrg == null))

        {

            selectedOrg = formatList.Where(x => x.OrganizationCode.ToLower() == DEFAULT).FirstOrDefault();

        }

​

        Console.WriteLine(string.Format("Original logic {0} : {1}", selectedOrg.Name, selectedOrg.OrganizationCode));

        // use LINQ to handle the logic

        selectedOrg = formatList

            .Where(x => (x.OrganizationCode.ToLower() == reportOrgCode || x.OrganizationCode.ToLower() == DEFAULT ))

            .OrderBy(x => (x.OrganizationCode == DEFAULT ? 99 : 1 ) ).FirstOrDefault(); // order by CASE WHEN ORG = DEF THEN 99 ELSE 1 END

        Console.WriteLine(string.Format("LINQ logic {0} : {1}", selectedOrg.Name, selectedOrg.OrganizationCode));

    }

}

​

public class ReportFilenameFormat

{

    public string Name { get; set; }

​

    public string OrganizationCode { get; set; }

}