public void InsertCategory(category pobj)
{
sakilaEntities bd = new sakilaEntities();
bd.category.Add(pobj);
bd.SaveChanges();
}
public void Fetch2()
{
using (var ctx = new sakilaEntities())
{
var studentList = ctx.actors
.SqlQuery("SELECT * FROM sakila.actor Where last_name = 'CHASE'")
.ToList <actor>();
}
}
//CRUD methods here Ctrl + .
public void DeleteCategory(int id)
{
sakilaEntities bd = new sakilaEntities();
var query = (from cat in bd.category
where cat.category_id == id
select cat).FirstOrDefault();
bd.category.Remove(query);
bd.SaveChanges();
}
public void UpdateCategory(category pobj)
{
sakilaEntities bd = new sakilaEntities();
var query = (from cat in bd.category
where cat.category_id == pobj.category_id
select cat).FirstOrDefault();
query.name = pobj.name;
query.last_update = pobj.last_update;
bd.SaveChanges();
}
public JsonResult GetData()
{
List <ActorModel> actormodel = new List <ActorModel>();
using (var context = new sakilaEntities())
{
List <actor> b = context.actors.ToList();
actormodel.Add(new ActorModel()
{
id = 1,
f_name = "MS",
l_name = "Vivek",
last_update = DateTime.Now
});
}
return(Json(actormodel.ToList(), JsonRequestBehavior.AllowGet));
}
public ActionResult List()
{
var List = new sakilaEntities().actors.ToList();
return(View(List));
}
public void TestGetFilms()
{
using (Bovril.EntityFramework.Sakila.sakilaEntities context = new sakilaEntities()) {
Bovril.EntityFramework.Sakila.film[] films = context.films.ToArray();
}
}
