[sqlite] Preferred cast in C#

[Edward Ned Harvey (sqlite)]

I understand there are only 5 data types in Sqlite, and that the column type 
isn't necessarily the type of object returned in a query.  Is there a more 
seamless way to cast responses than this?

I would really love to have an easy way of putting a long? into the database, 
and then getting a long? back out.  Maybe it exists and I'm just doing it the 
hard way right now...

    string employeeName;

    object myObj = reader["employeeName"];
    if (myObj is System.DBNull)
        employeeName = null;
    else if (myObj is string)
        employeeName = (string)myObj;
    else
        throw new Exception("Unexpected object type");
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users