ASP.NET MVC : transfering query data to model class object in controller

Question

I have the query with a join

  var DetailsQuery = (from a in db.aTable
                                 join b in db.bTable on a.carID equals b.ID
                                 where a.ID==id
                                    select new
                                 {
                                     ID = a.ID != null ? a.ID : 0,
                                     aName= a.aName,
                                     carName= b.carName,
                                 }).Take(1);

Am I doing correct using Take(1)? There actually any way must be only one row with such ID, so should I write this Take(1) or It will work without it?

Now, I created a new model class for the view

public class ModifiedaTableModel
{
        [Key]
        [Required(ErrorMessage = "aIDis required.")]
        public int aID{ get; set; }
        [Required(ErrorMessage = "aName required.")]
        public string aName{ get; set; }
        [Required(ErrorMessage = "carName required.")]
        public string carName{ get; set; }
}

How can I transfer this query object to this model and so I can show it in view?

If you don't know for sure you can get whole result, check if it's more than one, log some error or whatever, then take .First(). — SᴇM
– SᴇM, Commented Oct 19, 2018 at 6:59

Salomon Zhang · Accepted Answer · 2018-10-19 07:09:33Z

1

  var DetailsQuery = (from a in db.aTable
                                 join b in db.bTable on a.carID equals b.ID
                                 where a.ID==id
                                    select new
                                 {
                                     ID = a.ID != null ? a.ID : 0,
                                     aName= a.aName,
                                     carName= b.carName,
                                 }).FirstOrDefault();

For using the view model in the view:

@model <your project name>.ViewModels.ModifiedaTableModel;

Assume you have your view model class in "ViewModels" folder.

edited Oct 19, 2018 at 7:09

answered Oct 19, 2018 at 6:59

Salomon Zhang

1,5653 gold badges23 silver badges42 bronze badges

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

Comments

JChou · Accepted Answer · 2018-10-19 07:35:06Z

0

Controller:

var DetailsQuery = from a in db.aTable
                   join b in db.bTable on a.carID equals b.ID
                   where a.ID == id
                   select new ModifiedaTableModel
                   {
                       ID = a.ID != null 
                            ? a.ID 
                            : 0,
                       aName = a.aName,
                       carName = b.carName
                   });

return View(DetailsQuery.FirstOrDefault());

View (namespace of model may be required):

@model ModifiedaTableModel

If you select only anonymous type object, an InvalidOperationException might occur during view rendering.

answered Oct 19, 2018 at 7:35

JChou

916 bronze badges

Collectives™ on Stack Overflow

ASP.NET MVC : transfering query data to model class object in controller

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related