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!";
}
}
