SQL select column belonging to an entity

Question

Hello,

i retrive a from sql query several column, some of them are correctly binded to my object entity, but for more complex object inside i cant have the right bind.

for example if i have :

public class MyBox
  {
        public Box Box { get; set; }
        public bool New { get; set; }
 }

public Box 
{
        public string Name { get; set; }
        public string Color { get; set; }
        public string Desc { get; set; }
} 

var myboxes = executereader("sp_boxes",CommandType.StoredProcedure, SqlParam)

I try to read from stored procedure the records :

  SELECT
     Box.name ,
     Box.color,
     Box.desc,
     State.new,
  FROM tblBoxes as Box,tblState as State

the reading is successful and I have correctly bind the simple property stringNew, but i have null in more complex box object.

Answer 1

How do you store data in an instance of MyBox?

Is it acceptable to put the obtained data in the datatable and then manually convert it to MyBox?

        public static List<MyBox> GetMyClasses(DataTable dataTable)  
        {  
            List<MyBox> items = dataTable.AsEnumerable().Select(row =>  
                new MyBox  
                {  
                    New = row.Field<bool>("New"),  
                    Box = new Box() { Name = row.Field<string>("Name"), Color = row.Field<string>("Color"),Desc = row.Field<string>("Desc") }  
                }).ToList();  
            return items;  
        }  

Or are you using an orm framework like EF?

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Try another class:

public class MyBox : Box
{
   public bool New { get; set; }
}