EF 的一些方法

输出sql语句

using (textEntities entities = new textEntities())
{
    entities.Database.Log += c => Console.WriteLine($"SQL: {c}");
}

添加删除

User userNew = new User()
{
    Account = "Admin",
    Email = "1234567@qq.com",
    Password = "12356789"
};
context.Users.Add(userNew);//添加
context.SaveChanges();//自增主键在插入成功后，会自动赋值过去
context.Users.Remove(userNew);//删除
context.SaveChanges();//每次.SaveChanges()都是一个事务

context.Entry<User>(userNew).Property<string>("Name").IsModified = true;
//告诉context说 name属性更改了
context.SaveChanges();

使用SQL语句查询

using (textEntities dbContext = new JDDbContext())
{
    {
        DbContextTransaction trans = null;
        try
        {
            trans = dbContext.Database.BeginTransaction();
            string sql = "Update [User] Set Name='小新' WHERE Id=@Id";
            SqlParameter parameter = new SqlParameter("@Id", 1);
            dbContext.Database.ExecuteSqlCommand(sql, parameter);
            trans.Commit();
        }
        catch (Exception ex)
        {
            if (trans != null)
                trans.Rollback();
            throw ex;
        }
        finally
        {
            trans.Dispose();
        }
    }
    {
        DbContextTransaction trans = null;
        try
        {
            trans = dbContext.Database.BeginTransaction();
            string sql = "SELECT * FROM [User] WHERE Id=@Id";
            SqlParameter parameter = new SqlParameter("@Id", 1);
            List<User> userList = dbContext.Database.SqlQuery<User>(sql, parameter).ToList<User>();
            trans.Commit();
        }
        catch (Exception ex)
        {
            if (trans != null)
                trans.Rollback();
            throw ex;
        }
        finally
        {
            trans.Dispose();
        }
    }
}

监控对象/追踪数据

User userNew = new User()
{
    Account = "Admin",
    Email = "1234567@qq.com",
    Password = "12356789"
};
using (textEntities context= new textEntities())
{
    context.Users.Attach(userNew);//直接保存无效 Attach一下,附加之后就可以监控
    userNew = context.Users.Find(userNew.Id);//通过主键查询
}

导航属性

//.Include() 类似join
var companyList = context.Set<Company>().Include("Users").Where(c => c.Id > 0);
foreach (var company in companyList)
{
    Console.WriteLine("Company id={0} name={1}", company.Id, company.Name);
    foreach (var item in company.Users)
    {
        Console.WriteLine("User name={0}", item.Name);
    }
}