i have a questions on Asp.Net MVC

i am getting error during the creation of View ? i am using multiple table in single model

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace ShopInDeal.ViewModels

{

class BusinessViewModel

{

//BusinessTable (table name)

public int ShopId { get; set; }

public string ShopName { get; set; }

public Nullable FlagApproval { get; set; }

public Nullable Createdby { get; set; }

public Nullable CreatedOn { get; set; }

public Nullable UpdatedBy { get; set; }

public Nullable UpdatedOn { get; set; }

public Nullable Active { get; set; }

//BusinessLocation (table name)

public int LocationID { get; set; }

public string Location { get; set; }

//public Nullable ShopId { get; set; }

public string Longitude { get; set; }

public string Latitude { get; set; }

//public Nullable Createdby { get; set; }

//public Nullable CreatedOn { get; set; }

//public Nullable UpdatedBy { get; set; }

//public Nullable UpdatedOn { get; set; }

//public Nullable Active { get; set; }

//Business_CatagoryRelation (table name)

public int shopcategoryrelationid { get; set; }

public Nullable shopId { get; set; }

public Nullable CategoryId { get; set; }

//public Nullable Createdby { get; set; }

//public Nullable CreatedOn { get; set; }

//public Nullable UpdatedBy { get; set; }

//public Nullable UpdatedOn { get; set; }

//public Nullable Active { get; set; }

//Business_SubCatagoryRelation (table name)

public int shopsubcategoryrelationid { get; set; }

//public Nullable shopId { get; set; }

//public Nullable CategoryId { get; set; }

public Nullable SubCategoryId { get; set; }

//public Nullable Createdby { get; set; }

//public Nullable CreatedOn { get; set; }

//public Nullable UpdatedBy { get; set; }

//public Nullable UpdatedOn { get; set; }

//public Nullable Active { get; set; }

}

2 Replies

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

David Gálvez10y ago
Accepted answer
Hi,
you must define the key per table.
check that the tables have defined the key
Vinay Singh10y ago
Hi
have a look of the below links
http://stackoverflow.com/questions/15445786/add-controller-error-unable-to-retrieve-metadata
http://forums.asp.net/t/1838396.aspx?Error+while+adding+controller+class+Unable+to+retrieve+metadata+for+MvcMovie+Models+Movie+
http://www.codeproject.com/Questions/839385/How-to-resolve-Unable-To-retrieve-metadata-for-MVC