Lambda expression

Question

HI

How to convert this sql statement into Linq with lambda expression

select idacuerdo

from c1003

where vigencia >= (select max(vigencia) from c1003 where vigencia <= '20130315')

and vigencia <= '20130315'

Thanks!

Answer 1

 

Can you show the schema and data types for the table c1003?

  

---

Fernando (MCSD)

If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".

Answer 2

Hi Fernando

This is the schema and data types for the table c1003

create table C1003 (
   IDACUERDO   int            identity,
   VIGENCIA      datetime   not null,
   COL1             int            not null,
   ...                  ...             ...
   COLN             int            not null,
   constraint PK_C1003 primary key (IDACUERDO)
)

can you help me ?

Thanks

Answer 3

c1003.Where(c => c.vigencia >= c1003.Where(c1 => c1.vigencia <= 20130315).Max() && c.vigencia <= 20130315).Select(c => c.idacuerdo);

---

Please Mark as Reply and Vote as Helpful if I helped.

Also please visit my blog http://msguy.net/

Answer 4

Hi El.Conde;

Something like the following query should give the same result as the SQL query.

var filterDate = DateTime.Parse( "03/15/2013");

var results = from c in dataContext.c1003
              where c.vigencia >= (c1003.Where(cv => cv.vigencia <= filterDate).Max(cv => cv.vigencia))
              select c.idacuerdo;

  

---

Fernando (MCSD)

If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".

Answer 5

Michael Samteladze, thank you very much !!

Answer 6

Fernando Soto, thank you very much !! Indeed, speak Spanish ?

Answer 7

Hi El.Conde;

Has one of the two solutions given answered your question? If it has please go back to the post and check the "Mark As Answer" to complete the thread on the post that answered the question.

Sí puedo hablar español mucho mejor de lo que se puede leer y escribir, así que me use Google Translate para traducir la pregunta y la respuesta posterior.

  

---

Fernando (MCSD)

If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".