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