How to add the DB Views to MVC4?

Question

Hai i used Code First approach and viewmodel to insert data into Multiple tabels. Now i want to show all data in INDEX Page for update process. So i create one view in Db ad wrote inner join query in that . Now I have to connect that view which is created in DB to vs express for web. then only i create INDEX VIEW i can give this Db VIEW as Model class . so that i can easily display all data from multiple tables . Now my pblm is created the view in my DB and i connect that view in vb express as edmx file. edmx file ->right click-> update Model from DB and select that view but it not showing . how to connect the DB View in Vs express for Index action.? Advance Thanks..

Sneha Dhandapani · Answer

ok lets i have a try

Cassie Mod · Answer

make olso sure your database connection is correct. Otherwise you may get an error about the key. but this is the connection

Cassie Mod · Answer

First create your models. make sure the class name is the same as the table name otherwise you get problems ( it cost me olmost a day to figger that out). Here youve got some example of the model. using System; using System.Collections.Generic; using System.ComponentModel.DataAnnotations; using System.Data.Entity; using System.Linq; using System.Web; namespace TelerikMvcApp1.Models { public class CollectorStatus { [Key] public int CollectorID { get; set; } public DateTime LastStart { get; set; } public DateTime LastChecked { get; set; } public Boolean ServiceRunning { get; set; } public int? LastBatchID { get; set; } public Boolean BatchCompleted { get; set; } public Byte? BatchErrorID { get; set; } } public class CollectorStatusContext : DbContext { public DbSet Collectors { get; set; } } } after you done that you can generate a new controller wich automaticly adds the html files and generates a table to show the records.