.NET (Core and Framework)

wout de zeeuw wrote:

but the idea is to parse into a type safe tree of classes

public static DbTable Read(DbProjectBuilder projectBuilder, XmlTextReader r) {
    DbTable table = new DbTable();
    bool isEmptyElement = XmlUtil.ReadStartElement(r, "Table");
    while (r.IsStartElement()) {
        switch (r.Name) {
            case "Name":
                table.Name = r.ReadElementString();
                break;
            case "Notes":
                table.Notes = r.ReadElementString();
                break;
            case "PrimaryKeyType":
                table.PrimaryKeyType =
                    (DbPrimaryKeyType)Enum.Parse(typeof(DbPrimaryKeyType), r.ReadElementString());
                break;
            case "PrimaryKeyName":
                table.PrimaryKeyName =
                    r.ReadElementString();
                break;
            case "Columns":
                ReadColumns(projectBuilder, table, r);
                break;
            case "Indexes":
                ReadIndexes(projectBuilder, table, r);
                break;
            default:
                r.ReadInnerXml();
                break;
        }
    }
    if (!isEmptyElement) {
        r.ReadEndElement();
    }
    return table;
}

private static void ReadIndexes(DbProjectBuilder projectBuilder, DbTable table, XmlTextReader r) {
    bool isEmptyElement = XmlUtil.ReadStartElement(r, "Indexes");
    while (r.IsStartElement()) {
        if (r.Name == "TableIndex") {
            DbTableIndex tableIndex = DbTableIndex.Read(projectBuilder, table, r);
            table.Indexes.Add(tableIndex);
        } else {
            r.ReadInnerXml();
        }
    }
    if (!isEmptyElement) {
        r.ReadEndElement();
    }
}

private static void ReadColumns(DbProjectBuilder projectBuilder, DbTable table, XmlTextReader r) {
    bool isEmptyElement = XmlUtil.ReadStartElement(r, "Columns");
    while (r.IsStartElement()) {
        if (r.Name == "Column") {
            DbColumn column = DbColumn.Read(projectBuilder, r);
            table.Columns.Add(column);
        } else {
            r.ReadInnerXml();
        }
    }
    if (!isEmptyElement) {
        r.ReadEndElement();
    }
}

wout de zeeuw wrote:

see e.g. typical code snippet below:

led mike wrote:

Ok, um after seeing your code I guess I should warn you that you appear to be reinventing the wheel only yours is shaped like a square.

public class CSVImport : DataTable

public CSVImport():base()
{ 
}
public CSVImport(SerializationInfo info,
                 StreamingContext context):base(info, context)
{ 
}

WolveFred2 wrote:

this feature appears only in Access 2007, not in Access 2003

WolveFred2 wrote:

What do you think of using SQL Server Compact Edition instead ? It seems to be greater than Access.

I are troll

Site says:

Support for the ADO.NET 3.5 Entity Framework
Supports nearly all the entity framework functionality that Sql Server supports, and passes 99% of the tests in MS's EFQuerySamples demo application.

I are troll