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 Outputs_This() { ISQLCEDatabaseConnector connector = MockRepository.GenerateStub <ISQLCEDatabaseConnector>(); connector.Filename = "database.sdf"; string output = new DatabaseSerialisationScheme().SerialiseConnectionInformation(connector); Assert.That(output.RemoveWhitespaceBetweenXmlElements(), Is.EqualTo(ExpectedXml)); }
public void Serialise(ISQLCEDatabaseConnector connector, XmlWriter writer) { if (connector == null) { return; } if (writer == null) { return; } if (string.IsNullOrEmpty(connector.Filename) == false) { writer.WriteStartElement("ConnectionInformation"); writer.WriteAttributeString("DatabaseConnector", "SqlCE"); writer.WriteElementString("FileName", connector.Filename); writer.WriteEndElement(); } }
public SQLCEDatabaseLoader(ISQLCEDatabaseConnector connector) { this.connector = connector; }
public SQLServerCEDatabaseFormFiller(ISQLCEDatabaseConnector connector) { this.connector = connector; }
public void Serialise(ISQLCEDatabaseConnector connector, XmlWriter writer) { if (connector == null) return; if (writer == null) return; if (string.IsNullOrEmpty(connector.Filename) == false) { writer.WriteStartElement("ConnectionInformation"); writer.WriteAttributeString("DatabaseConnector", "SqlCE"); writer.WriteElementString("FileName", connector.Filename); writer.WriteEndElement(); } }