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