convert model to viewmodel

Question

I have a table name "Product" and another table name "category". Product table has 'productID', 'productName' and 'CategoryID'. Category table has 'categoryID' and 'categoryName'.

My target is to display a list of products with category. The list will contain 'product id', 'product name' and 'category name'.

I have created a viewmodel. the code is

public int prodID{get;set;}
public int prodName{get;set;}
public int catName{get;set;}

In my controller, I have:

var query= from p in dc.Product
                      select new {p.ProductID,p.ProductName,p.Category1.CategoryName };
var prod = new ProductIndexViewModel()
        {
            ProductList=query //this line is problematic !!it says an explicit conversion exists....
        };
        return View(prod);

How would I write my controller code so that it matches with the viewmodel??

krolik · Answer 1 · 2016-03-14T15:19:29.287

7

You can use AutoMapper instead of rewriting properties from db model.

var viewModel = new ProductIndexViewModel()
{  
    ProductList = dc.Product.ToList().Select(product => Mapper.Map<Product, ProductViewModel>(product));
}

edited Mar 14 '16 at 15:19

answered Sep 05 '11 at 21:50

krolik

5,712
1
26
30

I'm using Automapper in WCF but i'm not able to map Entity model with Model of data contract,what i should do?? This is what i tried: `requestDC = dbEntity.RequestDetails.ToList().Select(req => Mapper.Map(req));` //I'm not able to access dbEntity.RequestDetails under Mapper.Map – Vishal I P Nov 07 '14 at 07:39

score 5 · Accepted Answer · answered Sep 05 '11 at 19:30

Maybe you will use your view model class directly:

       var query = from p in dc.Product
                    select new ProductIndexViewModel() { 
                        prodID = p.ProductID, 
                        prodName = p.ProductName, 
                        catName = p.Category1.CategoryName 
                    };

        List<ProductIndexViewModel> productForView = query.ToList();

score 1 · Answer 3 · answered Sep 05 '11 at 19:29

1

Should prodName and catName be strings?

Also, why not just do this:

var viewModel = dc.Product
    .ToList()
    .Select(x => new ProductIndexViewModel { prodID = x.ProductId, ... }

return View(viewModel);

answered Sep 05 '11 at 19:29

David Wick

7,055
2
36
38

convert model to viewmodel

3 Answers3

Linked