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));
}
