public void Getforeignkeyconnections_should_return_table_tablesconnections_as_jason()
{
var foreignKeyColumn = new ForeignKeyColumn {Name = "foreignKeyColumn"};
var primaryKeyColumn = new PrimaryKeyColumn { Name = "primaryKeyColumn" };
var foreignKeys = new List<ForeignKey>
{
new ForeignKey
{
ForeignKeyTableName = "ForeignKeyTableName",
PrimaryKeyTableName = "PrimaryKeyTableName",
ForeignKeyColumns = new List<ForeignKeyColumn> { foreignKeyColumn },
PrimaryKeysColumns = new List<PrimaryKeyColumn>{ primaryKeyColumn}
}
};
_schemaReader.Expect(sr => sr.GetForeignKeys(Connectionstring)).Return(foreignKeys);
_connectionstringArgumentsMapperFactory = new ConnectionstringArgumentsMapperFactory();
_databaseExplorerController = new DatabaseExplorerController(_schemaReader, _connectionstringBuilder, _connectionstringArgumentsMapperFactory);
_databaseExplorerController.ControllerContext = new ControllerContext(_context, new RouteData(), _databaseExplorerController);
var result = _databaseExplorerController.GetForeignKeyConnections() as JsonResult;
Assert.IsNotNull(result);
var serializer = new JavaScriptSerializer();
var output = serializer.Serialize(result.Data);
Console.WriteLine(output);
Assert.AreEqual("[{\"Name\":null,\"OriginalName\":null,\"ForeignKeyTableName\":\"ForeignKeyTableName\",\"ForeignKeyTableSchema\":null,\"ForeignKeyColumns\":[{\"Name\":\"foreignKeyColumn\"}],\"PrimaryKeyTableName\":\"PrimaryKeyTableName\",\"PrimaryKeyTableSchema\":null,\"PrimaryKeysColumns\":[{\"Name\":\"primaryKeyColumn\"}]}]", output);
}
public ForeignKey MapToForeignKey(DataRow row, DataTable schema)
{
var dbForeignKey = new ForeignKey
{
Name = row["FK_NAME"].ToString(),
OriginalName = row["FK_NAME"].ToString(),
ForeignKeyTableName = row["FK_TABLE_NAME"].ToString(),
PrimaryKeyTableName = row["PK_TABLE_NAME"].ToString(),
ForeignKeyTableSchema = schema.ToString()
};
var fkc = new ForeignKeyColumn { Name = row["FK_COLUMN_NAME"].ToString() };
dbForeignKey.ForeignKeyColumns.Add(fkc);
var pkc = new PrimaryKeyColumn { Name = row["PK_COLUMN_NAME"].ToString() };
dbForeignKey.PrimaryKeysColumns.Add(pkc);
return dbForeignKey;
}
