SubQuery en LinQ

Article View: es.comp.lenguajes.php

Article #108

Back to es.comp.lenguajes.php Previous Next

#108

From: Paul
Date: Thu, 13 Aug 2009 08:35

13 lines
1510 bytes

Hola,
Necesito hacer una subquery y no logro hacerla.

SELECT *
     FROM Pedido
     WHERE IdPedido IN
    (SELECT Id FROM Pedidos)

Como hacer esto en LinQ de forma parecida a esto:
    lstPedidosFindAll(.....);    // Donde lstPedidos es: private
List<Pedido> lstPedidos=new List<lstPedidos>();

Gracias

Technical Details

Message-ID: <73cca49e-419b-4c70-8497-e4e7703d7dc8@a13g2000yqc.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news2.google.com!postnews.google.com!a13g2000yqc.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: f9da90502c,1ee4cd62986c412a,start
X-Google-Attributes: gidf9da90502c,public,usenet
X-Google-NewGroupId: yes
X-Google-Language: SPANISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news2.google.com!postnews.google.com!a13g2000yqc.googlegroups.com!not-for-mail
From: Paul <gambamia2@yahoo.es>
Newsgroups: es.comp.lenguajes.php
Subject: SubQuery en LinQ
Date: Thu, 13 Aug 2009 01:35:08 -0700 (PDT)
Organization: http://groups.google.com
Lines: 13
Message-ID: <73cca49e-419b-4c70-8497-e4e7703d7dc8@a13g2000yqc.googlegroups.com>
NNTP-Posting-Host: 213.96.16.85
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1250152508 13878 127.0.0.1 (13 Aug 2009 08:35:08 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 13 Aug 2009 08:35:08 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: a13g2000yqc.googlegroups.com; posting-host=213.96.16.85; 
 posting-account=Vu5b7QoAAABTTa6GfGE70CeorlICcZJ1
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; es-ES; rv:1.9.0.13) 
 Gecko/2009073022 Firefox/3.0.13 GTB5 (.NET CLR 3.5.30729),gzip(gfe),gzip(gfe)