c# - Connection to table error -

i'm trying list contents of remote sql server db. error occurring in controller. getting nullreference error after doing debugging noticed table isn't being found. i'm not sure if connection string or if i'm missing something. table shows fine in server explorer doesn't show under app data. ideas?

model:

regionalsalesmanagers.cs

public class regionalsalesmanagers {     [key]     public string   code { get; set; }     public char name { get; set; } } 

regionalsalesmanconnection.cs

public class regionalsalesmanconnection : dbcontext {     public regionalsalesmanconnection() : base("regionalsalesmanconnection") { }      public dbset<regionalsalesmanagers > regionalmanagers { get; set; }     } 

webconfig

<add name="regionalsalesmanconnection" providername="system.data.sqlclient" connectionstring="server=01dev\sqldev01;database=caplugs_nav_data;trusted_connection=yes" /> 

homecontroller

public class homecontroller : controller {      regionalsalesmanconnection db = new regionalsalesmanconnection();      public viewresult index() {          var model = db.regionalmanagers.tolist();         return view();     } 

view

@foreach(item in model){ @html.displayfor(item.code, item.name) } 

the homecontroller not passing model view, without further information on exception being raised (or stacktrace details), cause.

so suggested changes:

• use constructor create database context
• pass model view via view(model)

which like:

public class homecontroller : controller {      private regionalsalesmanconnection _db;      public homecontroller() {         _db = new regionalsalesmanconnection();     }      public viewresult index() {        var model = db.regionalmanagers.tolist();        return view(model);     } }