Question

请问用linq to sql 模糊查询日期字段怎么写 我想查询某年某月的数据

sql如下写:
SELECT DATE
FROM TABLE
WHERE (DATEDIFF(M, DATE, CONVERT(varchar(10), '2011-09-01', 120)) = 0)
怎么用linqsql写

Answer 1

var query=from p in TABLE WHERE P.DATE!-NULL && P.DATE..VALUE.YEAR="2011" && P.DATE.VALUE.MONTH="9" SELECT P;