How to add the DB Views to MVC4?

Sneha K

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..

3 Replies

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

Sneha K10y ago
ok lets i have a try
Cassie Mod10y ago
make olso sure your database connection is correct. Otherwise you may get an error about the key. but this is the connection
Cassie Mod10y ago
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.