public int DatabaseVersion(ConnectionSettings settings)
{
int version = 0;
if (!CheckDatabaseExists(settings)) return version;
var tmpConn = new SqlConnection(_connectionStringGenerator.GetConnectionString(settings, true));
using (tmpConn)
{
using (var sqlCmd = new SqlCommand("if OBJECT_ID('usd_AppliedDatabaseScript', 'U') is not null select count(1) from usd_AppliedDatabaseScript else select 0 as Version", tmpConn))
{
tmpConn.Open();
version = (int)sqlCmd.ExecuteScalar();
tmpConn.Close();
}
}
return version;
}