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]);
}