//
// 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());
}
