Posted on: 11/19/2013 3:23:57 AM | Views : 843

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 ...