/// <summary>
/// Gets the <see cref="Version"/> of the current Subtext data store (ie. SQL Server).
/// This is the value stored in the database. If it does not match the actual
/// assembly version, we may need to run an upgrade.
/// </summary>
/// <returns></returns>
public Version GetCurrentInstallationVersion()
{
var procedures = new StoredProcedures(_connectionString);
try
{
using(var reader = procedures.VersionGetCurrent())
{
if(reader.Read())
{
var version = new Version((int)reader["Major"], (int)reader["Minor"], (int)reader["Build"]);
reader.Close();
return version;
}
}
}
catch(SqlException exception)
{
if(exception.Number != (int)SqlErrorMessage.CouldNotFindStoredProcedure)
{
throw;
}
}
return null;
}
