61,112
社区成员
发帖
与我相关
我的任务
分享
<connectionStrings>
<add name="UserEntities" connectionString="Data Source=.\sqlexpress
;Data Source=200.200.200.200;Database=WebCMS;User ID=sa;Password=1234;" providerName="System.Data.SQLClient"/>
</connectionStrings>
namespace MvcTest.Models
{
public class UserEntities:
DbContext
{
public UserEntities()
: base("UserEntities")
{
}
public DbSet<T_User> Users { get; set; }
}
}
namespace MvcTest.Models
{
public class T_User
{
[Key]
public int UserID { get; set; }
public string UserName { get; set; }
public string UserPWD { get; set; }
public int UserRole{ get; set; }
}
}
UserEntities userDB = new UserEntities();
public ActionResult Try()
{
var users = userDB.Users.ToList();
return View(users);
}
Invalid column name 'UserRole'.