public void CollectionCustomLoadFromViewNoParams()
{
viewColl = new FullNameViewCollection();
if (viewColl.es.Connection.Name == "SqlCe"
|| aggTestColl.es.Connection.ProviderMetadataKey ==
"esSqlCe4"
|| aggTestColl.es.Connection.ProviderMetadataKey ==
"esSqlCe")
{
Assert.Ignore("Not tested for SqlCe.");
}
else
{
string whereClause = "";
switch (viewColl.es.Connection.ProviderSignature.DataProviderName)
{
case "EntitySpaces.NpgsqlProvider":
case "EntitySpaces.Npgsql2Provider":
case "EntitySpaces.OracleClientProvider":
whereClause = "WHERE \"DepartmentID\" = 1 ";
whereClause += "OR \"DepartmentID\" = 2 ";
break;
case "EntitySpaces.MySqlClientProvider":
whereClause = "WHERE `DepartmentID` = 1 ";
whereClause += "OR `DepartmentID` = 2";
break;
default:
whereClause = "WHERE [DepartmentID] = 1 ";
whereClause += "OR [DepartmentID] = 2";
break;
}
viewColl.CustomLoadFromViewNoParams(whereClause);
Assert.AreEqual(6, viewColl.Count);
}
}