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