public static void BulkCopyTest() { List <TestEntity> models = new List <TestEntity>(); models.Add(new TestEntity() { Id = 14, F_Byte = 1, F_Int16 = 1, F_Int32 = 1, F_Int64 = 1, F_Double = 1, F_Float = 1, F_Decimal = 1, F_Bool = true, F_DateTime = DateTime.Now, F_String = "lu" }); models.Add(new TestEntity() { Id = 15, F_Byte = 1, F_Int16 = 1, F_Int32 = 1, F_Int64 = 1, F_Double = 1, F_Float = 1, F_Decimal = 1, F_Bool = true, F_DateTime = DateTime.Now, F_Guid = Guid.NewGuid(), F_String = "so" }); object result = null; //SqlConnection conn = new SqlConnection(DbHelper.ConnectionString); //conn.BulkCopy1<TestEntity>(models, int.MaxValue, null, null, null); context.BeginTransaction(); result = context.Query <User>().Select(a => new UserLite() { Id = a.Id, Name = a.Name }).ToList(); context.BulkInsert(models, null, null, false); result = context.Query <User>().Select(a => new UserLite() { Id = a.Id, Name = a.Name }).ToList(); context.CommitTransaction(); Console.WriteLine(1); Console.ReadKey(); }