Question

linq to sql 查询两者之间的语句怎么写，例如7月份到8月份的数据

Answer 1

form t in table(表)
where t.datetime(字段名)>=[时间] and t.datetime<=[时间]
select t;

Answer 2

SQL:
(1) select * from tablename where datefield between to_date('2011-07-01 00:00:00','yyyy-mm-dd hh24:mi:ss') and to_date('2011-09-01 00:00:00','yyyy-mm-dd hh24:mi:ss');
(2) select * from tablename where to_char(datefield, 'mm') in ('07', '08');

追问

我要是的 linq to sql

追答

linq to sql，完全没接触过。高手们现身吧。