/// <summary> /// Helper to retrieve data. /// </summary> /// <param name="statement"></param> /// <param name="position"></param> /// <returns></returns> private object GetObject(SQLiteStatement statement, int position) { try { return statement.GetText(position); } catch (Exception e) { } try { return statement.GetInteger(position); } catch (Exception e) { } try { return statement.GetFloat(position); } catch (Exception e) { } return null; }
private object GetObject(SQLiteStatement statement, int position) { if (statement[position] == null) { return null; } if (statement[position].GetType().Name == "String") { return statement.GetText(position); } if (intTypes.Contains(statement[position].GetType().Name)) { return statement.GetInteger(position); } // //fallback try to detect type using exceptions // try { return statement.GetText(position); } catch (Exception e) { } try { return statement.GetInteger(position); } catch (Exception e) { } try { return statement.GetFloat(position); } catch (Exception e) { } return null; }