ranjan sahoo

ranjan sahoo

  • NA
  • 311
  • 266.7k

linq datepart

May 6 2014 6:44 AM
hiiiii
 I have some problem in linq date.
i want to select data by using year only
my database column date are present like 2014-05-6
but i want to select data by using year only i.e 2014 only
 
i am writing in sql like 
select * from Holiday_List where YEAR(list_date)=2014
but i wants in this type query using LINQ .how is possible . give me example 
plz...
Thanx

Answers (2)