Fetch Only Date From Date field from SQL Ser. DB using linq?

Hi,

I think, Field type Datatime right? so datatime type has on property called Date. using this property you can get only date.

Like

var p = from l in context.DateExample
 select new
 {
    date1 = l.DateTimeFiled.Date
 }

hope this will help you.