private static Record SqliteStmtToRecord(SQLiteDataReader reader) { var nvc = reader.GetValues(); return new Record(nvc[RecordColumns.KEY], nvc[RecordColumns.VALUE], int.Parse(nvc[RecordColumns.SYNC_COUNT], CultureInfo.InvariantCulture), new DateTime(long.Parse(nvc[RecordColumns.LAST_MODIFIED_TIMESTAMP], CultureInfo.InvariantCulture.NumberFormat)), nvc[RecordColumns.LAST_MODIFIED_BY], new DateTime(long.Parse(nvc[RecordColumns.DEVICE_LAST_MODIFIED_TIMESTAMP], CultureInfo.InvariantCulture.NumberFormat)), int.Parse(nvc[RecordColumns.MODIFIED], CultureInfo.InvariantCulture) == 1); }
private static DatasetMetadata SqliteStmtToDatasetMetadata(SQLiteDataReader reader) { var nvc = reader.GetValues(); return new DatasetMetadata( nvc[DatasetColumns.DATASET_NAME], new DateTime(long.Parse(nvc[DatasetColumns.CREATION_TIMESTAMP], CultureInfo.InvariantCulture.NumberFormat)), new DateTime(long.Parse(nvc[DatasetColumns.LAST_MODIFIED_TIMESTAMP], CultureInfo.InvariantCulture.NumberFormat)), nvc[DatasetColumns.LAST_MODIFIED_BY], long.Parse(nvc[DatasetColumns.STORAGE_SIZE_BYTES], CultureInfo.InvariantCulture.NumberFormat), long.Parse(nvc[DatasetColumns.RECORD_COUNT], CultureInfo.InvariantCulture.NumberFormat) ); }
public static QueryRow Read(SQLiteDataReader reader) { var result = new QueryRow(); reader.GetValues(); for (var i = 0; i < reader.FieldCount; i++) { result.queryDefinition.Fields.Add( reader.GetName(i), new FieldDefinition( reader.GetName(i), reader.GetFieldType(i).ToSqlDbType(), false, false ) ); result.values.Add( reader.GetName(i), reader.GetValue(i) ); } return result; }