static void QueryAll(TestManageDBContext db)
{
foreach (var cls in db.Classes.Where(w => w.Id == 1))
{
Console.WriteLine($"ID:{cls.Id} Name:{cls.ClassName} Memo:{cls.Memo}");
}
}
private static void AddCls(TestManageDBContext db)
{
var cls = new Classes {
ClassName = "班级二", Memo = "第二"
};
db.Classes.Add(cls);
db.SaveChanges();
}
private static void ModifyCls(TestManageDBContext db)
{
var cls = db.Classes.SingleOrDefault(s => s.Id == 2);
if (cls != null)
{
cls.Memo = "二班人很多1111111";
db.SaveChanges();
}
}
private static void RemoveCls(TestManageDBContext db)
{
var cls = db.Classes.SingleOrDefault(s => s.Id == 2);
if (cls != null)
{
db.Classes.Remove(cls);
db.SaveChanges();
}
}
public ClassRepository(TestManageDBContext db)
{
_db = db;
}
public HomeController(TestManageDBContext db)
{
}
