public void TestSqlConnectionForQueryAllForSystemSqlServerTypeMapAttribute()
{
// Setup
var tables = CreateSdsAttributeTables(10).AsList();
using (var connection = new System.Data.SqlClient.SqlConnection(Database.ConnectionString))
{
// Act
connection.InsertAll <SdsAttributeTable>(tables);
// Query
var queryResult = connection.QueryAll <SdsAttributeTable>();
// Assert
Assert.AreEqual(tables.Count, queryResult.Count());
}
}
public void TestSqlConnectionForInsertAllForSystemSqlServerTypeMapAttribute()
{
// Setup
var tables = CreateSdsAttributeTables(10).AsList();
using (var connection = new System.Data.SqlClient.SqlConnection(Database.ConnectionString))
{
// Act
connection.InsertAll <SdsAttributeTable>(tables);
// Assert
Assert.AreEqual(tables.Count, connection.CountAll <SdsAttributeTable>());
// Query
var queryResult = connection.QueryAll <SdsAttributeTable>();
// Assert
tables.ForEach(table => Helper.AssertPropertiesEquality(table, queryResult.First(e => e.Id == table.Id)));
}
}
