load master detail from entity framework

Good afternoon, I need to show master detail data, I already have the data in the database. how do you see next

I also have the classes in the model

namespace CapaDatos
{
using System;
using System.Collections.Generic;
public partial class tblMaestroVenta
{
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
public tblMaestroVenta()
{
this.tblDetalleVentas = new HashSet();
}
public int Id { get; set; }
public string NumeroVenta { get; set; }
public System.DateTime FechaVenta { get; set; }
public Nullable<int> IdCliente { get; set; }
public double ValorVenta { get; set; }
public int IdUsuario { get; set; }
public virtual tblCliente tblCliente { get; set; }
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
public virtual ICollection tblDetalleVentas { get; set; }
}
}

a MasterSale class that inherits from tblMaestroventa

namespace CapaLogica
{
public class MaestroVenta : tblMaestroVenta
{
public string NombreCliente { get; set; }
public string NombreUsuario { get; set; }
// Guardar
public static int GuardarMaestroVenta(MaestroVenta maestroVenta)
{
using (GourmetEntities db = new GourmetEntities())
{
try
{
var returnCode = new SqlParameter("@ReturnValueId", SqlDbType.Int);
returnCode.Direction = ParameterDirection.Output;
db.Database.ExecuteSqlCommand("Sp_InsertarMaestroVenta @FechaVenta,@IdCliente,@ValorVenta,@IdUsuario, @ReturnValueId OUTPUT",
new SqlParameter("@FechaVenta", maestroVenta.FechaVenta),
new SqlParameter("@IdCliente", maestroVenta.IdCliente),
new SqlParameter("@ValorVenta", maestroVenta.ValorVenta),
new SqlParameter("@IdUsuario", maestroVenta.IdUsuario),
returnCode);
db.SaveChanges();
return (int)returnCode.Value;
}
catch (Exception exp)
{
var me = exp.Message;
throw;
}
}
}
public static tblMaestroVenta MaestroDetalle(int Id)
{
using (GourmetEntities db = new GourmetEntities())
{
return db.tblMaestroVentas.Include(x => x.tblDetalleVentas)
.FirstOrDefault(x => x.Id == Id);
}
}
}
}

I also have the detail class

A SalesDetail class inherited from tblDetalleVenta

namespace CapaLogica
{
public class DetalleVenta : tblDetalleVenta
{
//public int IdProducto { get; set; } // 0 Se guarda en la BD
public string Codigo { get; set; } // 0
public string Descripcion { get; set; } // 1
// public decimal PrecioVenta { get; set; } // 2
public string Unidad { get; set; } // 3
public decimal TotalFila { get { return Precio * (decimal)Cantidad; } } // 5
public static void InsertarDetalleVenta(tblDetalleVenta detalleVenta)
{
using (GourmetEntities db = new GourmetEntities())
{
db.Sp_InsertarDetalleVenta(detalleVenta.IdtblMaestroVenta, detalleVenta.IdProducto, detalleVenta.IdUnidadMedida, detalleVenta.IdCategoria, detalleVenta.Precio, detalleVenta.Cantidad, detalleVenta.ValorFila);
}
}
}
}

I have a method that returns the query

I use all this with entity Framework

now I have my RDLC Report

to load in the form I made this code

but only load part of master as you can see in the following image

Please can someone help me to solve this problem, or can you give me an example of how to solve this problem please. I appreciate the collaboration

Robert

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Farhan Ahmed6y ago
Accepted answer
Use ViewModel mention the field you want to display and use that ViewModel Class in controller simillerly in view.
Please check out belove link example
https://www.c-sharpcorner.com/article/working-with-multiple-table-using-linq-join-in-mvc/
RobertoCarlos Melgar6y ago
Farhan Admed,
Jignesh Kumar

Thank you very much to both. I was able to load a model that is not orders ditals, the problem is with this related model, I already added this line of code

db.Configuration.LazyLoadingEnabled = false;

but my problem continues, I'm thinking that the problem is in this part of the code

MaestroVentaBindingSource.DataSource = MaestroVenta.MaestroDetalle(1);
DetalleVentaBindingSource.DataSource = MaestroVenta.MaestroDetalle(1);

with the code that you add in the same way, just load the header
Please can you continue to help me. thank you.
Robert
Jignesh Kumar6y ago
Hi,

Please use below link, You need to make lazy loading disable ,

https://www.tektutorialshub.com/entity-framework/ef-eager-loading/
public static tblMaestroVenta MaestroDetalle(int Id)
        {
            using (GourmetEntities db = new GourmetEntities())
            {
               db.Configuration.LazyLoadingEnabled = false;
                return db.tblMaestroVentas.Include(x => x.tblDetalleVentas)
                    .FirstOrDefault(x => x.Id == Id);
            }
        }