Home / Questions / 367848
Accepted
Nicolas Oñate
Asked: 2020-06-24 03:44:25 +0800 CST 2020-06-24 03:44:25 +0800 CST

DataRow.Field<Model> How do I set it?

  • 772

I have a model with the following structure:

public class ModeloUno
{
    public int Id { get; set; }
    public string Nombre{ get; set; }
    public string Descripcion { get; set; }
    public Status Status { get; set; }
}

public class Status
{
    public int Id { get; set; }
    public string Nombre{ get; set; }
}

With a database query I obtain the fields of ModeloUno plus Status (Id, Name, Description, IdStatus and NameStatus) and set them as follows:

var modelo= rows.Select(r => new ModeloUno
            {
                Id = r.Field<int>("ID"),
                Codigo = r.Field<string>("NAME"),
                Descripcion = r.Field<string>("DESCRIPTION"),
                Status = r.Field<Status>(???)
            });

How do I set Status if it has multiple fields?

c#

1 Answers

  1. Best Answer

    Simply do the following:

    var modelo= rows.Select(r => new ModeloUno
        {
            Id = r.Field<int>("ID"),
            Codigo = r.Field<string>("NAME"),
            Descripcion = r.Field<string>("DESCRIPTION"),
            Status = new Status(){Id=r.Field<int>("IdStatus"), Nombre=r.Field<string>("NombreStatus")}
        });

    What is done here is to create a new type variable Statususing an object initializer , which basically consists of assigning the initial value to each field of the object.

    In this case, what you want is to assign to Status.Idthe value intthat is in the column IdStatus, and to Status.Nombrethe value stringthat you have in the column NombreStatus.

    PS I strongly recommend that the name of the class and the name of the variable do not match ( Status), that can lead to a lot of confusion. On the other hand, for the case you expose it would not be necessary to create the class Status, you could simply add IdStatusand NombreStatusas variables in ModeloUno. Another thing is that the relationship between one ModeloUnoand Statusoutside of one to several. In that case, it would make sense to create the class Statusand store it inside ModeloUnoas List<Status>.

    • 2