public void CreateDataTable_SchemaHelper_Tables()
{
#region query
string query = @"
SELECT
Project1.C1,
Project1.CatalogName,
Project1.SchemaName,
Project1.Name
FROM ( SELECT
Extent1.CatalogName,
Extent1.SchemaName,
Extent1.Name,
1 C1
FROM (
{{{|VFP:EF:SCHEMAHELPER_TABLES|}}}
) Extent1
) Project1
ORDER BY Project1.Name, Project1.SchemaName";
#endregion
DataTable expected = EntityDataModelWizardExpected.GetTables();
DataTable actual = null;
SchemaManager.Using(this.GetConnection().ConnectionString, (manager) => actual = manager.CreateDataTable(query));
//DataTableHelper.WriteDataTableCode("Tables", actual);
DataTableHelper.AssertDataTablesAreEqual(expected, actual);
}
public void CreateDataTable_SchemaHelper_Procedures()
{
#region query
string query = @"
SELECT
Project3.C4 C1,
Project3.C1 C2,
Project3.C2 C3,
Project3.C3 C4
FROM ( SELECT
UnionAll1.CatalogName C1,
UnionAll1.SchemaName C2,
UnionAll1.Name C3,
1 C4
FROM (SELECT
Extent1.CatalogName,
Extent1.SchemaName,
Extent1.Name
FROM (
{{{|VFP:EF:SCHEMAHELPER_FUNCTIONS|}}}
) Extent1
UNION ALL
SELECT
Extent2.CatalogName,
Extent2.SchemaName,
Extent2.Name
FROM (
{{{|VFP:EF:SCHEMAHELPER_PROCEDURES|}}}
) Extent2) UnionAll1
) Project3
ORDER BY Project3.C3, Project3.C2";
#endregion
DataTable expected = EntityDataModelWizardExpected.GetProcedures();
DataTable actual = null;
SchemaManager.Using(this.GetConnection().ConnectionString, (manager) => actual = manager.CreateDataTable(query));
//DataTableHelper.WriteDataTableCode("Procedures", actual);
DataTableHelper.AssertDataTablesAreEqual(expected, actual);
}