static void Main(string[] args)
{
using (Homework10Context homework10Context = new Homework10Context())
{
homework10Context.Database.Log = c => Console.WriteLine(c);
#region 批量操作演示
EFHelper efHelper = new EFHelper(homework10Context);
efHelper.Update <Company>(new Company {
Name = "yy", CreateTime = DateTime.Now, CreatorId = 1
}, c => c.Id == 1);
efHelper.Delete <Company>(c => c.Id > 50 && c.Name.StartsWith("测试"));
#endregion
var companySet = homework10Context.Company;
#region 增 在Comanpy对象中演示
{
var company1 = new Company()
{
Name = "测试增加",
CreateTime = DateTime.Now,
CreatorId = 1
};
companySet.Add(company1);
homework10Context.SaveChanges();
var company2 = new Company()
{
Name = "测试增加22",
CreateTime = DateTime.Now,
CreatorId = 2
};
}
#endregion
#region 改 在Comanpy对象中演示
{
#region 修改方法1
{
var company1 = companySet.Find(2);
if (company1 != null)
{
company1.Name = "演示修改方法1";
}
homework10Context.SaveChanges();
}
#endregion
#region 修改方法2
{
var company1 = new Company()
{
Name = "演示修改方法2",
CreateTime = DateTime.Now,
CreatorId = 1,
Id = 3
};
homework10Context.Set <Company>().Attach(company1);
homework10Context.Entry(company1).State = EntityState.Modified;
homework10Context.SaveChanges();
}
#endregion
#region 修改方法3
{
var company1 = companySet.Where(c => c.Id == 2001).FirstOrDefault();
if (company1 != null)
{
company1.Name = "测试修改2023";
// homework10Context.Set<Company>().Attach(company1); 对DbSet内部数据集修改无需Attach方法
homework10Context.SaveChanges();
}
}
#endregion
}
#endregion
#region 在Comanpy对象中演示
{
#region 除方法1
{
var company1 = companySet.Find(4);
if (company1 != null)
{
companySet.Remove(company1);
homework10Context.SaveChanges();
}
}
#endregion
#region 除方法2
{
var company1 = companySet.Where(c => c.Id == 5).FirstOrDefault();
if (company1 != null)
{
homework10Context.Entry(company1).State = EntityState.Deleted;
homework10Context.SaveChanges();
}
}
#endregion
#region 除方法3
{
var company1 = companySet.Where(c => c.Id == 6).FirstOrDefault();
if (company1 != null)
{
homework10Context.Set <Company>().Attach(company1);
homework10Context.Set <Company>().Remove(company1);
}
homework10Context.SaveChanges();
}
#endregion
}
#endregion
#region 查 在Comanpy对象中演示
// var companys = companySet.Where(c => c.Id > 1000);
Show(companySet);
#endregion
}
Console.ReadLine();
}
public UnitTest1()
{
var _DbContext = new Homework10Context();
_EFHelper = new EFHelper(_DbContext);
}
