Dear Friends....
I have sql query i wanted to convert that into a linq so, please somebody help me to convert.
I will attach my query here.
select ddlText+'-'+(select ddltext from MasterDropdownValues where TypeCode='year' and slno='1') from MasterDropdownValues where (TypeCode='Month' and SlNo>3)
union all
select ddlText +'-'+(select ddltext from MasterDropdownValues where TypeCode='year' and slno='2') from MasterDropdownValues where (TypeCode='month' and SlNo<4)
Go to the complete details ...