Linq的增删改查

 /// <summary>
/// Select--查询
/// </summary>
/// <returns></returns>
public IQueryable Linqmy()
{
var my = from s in db.account select s;
return my;
}

/// <summary>
/// Insert--添加
/// </summary>
/// <param name="name"></param>
/// <param name="pwd"></param>
/// <returns></returns>
public bool LinqInsertmy(string name,string pwd)
{
account account = new account();
account.name = name;
account.pwd = pwd;
db.account.InsertOnSubmit(account);//关键字--InsertOnSubmit
db.SubmitChanges();
return true;
}

/// <summary>
/// Delete--删除
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool LinqDelete(int id)
{
account account = db.account.Single(a => a.id == id);
db.account.DeleteOnSubmit(account);//关键字DeleteOnSubmit
db.SubmitChanges();
return true;
}

/// <summary>
/// Update--更新
/// </summary>
/// <param name="id"></param>
/// <param name="name"></param>
/// <param name="pwd"></param>
/// <returns></returns>
public bool LinqUpdate(int id, string name, string pwd)
{
account account = db.account.Single(a => a.id == id);
account.name = name;
account.pwd = pwd;
db.SubmitChanges();
return true;
}