c# - concatenate data bind in dropdown using linq -

i have table select data , there 3 columns merge or concatenate these columns.. query , data

 select (region+'    '+cast(startdate+''+enddate varchar)) data,id tblregion_uni 

data

 data                           id uk    mar 31 2128 11:59pm       1    mar 31 2128 11:59pm       2 paris mar 31 2128 11:59pm       3 

now try bind data in dropdown using linq want above sql query in linq .. below linq query simple select data want concatenate in linq

private list<tblregion_uni> getregion()     {    using(trackdataentities1 tee=new trackdataentities1())          {              return (from ta in tee.tblreg select new { ta.region, ta.startdate, ta.enddate }).tolist();           }      }   protected void page_load(object sender, eventargs e)     {         if(!page.ispostback)         {             regiondrop.datasource = getregion();             regiondrop.datatextfield = "data";             regiondrop.datavaluefield = "id";             regiondrop.databind();          }     } 

when try error occur

cannot implicitly convert type 'system.collections.generic.list<anonymoustype#1>' 'system.collections.generic.list<chart_project.tblregion_uni>'

any solution?

because working data in database, , data has special nullable values, can't filtered , bring them memory need firstly bring datas memory , make whatever want.

create new viewmodel class property want:

public static class mylist{     public static int id {get; set;}     public static string data {get; set;} } 

then in code, want suitable data make method:

private list<mylist> getregion()     {        using(trackdataentities1 tee=new trackdataentities1())          {              var templist=tee.tblreg.tolist();              var list=(from ta in templist                       let data = ta.region + " " + ta.startdate??datetime.now.tostring() + " " + ta.enddate??datetime.now.tostring()                        select new{data, ta.id}).select(x=> new mylist{                       id=x.id,                       data=x.data}).tolist();              return list;          }      } if(!page.ispostback) {          regiondrop.datasource = getregion();          regiondrop.datatextfield = "data";          regiondrop.datavaluefield = "id";          regiondrop.databind(); }