find yearly, monthly

Question

hi! frnds

using  Entity Framework 

 

How to get particular year data from the data base using Entity frame work.

like

S.no	Dateofjoin(yyyy-mm-dd format)
1	2015-09-01
2	2014-09-31
3	2015-09-22
4	2014-08-25

 

 1. I will give 2015 and 09 (month)

2015-09-31

S.no	Dateofjoin(yyyy-mm-dd format)
1	2015-09-01
3	2015-09-22

 

 

2.  i will give 2015(yyyy)

 

 

s.no	Doj
1	2015-09-01
3	2015-09-31

 

 please provide solution