/// <summary>
/// Gets the database foreign keys.
/// </summary>
/// <param name="database">The database.</param>
/// <returns>the database foreign keys.</returns>
public List <DatabaseForeignKeys> GetDatabaseForeignKeys(string database)
{
this.ExecuteUseDatabase(database);
List <DatabaseForeignKeys> results = new List <DatabaseForeignKeys>();
DatabaseForeignKeys resultrow;
string sqlString = DatabaseForeignKeys.SqlStatement();
sqlString = string.Format("EXEC sp_executesql @statement = N'{0}'", sqlString.Replace("'", "''"));
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
using (SqlCommand command = new SqlCommand(sqlString, connection))
{
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
resultrow = new DatabaseForeignKeys(
reader.GetString(reader.GetOrdinal("Schema")),
reader.GetString(reader.GetOrdinal("Table")),
reader.GetString(reader.GetOrdinal("Column")),
reader.GetString(reader.GetOrdinal("ForeignKey")),
reader.GetString(reader.GetOrdinal("ReferenceTable")),
reader.GetString(reader.GetOrdinal("ReferenceColumn")));
results.Add(resultrow);
}
}
connection.Close();
}
return(results);
}
public DatabaseForeignKeys Constructor(
string schema,
string table,
string column,
string foreignKey,
string referenceTable,
string referenceColumn
)
{
DatabaseForeignKeys target = new DatabaseForeignKeys
(schema, table, column, foreignKey, referenceTable, referenceColumn);
return target;
// TODO: add assertions to method DatabaseForeignKeysTest.Constructor(String, String, String, String, String, String)
}
public string SqlStatement()
{
string result = DatabaseForeignKeys.SqlStatement();
return result;
// TODO: add assertions to method DatabaseForeignKeysTest.SqlStatement()
}
