MyContext ctx = new MyContext();
ctx.Database.Log = (sql) =>
{
Console.WriteLine("=============Log============" + sql);
};
//Person p = ctx.Persons.First();
//p.Name = "hello word";
//ctx.SaveChanges();
Person p = new Person();
//p.Name = "Jack";
//p.CreateDateTime = DateTime.Now;
//ctx.Persons.Add(p);添加记录
//ctx.SaveChanges();添加记录
//string[] name = { "wade", "john", "lily", "raywen", "marshall", "ted", "barney" };
//for (int i = 0; i < name.Length; i++)
//{
// p.Name = name[i];
// p.CreateDateTime = DateTime.Now;
// ctx.Persons.Add(p);
// ctx.SaveChanges();
//}
//查询操作
p = ctx.Persons.First();
Console.WriteLine(p.Id.ToString() + "---------" + p.Name.ToString() + "----------" + p.CreateDateTime);
p.Name = "Vivian";
ctx.SaveChanges();//修改操作
var query = ctx.Persons.Where(item => item.Id == 3).ToList();//一定要有这个,否则会报错 已有打开的与此 Command 相关联的 DataReader,必须首先将它关闭 或者在链接字符串中加入 MultipleActiveResultSets=true,但需要注意的是该方案只适合Sql Server 2005以及以上版本
foreach (var item in query)
{
ctx.Persons.Remove(item);//删除操作
Console.WriteLine(item.Id.ToString() + "----------" + item.Name.ToString() + "-----------" + item.CreateDateTime);
ctx.SaveChanges();
}