public void Does_Not_Support_Check_Indexes()
{
// Create mock index data
DataTable dt = new DataTable();
/*IND.TABLE_NAME, IND.INDEX_NAME, IND.COLUMN_NAME, IND.PRIMARY_KEY AS IsPrimaryKey, IND.[UNIQUE] AS IsUnique,
IND.[CLUSTERED] AS IsClustered, TC.CONSTRAINT_TYPE, TC.CONSTRAINT_NAME*/
dt.Columns.Add("TABLE_NAME");
dt.Columns.Add("INDEX_NAME");
dt.Columns.Add("COLUMN_NAME");
dt.Columns.Add("IsPrimaryKey");
dt.Columns.Add("IsUnique");
dt.Columns.Add("IsClustered");
dt.Columns.Add("CONSTRAINT_TYPE");
dt.Columns.Add("CONSTRAINT_NAME");
dt.Rows.Add("Table1", "PK_Table1", "Column1", true, true, false, "CHECK", "PK_Table1");
ISQLCEDatabaseConnector connector = MockRepository.GenerateStub<ISQLCEDatabaseConnector>();
connector.Stub(t => t.Indexes).Return(dt);
SQLCEDatabaseLoader loader = new SQLCEDatabaseLoader(connector);
loader.GetTableConstraintIndexes(new Table("Table1"));
}
public void Fails_To_Load_From_Invalid_Connector()
{
var loader = new SQLCEDatabaseLoader(new SQLCEDatabaseConnector("doesnotexist.sdf"));
loader.LoadDatabase();
}
private static void LoadDatabase(string file)
{
Database db = new SQLCEDatabaseLoader(new SQLCEDatabaseConnector(file)).LoadDatabase();
new DatabaseProcessor().CreateRelationships(db);
}
