sql 转LINQ 的问题

[sinat_24597717]

SELECT type_id,type_text,type_sort_value FROM
(

(SELECT type_id,type_text,type_sort_value
FROM
product_type_table WHERE type_id
IN
（'1010','1020','1030','1040','2030','2060','2061','2070')
UNION
SELECT ('2050') type_id,'电子影音'
type_text,06 type_sort_value
FROM
product_type_table
WHERE
type_id IN（'2020','2050','2051') GROUP BY type_level)
ORDER BY
type_sort_value)
UNION
(SELECT type_id,type_text,type_sort_value
FROM product_type_table WHERE type_parentid IN（'1010','1020','2020',
'1030','1040','2030','2050','2051''2060','2061','2070')
)

如何转换成sql呢？ 求助