-1

Can you help me to convert SQL to LINQ:

select empno, dd, Min(sdate) sdate from TransactionPoolView
where sdate >= '" & DateValue(sdate) & "' and sdate < '" & DateValue(edate + 1) 
group by empno, dd
abatishchev
  • 98,240
  • 88
  • 296
  • 433
user3451498
  • 1
  • 1
  • 8
    Welcome to Stack Overflow! Please don't just ask us to solve the problem for you. Show us how _you_ tried to solve the problem yourself, then show us _exactly_ what the result was, and tell us why you feel it didn't work. See "[What Have You Tried?](http://whathaveyoutried.com/)" for an excellent article that you _really need to read_. – John Saunders Mar 23 '14 at 06:42

2 Answers2

0

There are some SQL to LINQ Converters,You can use

Linqer http://www.sqltolinq.com

LINQPad http://www.linqpad.net/

NullReferenceException
  • 1,641
  • 15
  • 22
0

I find solution http://msdn.microsoft.com/en-us/vstudio/bb737926#grpbymin there is really nice example

user3451498
  • 1
  • 1