LINQ傻瓜教学之三：更改列名如何写select isnull(column1,0) as StoreName from table1

其实很简单，就是

<pre code_snippet_id="1675837" snippet_file_name="blog_20160509_1_9497920" name="code" class="csharp">Area = store.stm_lArea.GetValueOrDefault(0)
 

Data.dcDataContext dc = new Data.dcDataContext(this.gzConnectionString);
var stores = from store in dc.StoreMaster_stm

select new Name = store.stm_cStoreName, Area = store.stm_lArea.GetValueOrDefault(0), OpenDate = store.stm_dOpenDate.GetValueOrDefault(DateTime.Parse("2009-10-1")), Desc = store.stm_cDesc.ToString()}; GridView1.DataSource = stores;GridView1.DataBind();