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(); }
public static void DoWithTransaction() { using (ITransientTransaction tran = context.BeginTransaction()) { /* do some things here */ context.Update <User>(a => a.Id == 1, a => new User() { Name = a.Name, Age = a.Age + 1, Gender = Gender.Man, OpTime = DateTime.Now }); context.Delete <User>(a => a.Id == 1024); tran.Commit(); } ConsoleHelper.WriteLineAndReadKey(); }