public void TestExportData()
{
var t = new Table("dbo", "Status");
t.Columns.Add(new Column("id", "int", false, null));
t.Columns.Add(new Column("code", "char", 1, false, null));
t.Columns.Add(new Column("description", "varchar", 20, false, null));
t.Columns.Find("id").Identity = new Identity(1, 1);
t.Constraints.Add(new Constraint("PK_Status", "PRIMARY KEY", "id"));
string conn = TestHelper.GetConnString("TESTDB");
DBHelper.DropDb(conn);
DBHelper.CreateDb(conn);
SqlConnection.ClearAllPools();
DBHelper.ExecBatchSql(conn, t.ScriptCreate());
string dataIn =
@"1 R Ready
2 P Processing
3 F Frozen
";
t.ImportData(conn, dataIn);
string dataOut = t.ExportData(conn);
Assert.AreEqual(dataIn, dataOut);
}
