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