Index: Ringtoets/HydraRing/src/Ringtoets.HydraRing.IO/HydraulicBoundaryDatabase/HydraulicBoundaryDatabaseReader.cs =================================================================== diff -u -r99e4d6ea2e8c5c2e542357abb2577dd2cd942abf -rcb70bb1b407efb3bb39788178054a0bcc3933c7f --- Ringtoets/HydraRing/src/Ringtoets.HydraRing.IO/HydraulicBoundaryDatabase/HydraulicBoundaryDatabaseReader.cs (.../HydraulicBoundaryDatabaseReader.cs) (revision 99e4d6ea2e8c5c2e542357abb2577dd2cd942abf) +++ Ringtoets/HydraRing/src/Ringtoets.HydraRing.IO/HydraulicBoundaryDatabase/HydraulicBoundaryDatabaseReader.cs (.../HydraulicBoundaryDatabaseReader.cs) (revision cb70bb1b407efb3bb39788178054a0bcc3933c7f) @@ -100,17 +100,15 @@ } /// - /// Gets the database version from the metadata table. + /// Gets the version of the hydraulic boundary database. /// - /// The version found in the database, or if the version - /// cannot be found. + /// The version found in the database, or if the version cannot be found. /// Thrown when a query could not be executed on the database schema. public string GetVersion() { - string versionQuery = HydraulicBoundaryDatabaseQueryBuilder.GetVersionQuery(); try { - using (IDataReader dataReader = CreateDataReader(versionQuery, null)) + using (IDataReader dataReader = CreateDataReader(HydraulicBoundaryDatabaseQueryBuilder.GetVersionQuery(), null)) { return !dataReader.Read() ? string.Empty : Convert.ToString(dataReader[GeneralTableDefinitions.GeneratedVersion]); } @@ -123,23 +121,20 @@ } /// - /// Gets the track id from the metadata table. + /// Gets the track id from the hydraulic boundary database. /// - /// The track id found in the database, or 0 if the track id - /// cannot be found. - /// Thrown when the database returned incorrect - /// values for required properties. + /// The track id found in the database, or 0 if the track id cannot be found. + /// Thrown when the database contains incorrect values for required properties. /// Thrown when a query could not be executed on the database schema. public long GetTrackId() { - string trackQuery = HydraulicBoundaryDatabaseQueryBuilder.GetTrackIdQuery(); - var sqliteParameter = new SQLiteParameter - { - DbType = DbType.String - }; try { - using (IDataReader dataReader = CreateDataReader(trackQuery, sqliteParameter)) + using (IDataReader dataReader = CreateDataReader(HydraulicBoundaryDatabaseQueryBuilder.GetTrackIdQuery(), + new SQLiteParameter + { + DbType = DbType.String + })) { return !dataReader.Read() ? 0 : Convert.ToInt64(dataReader[GeneralTableDefinitions.TrackId]); } @@ -157,21 +152,19 @@ } /// - /// Gets the amount of locations that can be read from the database. + /// Gets the amount of locations that can be read from the hydraulic boundary database. /// - /// The amount of locations that can be read. + /// The amount of locations that can be read, or 0 if no locations could be found. /// Thrown when a query could not be executed on the database schema. public int GetLocationCount() { - string locationCountQuery = HydraulicBoundaryDatabaseQueryBuilder.GetRelevantLocationsCountQuery(); - var sqliteParameter = new SQLiteParameter - { - DbType = DbType.String - }; - try { - using (IDataReader dataReader = CreateDataReader(locationCountQuery, sqliteParameter)) + using (IDataReader dataReader = CreateDataReader(HydraulicBoundaryDatabaseQueryBuilder.GetRelevantLocationsCountQuery(), + new SQLiteParameter + { + DbType = DbType.String + })) { return !dataReader.Read() ? 0 : Convert.ToInt32(dataReader[HrdLocationsTableDefinitions.Count]); }