protected override void NativeQueryTest(int count) { using (var transaction = new TransactionScope()) { var command = DataConnectionExtensions.SetCommand(_db, @"SELECT * FROM Simplests WHERE Id = @id", new DataParameter("@id", DbType.Int32)); _db.Command.Prepare(); for (var i = 0; i < count; i++) { command.Parameters[0].Value = i % InstanceCount; var result = command.Execute <Simplests>(); } transaction.Complete(); } }
/// <summary> /// Asynchronously performs bulk insert operation. /// </summary> /// <typeparam name="T"></typeparam> /// <param name="source"></param> /// <returns></returns> public async ValueTask <long> InsertAsync <T>(IEnumerable <T> source) where T : class => (await DataConnectionExtensions.BulkCopyAsync(this, source)).RowsCopied;
//public abstract IEntity Entity { get; } //Business.Data.IEntity IEntitys.Entity { get => Entity; } //public new void BeginTransaction() => base.BeginTransaction(); //public new void BeginTransaction(System.Data.IsolationLevel isolationLevel) => base.BeginTransaction(isolationLevel); //public void Commit() => base.CommitTransaction(); //public void Rollback() => base.RollbackTransaction(); /// <summary> /// Performs bulk insert operation. /// </summary> /// <typeparam name="T"></typeparam> /// <param name="source"></param> /// <returns></returns> public long Insert <T>(IEnumerable <T> source) where T : class => DataConnectionExtensions.BulkCopy(this, source).RowsCopied;
public BulkCopyRowsCopied BulkCopy <T>(IEnumerable <T> list) where T : class { return(DataConnectionExtensions.BulkCopy(this, list)); }