private void TestQueryData() { using (var db = new EFLocalTest()) { //ViewBag.QueryTable = db.T_F_Demo.SqlQuery("select * from T_F_Demo").ToList(); mCurrentController.ViewBag.QueryTable = db.Database.SqlQuery <string>("select username from oasis").ToList(); } }
public void TestDelData() { using (var db = new EFLocalTest()) { var model = (from n in db.T_F_Demo where n.name == "test" select n).FirstOrDefault(); db.T_F_Demo.Remove(model); mCurrentController.ViewBag.SaveResult = db.SaveChanges(); } }
public void TestAddData() { using (var db = new EFLocalTest()) { var model = new T_F_Demo(); model.name = "TESTModel"; model.des = "TESTModelDes"; db.T_F_Demo.Add(model); mCurrentController.ViewBag.SaveResult = db.SaveChanges() > 0 ? "Successfully saved!" : "Error out!"; } }