// // GET: /Home/Details/5 public ActionResult Details(int id) { eftestEntities ctx = new eftestEntities(); // var students= ctx.Database.SqlQuery<student>("select * from student",new object()).ToList(); //students.FirstOrDefault().Age = 89; //ctx.SaveChanges(); //ctx.student.Where(x=>x.Name==EntityFunctions.AsNonUnicode()) //var stus = ctx.Set<student>().SqlQuery("select * from student", new object()).ToList(); //stus.FirstOrDefault().Age = 89; //ctx.SaveChanges(); var sql = "select Age from Student where Name = @Name and Age = @Age"; //var tst= ctx.Database.SqlQuery<int>( // sql, // new MySqlParameter("@Name", "fxp"), // new MySqlParameter("@Age", 89)).ToList(); //var param = new MySqlParameter("@id", 1); //var list = ctx.Database.SqlQuery<int>("call getage(@id)", param).ToList(); return(View()); }
// // GET: /Home/ public ActionResult Index() { eftestEntities ctx = new eftestEntities(); // var students= ctx.Database.SqlQuery<student>("select * from student",new object()).ToList(); //students.FirstOrDefault().Age = 89; //ctx.SaveChanges(); //ctx.student.Where(x=>x.Name==EntityFunctions.AsNonUnicode()) //var stus = ctx.Set<student>().SqlQuery("select * from student", new object()).ToList(); //stus.FirstOrDefault().Age = 89; //ctx.SaveChanges(); var sql = "select Age from Student where Name = @Name and Age = @Age"; //var tst= ctx.Database.SqlQuery<int>( // sql, // new MySqlParameter("@Name", "fxp"), // new MySqlParameter("@Age", 89)).ToList(); MySqlParameter[] parameters = new MySqlParameter[] { new MySqlParameter() { Direction = ParameterDirection.Input, DbType = DbType.Int32, Value = 1, ParameterName = "@id" }, new MySqlParameter() { // Direction = ParameterDirection.Output, DbType = DbType.Int32, ParameterName = "@cnt" } }; //var ttttt= ((IObjectContextAdapter) ctx).ObjectContext.ExecuteStoreQuery<student>("call getage(@id,@cnt)", // parameters.ToArray()).ToList(); // var str= ctx.Database.SqlQuery<student>("call getage(@id,@cnt)", parameters.ToArray()).ToList(); var list = ctx.ExecuteStoredProcedureList <student>("call getage(@id)", parameters.ToArray()).ToList(); return(View()); }