public void ForeignKeySchemaProviderTests_GetSchemaWithTableNameNoForeignKeysTest()
{
using (var connection = GetConnection()) {
var actual = connection.GetSchema(VfpConnection.SchemaNames.ForeignKeys, new[] { "customers" });
var expected = ForeignKeySchemaProviderExpected.GetSchemaWithTableNameNoForeignKeys();
//DataTableHelper.WriteDataTableCode("SchemaWithTableNameNoForeignKeys", actual);
DataTableHelper.AssertDataTablesAreEqual(expected, actual);
}
}
public void IndexSchemaProviderTests_GetSchemaWithTableNameTest()
{
using (var connection = this.fixture.CreateConnection()) {
var actual = connection.GetSchema(VfpConnection.SchemaNames.Indexes, new[] { "categories" });
var expected = IndexSchemaProviderExpected.GetSchemaWithTableName();
//DataTableHelper.WriteDataTableCode("SchemaWithTableName", actual);
DataTableHelper.AssertDataTablesAreEqual(expected, actual);
}
}
public void SchemaManagerTests_GetDataSourceInformationSchemaTest()
{
using (var connection = GetConnection()) {
var actual = connection.GetSchema(VfpConnection.SchemaNames.DataSourceInformation);
var expected = SchemaManagerExpected.GetDataSourceInformationSchema();
//DataTableHelper.WriteDataTableCode("DataSourceInformationSchema", actual);
DataTableHelper.AssertDataTablesAreEqual(expected, actual);
}
}
public void SchemaManagerTests_GetReservedWordsSchemaTest()
{
using (var connection = GetConnection()) {
var actual = connection.GetSchema(VfpConnection.SchemaNames.ReservedWords);
var expected = SchemaManagerExpected.GetReservedWordsSchema();
//DataTableHelper.WriteDataTableCode("ReservedWordsSchema", actual);
DataTableHelper.AssertDataTablesAreEqual(expected, actual);
}
}
public void ProcedureParameterSchemaProviderTests_GetSchemaWithReferentialIntegrityTest()
{
using (var connection = this.fixture.CreateConnection()) {
var actual = connection.GetSchema(VfpConnection.SchemaNames.ProcedureParameters, new[] { null, "true" });
var expected = ProcedureParameterSchemaProviderExpected.GetSchemaWithReferentialIntegrity();
//DataTableHelper.WriteDataTableCode("SchemaWithReferentialIntegrity", actual);
DataTableHelper.AssertDataTablesAreEqual(expected, actual);
}
}
public void ProcedureParameterSchemaProviderTests_GetSchemaTest()
{
using (var connection = this.fixture.CreateConnection()) {
var actual = connection.GetSchema(VfpConnection.SchemaNames.ProcedureParameters);
var expected = ProcedureParameterSchemaProviderExpected.GetSchema();
//DataTableHelper.WriteDataTableCode("Schema", actual);
DataTableHelper.AssertDataTablesAreEqual(expected, actual);
}
}
public void ViewFieldSchemaProviderTests_GetSchemaWithFieldNameTest()
{
using (var connection = this.fixture.CreateConnection()) {
var actual = connection.GetSchema(VfpConnection.SchemaNames.ViewFields, new string[] { null, "categoryid" });
var expected = ViewFieldSchemaProviderExpected.GetSchemaWithFieldName();
//DataTableHelper.WriteDataTableCode("SchemaWithFieldName", actual);
DataTableHelper.AssertDataTablesAreEqual(expected, actual);
}
}
public void ViewFieldSchemaProviderTests_GetSchemaWithViewNameTest()
{
using (var connection = this.fixture.CreateConnection()) {
var actual = connection.GetSchema(VfpConnection.SchemaNames.ViewFields, new[] { "alphabetical_list_of_products" });
var expected = ViewFieldSchemaProviderExpected.GetSchemaWithViewName();
//DataTableHelper.WriteDataTableCode("SchemaWithViewName", actual);
DataTableHelper.AssertDataTablesAreEqual(expected, actual);
}
}
public void FreeTableSchemaTests_GetProcedureParameterSchemaTest()
{
using (var connection = GetConnection()) {
var actual = connection.GetSchema(VfpConnection.SchemaNames.ProcedureParameters);
var expected = FreeTableSchemaExpected.GetProcedureParameterSchema();
//DataTableHelper.WriteDataTableCode("ProcedureParameterSchema", actual);
DataTableHelper.AssertDataTablesAreEqual(expected, actual);
}
}
public void FreeTableSchemaTests_GetCandidateKeySchemaWithTableNameTest()
{
using (var connection = GetConnection()) {
var actual = connection.GetSchema(VfpConnection.SchemaNames.CandidateKeys, new[] { "sample_c1" });
var expected = FreeTableSchemaExpected.GetCandidateKeySchemaWithTableName();
//DataTableHelper.WriteDataTableCode("CandidateKeySchemaWithTableName", actual);
DataTableHelper.AssertDataTablesAreEqual(expected, actual);
}
}
public void ProcedureParameterSchemaProviderTests_GetSchemaWithProcedureNameTest()
{
using (var connection = GetConnection()) {
var actual = connection.GetSchema(VfpConnection.SchemaNames.ProcedureParameters, new[] { "custorderhist" });
var expected = ProcedureParameterSchemaProviderExpected.GetSchemaWithProcedureName();
//DataTableHelper.WriteDataTableCode("SchemaWithProcedureName", actual);
DataTableHelper.AssertDataTablesAreEqual(expected, actual);
}
}
public void TableFieldSchemaProviderTests_GetSchemaWithTableNameAndFieldNameTest()
{
using (var connection = GetConnection()) {
var actual = connection.GetSchema(VfpConnection.SchemaNames.TableFields, new string[] { "categories", "categoryid" });
var expected = TableFieldSchemaProviderExpected.GetSchemaWithTableNameAndFieldName();
//DataTableHelper.WriteDataTableCode("SchemaWithTableNameAndFieldName", actual);
DataTableHelper.AssertDataTablesAreEqual(expected, actual);
}
}
public void TableFieldSchemaProviderTests_GetSchemaTest()
{
using (var connection = GetConnection()) {
var actual = connection.GetSchema(VfpConnection.SchemaNames.TableFields);
var expected = TableFieldSchemaProviderExpected.GetSchema();
//DataTableHelper.WriteDataTableCode("Schema", 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);
}
