将IQueryable <object>结果转换为逗号分隔的字符串

public static string ConvertToCsv<T>(this IQueryable<T> queryable)
{
    var result = new StringBuilder();
    var properties = typeof(T).GetProperties();

    foreach (var property in properties)
    {
        result.Append(property.Name);
        result.Append(",");
    }

    result.Remove(result.Length - 1, 1);
    result.AppendLine();

    foreach (var item in queryable)
    {
        foreach (var property in properties)
        {
            result.Append(property.GetValue(item));
            result.Append(",");
        }

        result.Remove(result.Length - 1, 1);
        result.AppendLine();
    }

    return result.ToString();
}

var query = from item in context.Items
            select item;

var csv = query.ConvertToCsv();