1 List<User> userList=new List<User>();
2 
3 for(int i=0;i<100000;i++)
4 {
5   userList.Add(new User{Name="zzl"+i});
6 }
7 _db.InsertAllOnSubmit(userList);
8 
9 _db.SubmitChanges();

1  public virtual void Insert<TEntity>(TEntity entity) where TEntity : class
2         {
3             DB.GetTable<TEntity>().InsertOnSubmit(entity);
4             this.SubmitChanges();
5         }

 public virtual void Insert<TEntity>(IEnumerable<TEntity> list) where TEntity : class
        {
            DB.GetTable<TEntity>().InsertAllOnSubmit(list);
            this.SubmitChanges();
        }

1         /// <summary>
2         /// ＡＤＯ優化的批量添加
3         /// </summary>
4         /// <typeparam name="TEntity">&lt;/typeparam>
5         /// <param name="list"></param>
6         public virtual void Insert<TEntity>(IEnumerable<TEntity> list) where TEntity : class
7         {
8             this.InsertForADO<TEntity>(list);
9         }

 1 #region LINQ調用T-SQL實現批量添加
 2         /// <summary>
 3         /// 得到數據庫表或視圖的抽象
 4         /// </summary>
 5         /// <param name="rowType"></param>
 6         /// <returns></returns>
 7         MetaTable GetMetaTable(Type rowType)
 8         {
 9             return DB.Mapping.GetTable(rowType);
10         }
11 
12         /// <summary>
13         /// 建(jian)立(li)ＳＱＬ語句
14         /// </summary>
15         /// <param name="entity"></param>
16         /// <returns></returns>
17         Tuple<string, object[]> CreateInsertArguments<TEntity>(TEntity entity)
18         {
19             if (entity == null)
20                 throw new ArgumentException("The database entity can not be null.");
21 
22             Type entityType = entity.GetType();
23             MetaTable table = GetMetaTable(entityType);
24             MetaDataMember identityDatamember = table.RowType.DBGeneratedIdentityMember;
25 
26             List<object> arguments = new List<object>();
27             StringBuilder fieldbuilder = new StringBuilder();
28             StringBuilder valuebuilder = new StringBuilder();
29 
30             fieldbuilder.Append("INSERT INTO " + table.TableName + " (");
31 
32             foreach (var member in table.RowType.PersistentDataMembers)
33             {
34 
35                 if (!member.IsAssociation && !member.IsDbGenerated)
36                 {
37                     object value = entityType.GetProperty(member.Name).GetValue(entity, null);
38                     if (value != null)
39                     {
40                         if (arguments.Count != 0)
41                         {
42                             fieldbuilder.Append(", ");
43                             valuebuilder.Append(", ");
44                         }
45 
46                         fieldbuilder.Append(member.MappedName);
47                         if (member.Type == typeof(string) || member.Type == typeof(DateTime))
48                             valuebuilder.Append("'{" + arguments.Count + "}'");
49                         else
50                             valuebuilder.Append("{" + arguments.Count + "}");
51                         if (value.GetType() == typeof(string))
52                             value = value.ToString().Replace("'", "char(39)");
53                         arguments.Add(value);
54 
55                     }
56                 }
57             }
58 
59 
60             fieldbuilder.Append(") Values (");
61 
62             fieldbuilder.Append(valuebuilder.ToString());
63             fieldbuilder.Append(");");
64             return new Tuple<string, object[]>(fieldbuilder.ToString(), arguments.ToArray());
65         }
66 
67         void InsertForADO<TEntity>(IEnumerable<TEntity> list)
68         {
69             StringBuilder sqlstr = new StringBuilder();
70             list.ToList().ForEach(i =>
71             {
72                 Tuple<string, object[]> insert = CreateInsertArguments(i);
73                 sqlstr.AppendFormat(insert.Item1, insert.Item2);
74             });
75             DB.ExecuteCommand(sqlstr.ToString());
76         }
77 
78         #endregion