Ado.Net entity framework, linq: select multiples tables

Question

I use these sentence in C# to retrieve data from tables DetalleContenido and Archivo:

var detallesContenido =
   from contenido in guiaContext.Contenido
      where contenido.PuntoInteres.id_punto == puntoInteresID
   from dc in contenido.DetalleContenido
      where dc.Idioma.ds_idioma == idiomaCliente
  select dc;

The relationship between tables is this:

I use puntoInteresID and idiomaCliente to retrieve all rows from DetalleContenido and Archivo that are part of PuntoInteres but whith this sentence Archivo is allways null!!

The sql sentece equivalence is:

Select dc.ds_nomDetContenido, dc.ds_descDetContenido, ar.archivo
from Contenido c, DetalleContenido dc, Archivo ar, Idioma i
where c.id_punto = puntoInteresID
  and c.id_contenido = dc.id_contenido
  and dc.id_idioma = i.id_idioma
  and i.ds_idioma = idiomaCliente
  and dc.id_archivo = ar.id_archivo;

How can I retrieve Archivo too?

Thank you!

JasonRShaver · Accepted Answer · 2009-05-29 19:47:45Z

1

You can also do

.Load()

on the "reference" properity of the selected object (when you are using them).

But as for your query, it seems your Archivo table is a 1 to many and you cannot "include" or "load" the "many" side of the equasion. You would have to do a "select dc.Archivo" I would think.

answered May 29, 2009 at 19:47

JasonRShaver

4,4143 gold badges35 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

VansFannel Over a year ago

You are right. I use select new {dc, dc.Archivo} to obtain the table Archivo.

Tion · Accepted Answer · 2009-05-29 17:52:53Z

0

have you tried using the Include() statement? I think it would look something like this

var detallesContenido =
       from contenido in guiaContext.Contenido.Include("DetalleContenido")
          where contenido.PuntoInteres.id_punto == puntoInteresID
       from dc in contenido.DetalleContenido
          where dc.Idioma.ds_idioma == idiomaCliente
      select dc;

answered May 29, 2009 at 17:52

Tion

1,50017 silver badges28 bronze badges

Comments

Tion · Accepted Answer · 2009-05-29 20:11:55Z

0

how about:

var detallesContenido =
  from contenido in guiaContext.Contenido
      where contenido.PuntoInteres.id_punto == puntoInteresID && contenido.DetalleContenido.Any(c=>c.Idioma.ds_idioma == idiomaCliente)
  select contenido.DetalleContenido;

answered May 29, 2009 at 20:11

Tion

1,50017 silver badges28 bronze badges

1 Comment

VansFannel Over a year ago

I want to retrieve DetalleContenido AND Archivo.

VansFannel · Accepted Answer · 2019-03-19 07:58:30Z

0

My solution:

var detallesContenido =
   from contenido in guiaContext.Contenido
      where contenido.PuntoInteres.id_punto == puntoInteresID
   from detalleContenido in contenido.DetalleContenido
      where detalleContenido.Idioma.ds_idioma == idiomaCliente
   select new { detalleContenido, detalleContenido.Archivo };

Thank you!

edited Mar 19, 2019 at 7:58

answered May 30, 2009 at 5:14

VansFannel

46.2k119 gold badges382 silver badges657 bronze badges

Collectives™ on Stack Overflow

Ado.Net entity framework, linq: select multiples tables

4 Answers 4

1 Comment

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related