public void Fact()
{
var connection = default (DbConnection);
var reader = default(DbDataReader);
try
{
connection = KandaXunitProviderFactory.Instance.CreateConnection();
connection.Open();
var schema = connection.GetTablesSchema();
reader = new DataTableReader(schema);
while (reader.Read())
{
var name = reader.GetString(reader.GetOrdinal(@"TABLE_NAME"));
var type = reader.GetString(reader.GetOrdinal(@"TABLE_TYPE"));
//this.transformEntity(name, type);
this.transformInsertTable(name, type);
}
}
finally
{
if (reader != null) { reader.Close(); }
if (connection != null) { connection.Close(); }
}
}
// ----------------------------------------------
// PRIVATE MEMBERS
// ----------------------------------------------
/// <summary>
/// [PRIVATE] Fill a static from table reader
/// </summary>
/// <param name="oDT"></param>
/// <returns></returns>
private Static _FillStaticFromTableReader(DataTableReader oDT)
{
Static stc = new Static();
stc.Tag = (oDT.IsDBNull(oDT.GetOrdinal("tag")) ? "" : oDT["tag"].ToString());
stc.Type = (oDT.IsDBNull(oDT.GetOrdinal("type")) ? "" : oDT["type"].ToString());
stc.Content = (oDT.IsDBNull(oDT.GetOrdinal("content")) ? "" : oDT["content"].ToString());
stc.Value = (oDT.IsDBNull(oDT.GetOrdinal("value")) ? "" : oDT["value"].ToString());
stc.Length = oDT.IsDBNull(oDT.GetOrdinal("length")) ? 0 : oDT.GetInt32(oDT.GetOrdinal("length"));
return stc;
}
public void GetOrdinalTest ()
{
DataTableReader reader = new DataTableReader (dt);
try {
Assert.AreEqual (1, reader.GetOrdinal ("name"), "#1 get ordinal should work even" +
" without calling Read");
} finally {
if (reader != null && !reader.IsClosed)
reader.Close ();
}
}
public void GetTest ()
{
dt.Columns.Add ("nullint", typeof (int));
dt.Rows [0] ["nullint"] = 333;
DataTableReader reader = new DataTableReader (dt);
try {
reader.Read ();
int ordinal = reader.GetOrdinal ("nullint");
// Get by name
Assert.AreEqual (1, (int) reader ["id"], "#1 should be able to get by name");
Assert.AreEqual (333, reader.GetInt32 (ordinal), "#2 should get int32");
Assert.AreEqual ("System.Int32", reader.GetDataTypeName (ordinal), "#3 data type should match");
} finally {
if (reader != null && !reader.IsClosed)
reader.Close ();
}
}
