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 ,Actually those are entities I am storing in an IEnumerable collection. I want to convert the list to a comma separated string, but I want only one specific property, How do I build a comma separated string with a specific property from a custom object list?

I know i can build a comma separated list by using a "Foreach / For (int i .... " but I think there is a easy and a better way for this So what would be that easy way?

This is 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

This is very easy , Isn't it ? 

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

Popular Answer

Just try with this.

By using this version of the string.Join<string> method, you can reduce copies of your collection before joining.

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? (,)

What you can do is define a custom property on the Object that does this for you:...Edited for clarity with your objects...You would write something like...public partial class Clients { public string FullName { get { return String.Format("{0}, {1}", LastName, FirstName); } } } ...This will give you a read only property ...FullN...
asp.net c# entity-framework
asked by msarchet

First List of Entity Framework Code Mapping of Properties

No, EF doesn't have any type converters or custom type mappers as alternative to model binders from MVC. You must always use some hack to force persistence. Another way to do the same is mapping ...TextOptions... as collection of related entities. It will make your separation of concerns better but it will complicate your model and working with ...
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 store an object that contains a List of primitives using EF....public class MyObject { public int Id {get;set;} public virtual IList<int> Numbers {get;set;} } ...I know that ...EF cannot store... this, but I'd like to know possible solutions to solve this problem....The 2 Solutions I can think of are:...1....Create a Dummy object....
entity-framework list mapping orm
asked by Bernhard Kircher

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

You are selecting to an anonymous type, which is not a ...Customer.......If you want to do (sort of) this, you can write it like this:...return db.Customers.Select(x => new Customer { Name = x.CustName, Email = x.CustEmail, Address = x.CustAddress, ContactNo = x.ContactNo }).ToList(); ...This assumes the properties on your ...Customer... object are...
asp.net c# entity-framework linq
asked by Mark Avenius

Convert list of of objects to list of tuple without iterating

Like 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 named Rank and CrewMembers.I want to fetch the name of rank which is present in Rank table on the basis of id of CrewMember.I have passed the crewId as a parameter and on the basis of that the method would return the Rank of that specific Crew Member.This is how my code is-... public string GetRank(int CrewId) { ...
c# entity-framework iqueryable linq
asked by prers

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

You can try using ...Any... method, I'm not sure whether it's supported but it's worth trying:...var result = context.Data.Where(data => searchTerms.Any(x => data.Name.Contains(x)) || searchTerms.Any(x => data.Code.Contains(x)); ...If this gives you ...NotSupportedException... you can add ...AsEnumerable... b...
c# entity-framework
asked by Selman Genç

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

I have an object which has a variable length list of items (incomingList in code example) and a list of people which each have a list of items. I want to return only those people that have all the items in the incomingList....So looking at the example, I only want person 1 and 3 returned....The people are in a database and I want to retrieve as li...
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 code blow it shows me ...Severity Code Description Project File Line Suppression State Error CS1503 Argument 1: cannot convert from 'System.Collections.Generic.List' to 'System.Collections.Generic.List' ...any help to solve this error with the best...
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