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); }