public void FreeTableSchemaTests_GetIndexSchemaTest()
{
using (var connection = this.fixture.CreateConnection()) {
var actual = connection.GetSchema(VfpConnection.SchemaNames.Indexes);
var expected = FreeTableSchemaExpected.GetIndexSchema();
//DataTableHelper.WriteDataTableCode("IndexSchema", 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 = this.fixture.CreateConnection()) {
var actual = connection.GetSchema(VfpConnection.SchemaNames.CandidateKeys, new[] { "sample_c1" });
var expected = FreeTableSchemaExpected.GetCandidateKeySchemaWithTableName();
//DataTableHelper.WriteDataTableCode("CandidateKeySchemaWithTableName", actual);
DataTableHelper.AssertDataTablesAreEqual(expected, actual);
}
}
public void FreeTableSchemaTests_GetCandidateKeySchemaWithTableNameAndNoTablesWithMultipleCandidateKeysTest()
{
using (var connection = GetConnection()) {
var actual = connection.GetSchema(VfpConnection.SchemaNames.CandidateKeys, new[] { "sample_c1", "true" });
var expected = FreeTableSchemaExpected.GetCandidateKeySchemaWithTableNameAndNoTablesWithMultipleCandidateKeys();
//DataTableHelper.WriteDataTableCode("CandidateKeySchemaWithTableNameAndNoTablesWithMultipleCandidateKeys", actual);
DataTableHelper.AssertDataTablesAreEqual(expected, actual);
}
}