EF的API

using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;
using WebApplication15.Models;
namespace WebApplication15.Controllers
{
 public class UserLoginController : ApiController
 {
  UserDBHelper db = new UserDBHelper();
  [HttpGet]
  //登录
  public UserLogin Login(string UserName, string PassWord)
  {
    var list = db.logins.Where(p => p.UserName.Contains(UserName) && p.PassWord.Contains(PassWord)).FirstOrDefault();
    return list;
  }
  [HttpPost]
  //注册
  public int ZhuCe(UserLogin ul)
  {
    db.logins.Add(ul);
    return db.SaveChanges();
  }
  [HttpGet]
  //显示
  public List<Student> Show()
  {
    return db.students.ToList();
  }
  [HttpPost]
  //添加
  public int Add(Student s)
  {
    db.students.Add(s);
    return db.SaveChanges();
  }
  [HttpGet]
  //查询
  public List<Student> Find(string Name)
  {
    if (Name==null)
  {
   return db.students.ToList();
  }
  else
  {
    return db.students.Where(p => p.Name.Contains(Name)).ToList();
  }
  }

  //删除
  [HttpDelete]
  public int Delete(int Id)
  {
    var list = db.students.Find(Id);
    db.students.Remove(list);
    return db.SaveChanges();
  }
  [HttpGet]
  //反填
  public Student GetStudent(int Id)
  {
    var list = db.students.Find(Id);
  return list;
  }
  [HttpPost]
  //修改
  public int Update(Student s)
  {
    var list = db.students.Find(s.Id);
    list.Name = s.Name;
    list.Sex = s.Sex;
    list.Age = s.Age;
    return db.SaveChanges();
  }
 }
}

原文地址:https://www.cnblogs.com/XiaoyvYa/p/13271670.html