Get comma separated string from List

List<string> ids;

string cids = string.Join(",", ids.ToArray());

Select hierarchical data

with h(id, name, parent, level) as

(

select id, name, parent, 0 as level

from task

where id = 48358

union all

select t.id, t.name, t.parent, t2.level + 1

from task t

inner join h t2 on t.parent = t2.id

)

select * from h;

Get extenstion in c#

Path.GetExtension(filename) Return value includes '.'

Image convert in c#

Image imgInFile = Image.FromFile(inFileName); imgInFile.Save(outFileName, ImageFormat.Jpeg);

IEnumerable to ObserverbleCollection

IEnumerable<Object> ienumerable;

ObserverbleCollection<Object> observableCollection = new ObservableCollection<Object>(ienumerable);