EF方式增加数据

         单条记录添加

• 第一种方式：

          public void AddRegion()
          {
              using(Northwind db = new Northwind())
              {
                  Region region = new Region();
                  region.RegionID = 5;
                  region.RegionDescription = "青岛";
                  db.Region.Add(region);
                  db.SaveChanges();
              }
          }

• 第二种方式：

          public void AddRegion()
          {
              using (Northwind db = new Northwind())
              {
                  Region region = new Region();
                  region.RegionID = 6;
                  region.RegionDescription = "济南";
                  db.Entry<Region>(region).State = System.Data.Entity.EntityState.Added;
                  db.SaveChanges();
              }
          }

  批量增加

• 第一种方式 ：使用泛型

          public void AddRange()
          {
              using (Northwind db = new Northwind())
              {
                  List<Region> regions = new List<Region>();
                  regions.Add(new Region { RegionID = 6, RegionDescription = "济南" });
                  regions.Add(new Region { RegionID = 7, RegionDescription = "合肥" });
                  regions.Add(new Region { RegionID = 8, RegionDescription = "天津" });
                  db.Region.AddRange(regions);
                  Response.Write(db.SaveChanges());
              }
          }

• 第二种方式：循环实体

          public void AddRange()
          {
              using(Northwind db = new Northwind())
              {
                  for (int i = 10; i < 20; i++)
                  {
                      Region region = new Region();
                      region.RegionID = i;
                      region.RegionDescription = $"第{i}条";
                      db.Region.Add(region);
                  }
                  Response.Write(db.SaveChanges());
              }
          }