/// <summary> /// LINQ Method syntax /// </summary> /// <returns></returns> public List <BASE_CITY> GetAllCity() { using (var context = new ManagerSiContext()) { var list = context.BASE_CITY.Where(i => i.STATE == "1").ToList(); return(list); } }
/// <summary> /// LINQ Method syntax /// </summary> /// <returns></returns> public BASE_USER GetByAccount(string name, string pwd) { using (var context = new ManagerSiContext()) { var list = context.BASE_USER.Where(i => i.State == "1" && i.UserAccount == name && i.UserPWD == pwd).FirstOrDefault(); return(list); } }
/// <summary> /// SQL /// </summary> /// <returns></returns> public int UpdateCityBySQL() { using (var context = new ManagerSiContext()) { var num = context.Database.ExecuteSqlCommand("Update BASE_CITY set STATE = '1' where id = 1"); return(num); } }
/// <summary> /// Native SQL /// </summary> /// <returns></returns> public List <BASE_CITY> GetAllCityByNativeSQL() { using (var context = new ManagerSiContext()) { var list = context.BASE_CITY.SqlQuery("Select * from BASE_CITY where STATE == '1'").ToList(); return(list); } }
////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////// /// <summary> /// LINQ Method syntax /// </summary> /// <returns></returns> public List <房屋租赁表> GetAllCity() { using (var context = new ManagerSiContext()) { var list = context.房屋租赁表.Where(i => i.State == "1").ToList(); return(list); } }
/// <summary> /// LINQ Query syntax /// </summary> /// <returns></returns> public List <BASE_CITY> GetAllCityByLINQQuery() { using (var context = new ManagerSiContext()) { var L2EQuery = from st in context.BASE_CITY where st.STATE == "1" select st; var list = L2EQuery.ToList(); return(list); } }
/// <summary> /// Entity SQL /// </summary> /// <returns></returns> public List <BASE_CITY> GetAllCityBySQL() { using (var context = new ManagerSiContext()) { //Querying with Object Services and Entity SQL string sqlString = "SELECT VALUE st FROM ManagerSiContext.BASE_CITY " + "AS st WHERE st.STATE == '1'"; var objctx = (context as System.Data.Entity.Infrastructure.IObjectContextAdapter).ObjectContext; ObjectQuery <BASE_CITY> student = objctx.CreateQuery <BASE_CITY>(sqlString); //BASE_CITY newStudent = student.First<BASE_CITY>(); return(student.ToList()); } }