public void TestSqlServerConnectionAverageAllAsync()
{
// Setup
var tables = Database.CreateCompleteTables(10);
using (var connection = new SqlConnection(Database.ConnectionString))
{
// Act
var result = connection.AverageAllAsync <CompleteTable>(e => e.ColumnInt).Result;
// Assert
Assert.AreEqual(tables.Average(e => e.ColumnInt), Convert.ToDouble(result));
}
}
public void TestSqlServerConnectionAverageAllAsyncViaTableName()
{
// Setup
var tables = Database.CreateCompleteTables(10);
using (var connection = new SqlConnection(Database.ConnectionString))
{
// Act
var result = connection.AverageAllAsync(ClassMappedNameCache.Get <CompleteTable>(),
Field.Parse <CompleteTable>(e => e.ColumnInt).First()).Result;
// Assert
Assert.AreEqual(tables.Average(e => e.ColumnInt), Convert.ToDouble(result));
}
}
public void TestSqlConnectionAverageAllAsyncTypedResult()
{
// Setup
var tables = Helper.CreateIdentityTables(10);
using (var connection = new SqlConnection(Database.ConnectionStringForRepoDb))
{
// Act
connection.InsertAll(tables);
// Act
var result = connection.AverageAllAsync <IdentityTable, double?>(e => e.ColumnInt).Result;
// Assert
Assert.AreEqual(tables.Average(t => t.ColumnInt), result);
}
}
public void TestSqlConnectionAverageAllTypedResultTableNameAsync()
{
// Setup
var tables = Helper.CreateIdentityTables(10);
using (var connection = new SqlConnection(Database.ConnectionStringForRepoDb))
{
// Act
connection.InsertAll(tables);
// Act
var result = connection.AverageAllAsync <double?>(ClassMappedNameCache.Get <IdentityTable>(),
new Field("ColumnInt")).Result;
// Assert
Assert.AreEqual(tables.Average(t => t.ColumnInt), result);
}
}
public void TestSqlConnectionAverageAllAsyncWithHints()
{
// Setup
var tables = Helper.CreateIdentityTables(10);
using (var connection = new SqlConnection(Database.ConnectionStringForRepoDb))
{
// Act
connection.InsertAll(tables);
// Act
var result = connection.AverageAllAsync <IdentityTable>(e => e.ColumnInt,
hints: SqlServerTableHints.NoLock).Result;
// Assert
Assert.AreEqual(tables.Average(t => t.ColumnInt), Convert.ToDouble(result));
}
}
