protected override void NativeQueryTest(int count)
{
using (var transaction = con.BeginTransaction())
{
var cmd = con.CreateCommand();
cmd.Transaction = transaction;
cmd.CommandText = "SELECT [Simplests].[Id], [Simplests].[Value] " +
"FROM [dbo].[Simplests] WHERE [Simplests].[id] = @pId";
cmd.Parameters.Add(new SqlParameter("@pId", SqlDbType.BigInt));
SqlDataReader dr;
for (int i = 0; i < count; i++)
{
cmd.Parameters["@pId"].SqlValue = i % InstanceCount;
dr = cmd.ExecuteReader();
var s = new Simplest();
while (dr.Read())
{
if (!dr.IsDBNull(0))
{
s.Id = dr.GetInt64(0);
}
if (!dr.IsDBNull(1))
{
s.Value = dr.GetInt64(1);
}
}
dr.Close();
}
transaction.Commit();
}
}
protected override void InsertMultipleTest(int count)
{
Simplest min = null;
Simplest max = null;
using (var transaction = db.BeginTransaction())
{
for (int i = 0; i < count - 1; i++)
{
var simplest = new Simplest {
Value = i
};
db.Add(simplest);
if (min == null)
{
min = simplest;
}
}
max = new Simplest {
Value = count - 1
};
db.Add(max);
db.SaveChanges();
transaction.Commit();
}
InstanceCount = count;
minId = min.Id;
maxId = max.Id;
}
protected override void InsertSingleTest(int count)
{
for (int i = 0; i < count; i++)
{
var simplest = new Simplest {
Id = i, Value = i
};
repo.Add(simplest);
}
InstanceCount = count;
}
protected override void InsertSingleTest(int count)
{
for (int i = 0; i < count; i++)
{
var s = new Simplest {
Id = i, Value = i
};
context.Add(s);
context.SaveChanges();
}
InstanceCount = count;
}
protected override void InsertMultipleTest(int count)
{
using (var transaction = _context.Database.BeginTransaction())
{
for (var i = 0; i < count; i++)
{
var s = new Simplest {Id = i, Value = i};
_context.Simplests.Add(s);
}
_context.SaveChanges();
transaction.Commit();
}
InstanceCount = count;
}
protected override void InsertMultipleTest(int count)
{
using (var statelessSession = _factory.OpenStatelessSession())
using (var transaction = statelessSession.BeginTransaction())
{
for (int i = 0; i < count; i++)
{
var s = new Simplest(i, i);
statelessSession.Insert(s);
}
transaction.Commit();
}
InstanceCount = count;
}
protected override void InsertMultipleTest(int count)
{
using (var ts = new TransactionScope()) {
for (int i = 0; i < count; i++)
{
var s = new Simplest {
Id = i, Value = i
};
context.Add(s);
}
context.SaveChanges();
ts.Complete();
}
InstanceCount = count;
}
protected override void InsertMultipleTest(int count)
{
using (var transaction = context.Database.BeginTransaction())
{
for (var i = 0; i < count; i++)
{
var s = new Simplest {
Id = i, Value = i
};
context.Simplests.Add(s);
}
context.SaveChanges();
transaction.Commit();
}
InstanceCount = count;
}
protected override void InsertSingleTest(int count)
{
using (var insertSession = _factory.OpenSession())
using (var transaction = insertSession.BeginTransaction())
{
for (int i = 0; i < count; i++)
{
var s = new Simplest(i, i);
insertSession.Save(s);
insertSession.Flush();
insertSession.Clear();
}
transaction.Commit();
}
InstanceCount = count;
}
protected override void InsertMultipleTest(int count)
{
using (_db.Transaction = _db.Connection.BeginTransaction())
{
for (var i = 0; i < count; i++)
{
var s = new Simplest {
Id = i, Value = i
};
_db.Simplests.InsertOnSubmit(s);
}
_db.SubmitChanges();
_db.Transaction.Commit();
}
InstanceCount = count;
}
private void FetchTest(int count)
{
long sum = (long)count * (count - 1) / 2;
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
SqlCommand cmd = connection.CreateCommand();
cmd.Transaction = transaction;
cmd.Parameters.AddWithValue("@pId", 0);
cmd.CommandText = "SELECT [Simplest].[Id], [Simplest].[Value] " +
"FROM [dbo].[Simplest] WHERE [Simplest].[Id] = @pId";
SqlDataReader dr;
TestHelper.CollectGarbage();
using (warmup ? null : new Measurement("Fetch & GetField", count)) {
for (int i = 0; i < count; i++)
{
cmd.Parameters["@pId"].SqlValue = i % instanceCount;
dr = cmd.ExecuteReader();
var s = new Simplest();
while (dr.Read())
{
if (!dr.IsDBNull(0))
{
s.Id = (long)dr.GetValue(0);
}
if (!dr.IsDBNull(1))
{
s.Value = (long)dr.GetValue(1);
}
}
sum -= s.Id;
dr.Close();
}
transaction.Commit();
}
if (count <= instanceCount)
{
Assert.AreEqual(0, sum);
}
connection.Close();
}
protected override void InsertMultipleTest(int count)
{
Simplest min = null;
Simplest max = null;
using (var transaction = db.BeginTransaction()) {
for (int i = 0; i < count - 1; i++) {
var simplest = new Simplest {Value = i};
db.Add(simplest);
if (min == null)
min = simplest;
}
max = new Simplest {Value = count - 1};
db.Add(max);
db.SaveChanges();
transaction.Commit();
}
InstanceCount = count;
minId = min.Id;
maxId = max.Id;
}
private void MaterializeTest(int count)
{
long sum = 0;
int i = 0;
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
TestHelper.CollectGarbage();
using (warmup ? null : new Measurement("Materialize & GetField", count)) {
while (i < count)
{
SqlCommand cmd = connection.CreateCommand();
cmd.Transaction = transaction;
cmd.CommandText = "SELECT [Simplest].[Id], [Simplest].[Value] " +
"FROM [dbo].[Simplest]";
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
var s = new Simplest();
if (!dr.IsDBNull(0))
{
s.Id = (long)dr.GetValue(0);
}
if (!dr.IsDBNull(1))
{
s.Value = (long)dr.GetValue(1);
}
sum += s.Id;
if (++i >= count)
{
break;
}
}
dr.Close();
}
transaction.Commit();
}
Assert.AreEqual((long)count * (count - 1) / 2, sum);
connection.Close();
}
protected override void FetchTest(int count)
{
long sum = (long)count * (count - 1) / 2;
using (var transaction = con.BeginTransaction())
{
var cmd = con.CreateCommand();
cmd.Transaction = transaction;
cmd.CommandText = "SELECT [Simplests].[Id], [Simplests].[Value] " +
"FROM [dbo].[Simplests] WHERE [Simplests].[Id] = @pId";
cmd.Parameters.Add(new SqlParameter("@pId", SqlDbType.BigInt));
cmd.Prepare();
SqlDataReader dr;
for (int i = 0; i < count; i++)
{
cmd.Parameters["@pId"].SqlValue = i % InstanceCount;
dr = cmd.ExecuteReader();
var s = new Simplest();
while (dr.Read())
{
if (!dr.IsDBNull(0))
{
s.Id = dr.GetInt64(0);
}
if (!dr.IsDBNull(1))
{
s.Value = dr.GetInt64(1);
}
}
sum -= s.Id;
dr.Close();
}
transaction.Commit();
}
if (count <= InstanceCount)
{
Assert.AreEqual(0, sum);
}
}
private void InsertTest(int insertCount)
{
var d = Domain;
using (var ss = d.OpenSession()) {
var s = ss.Session;
long sum = 0;
TestHelper.CollectGarbage();
using (warmup ? null : new Measurement("Insert", insertCount)) {
using (var ts = s.OpenTransaction()) {
for (int i = 0; i < insertCount; i++)
{
var o = new Simplest(i, i);
sum += i;
}
ts.Complete();
}
}
}
instanceCount = insertCount;
}
protected override void NativeMaterializeTest(int count)
{
long sum = 0;
int i = 0;
using (var transaction = con.BeginTransaction())
{
while (i < count)
{
SqlCommand cmd = con.CreateCommand();
cmd.Transaction = transaction;
cmd.CommandText = "SELECT [Simplests].[Id], [Simplests].[Value] " +
"FROM [dbo].[Simplests]";
cmd.Prepare();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
var s = new Simplest();
if (!dr.IsDBNull(0))
{
s.Id = dr.GetInt64(0);
}
if (!dr.IsDBNull(1))
{
s.Value = dr.GetInt64(1);
}
sum += s.Id;
if (++i >= count)
{
break;
}
}
dr.Close();
}
transaction.Commit();
}
Assert.AreEqual((long)count * (count - 1) / 2, sum);
}
