Easiest way to convert list to a comma separated string by a Specific Property?

.net c# entity-framework linq

Question

I have a list of custom objects that I am actually keeping in an IEnumerable collection as entities. How do I create a comma separated string with a certain property from a custom object list? I want to convert the list to a comma separated string, but I only want one particular attribute.

I am aware that I can create a comma-separated list using a"Foreach / For (int i .... " however, I believe there is a quick and better method to do this. What would be that quick approach?

Here's my list.

IEnumerable<BAL.Category> categories = chklCategories.CheckedItems.Cast<BAL.Category>();
            //Category object has a property called Name , I want the list from that property
1
6
11/25/2013 5:16:27 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Isn't this really simple?

string sCategories = string.Join(",", categories.Select(x => x.Name));
13
11/25/2013 5:03:42 AM

Popular Answer

Just give it a shot.

Utilizing this variation of thestring.Join<string> you can cut down on the number of copies in your collection before enrolling.

static string CombineList(IEnumerable categories)
{
  return string.Join<string>(",", categories.Select(x => x.Name));
}
Thilina H

Related Questions

How do I tie the values of two columns in a dropdown with distinct commas? (,)

You may do this by creating a custom property on the object that performs this work for you:...clarified with your objects after editing...You may type something like that....public partial class Clients { public string FullName { get { return String.Format("{0}, {1}", LastName, FirstName); } } } ...You'll get a read-only proper...
asp.net c# entity-framework
asked by msarchet

First List of Entity Framework Code Mapping of Properties

No type converters or unique type mappers are available in EF as an alternative to model binders from MVC. To induce persistence, you must always utilize some kind of hack. Maps are another similar method....TextOptions... is a grouping of connected items. Although it will complicate your model and working with it, it will improve your separation o...
entity-framework mapping model
asked by Ladislav Mrnka

Using linq, get a comma-separated list of entity collections.

var r = _rs.Lines.Where(y => y.InvoiceNo == o.InvoiceNo).ToList().Select(x => new { ReturnNo = x.Return.ReturnNo, Part = x.Part, Tags = String.Join(", ", x.Tags.Select(t => t.Name)) });
c# entity-framework linq
asked by empi

Entity Framework options to map list of strings or list of int (List<string>)

I want to use EF to store an object that has a List of primitives....public class MyObject { public int Id {get;set;} public virtual IList<int> Numbers {get;set;} } ...Although I am aware of this, I would still want to learn about potential remedies....I can think of two solutions, which are:...1....Make a fake item.... with an Id and an in...
entity-framework list mapping orm
asked by Bernhard Kircher

Cannot implicitly convert type '.List<AnonymousType#1>' to '.List<WebApplication2.Customer>'

The anonymous type you are choosing is not a...Customer... ....You can write it like this if you want to do (kind of) this:...return db.Customers.Select(x => new Customer { Name = x.CustName, Email = x.CustEmail, Address = x.CustAddress, ContactNo = x.ContactNo }).ToList(); ...Using your attributes as a starting point...Customer... They are what I ...
asp.net c# entity-framework linq
asked by Mark Avenius

Convert list of of objects to list of tuple without iterating

as in this?...subjectList.Select(s => Tuple.Create(s, false)).ToList();
c# entity-framework generics linq tuples
asked by dcastro

Cannot implicitly convert type System.Linq.IQueryable<string> to string

I have two tables called CrewMembers and Rank. On the basis of the CrewMember id, I want to retrieve the name of the rank that is listed in the Rank table. I provided the crewId as an input, and the method would use that information to produce the rank of that particular crew member. Here's how my code looks:... public string GetRank(int Crew...
c# entity-framework iqueryable linq
asked by prers

How do you check if a string contains any strings from a list in Entity Framework?

Consider utilizing...Any... method, Although I'm not sure whether it's supported, it's worth a shot:...var result = context.Data.Where(data => searchTerms.Any(x => data.Name.Contains(x)) || searchTerms.Any(x => data.Code.Contains(x)); ...If this helps,...NotSupportedException... the addition...AsEnumerable...
c# entity-framework
asked by Selman Genç

Linq return parent objects that have child items matching ALL items in separate list

ZZZ_tmp
c# entity-framework-6 linq
asked by Lianne Crocker

cannot convert from 'System.Collections.Generic.List<object>' to 'System.Collections.Generic.List<DAL.model>'

I want to retrieve all determined columns from the model table as queryable I write some code, and it works....Severity Code Description Project File Line Suppression State Error CS1503 Argument 1: cannot convert from 'System.Collections.Generic.List' to 'System.Collections.Generic.List' ...if you need assistance fixing this issue ...
asp.net-web-api entity-framework-6
asked by Mohamed Ahmed Sayed

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow