Mapping MVC3 model to MSSQL 2008 View using code first and database first

Question

In SQL Server 2008 I have a view like this:

CREATE VIEW products AS
   SELECT a.ID, a.Name, b.ID as SubID, b.Name as SubName
   FROM main_product as a 
   INNER JOIN sub_product as b on a.ID = b.mainID

This is my model:

Public class Products
{
    public int ID { get; set; }
    public int Name { get; set; }
    public int SubID { get; set; }
    public int SubName { get; set; }
}

Now how can I map my MVC3's view to the SQL Server view?

UPDATE

I tried with this:

 public class PartialContext : DbContext
 {       
     protected override void OnModelCreating(DbModelBuilder modelBuilder)
     {
         modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();
     }

     public DbSet<Test> Test { get; set; }

     public DbSet<Products> Products { get; set; }
 }

and Controller:

public class ViewController : Controller
{
    private PartialContext db = new PartialContext();

    //
    // GET: /View/

    public ViewResult Index()
    {
        return View(db.Products.ToList());
    }
}

This effort gave me an error: "Invalid object name 'dbo.Products'."

EDIT 2

Just to clarify. I want to use both code first and database first technique. It means I want to create both database and model class manually, not through code generator or database generator

UPDATE

Problem solve. I make a mistake on naming model class

Regular entity, use it like a regular Table, exactly the same — hackp0int
– hackp0int, Commented May 20, 2013 at 7:09
How are you accessing your data? Raw ADO.NET? Entity Framework? Something else? — marc_s
– marc_s, Commented May 20, 2013 at 7:14
AFAIK you cant insert data in the sql VIEW so there is not point in mapping the mvc view on to the db view — Dakait
– Dakait, Commented May 20, 2013 at 7:36
I want to map mvc view with db view for front end read only purpose — Doan Cuong
– Doan Cuong, Commented May 20, 2013 at 7:38

Dakait · Accepted Answer · 2013-05-20 07:41:23Z

5

update the EF model

enter image description here

now simply you can query the view like

 using (var ctx = new YourDBContext())
  {
    var result = from t in ctx.product
                 select new Products{
                   ID= ctx.ID,
                   Name=ctx.Name
                 };    
  }

1 Comment

Doan Cuong Over a year ago

That really helpful, but I'm looking for the way to use code first and db first at a same time. I mean that I want to create the model class manually, not through the code generator

Collectives™ on Stack Overflow

Mapping MVC3 model to MSSQL 2008 View using code first and database first

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related