/// <summary>
        /// Creates a new Version Info entity.
        /// </summary>
        /// <param name="component">The name of the component.</param>
        /// <param name="version">The version of the component.</param>
        /// <returns>A <see cref="ManagerResponse"/> object.</returns>
        public ManagerResponse Add(string component, string version)
        {
            // Validate parameters
            if (String.IsNullOrWhiteSpace(component))
            {
                return ManagerResponse.InvalidData;
            }

            if (String.IsNullOrWhiteSpace(version))
            {
                return ManagerResponse.InvalidData;
            }

            var sqlScriptVersionInfo = new SqlScriptVersionInfo()
            {
                Component = component,
                Version = version,
            };

            ManagerResponse response;

            using (var context = new Entities(_connectionString))
            {
                context.SqlScriptVersionInfos.AddObject(sqlScriptVersionInfo as SqlScriptVersionInfo);
                response = context.SaveChanges() == 1 ? ManagerResponse.Success : ManagerResponse.UnknownFailure;
            }

            return response;
        }
        /// <summary>
        /// Updates the specified <see cref="IVersionInfo"/> entity.
        /// </summary>
        /// <param name="versionInfo">The <see cref="IVersionInfo"/> entity to update.</param>
        /// <returns>A <see cref="ManagerResponse"/> object.</returns>
        public ManagerResponse Update(IVersionInfo versionInfo)
        {
            // Validate parameters
            if (versionInfo == null)
            {
                return ManagerResponse.MissingData;
            }

            if (String.IsNullOrWhiteSpace(versionInfo.Component))
            {
                return ManagerResponse.InvalidData;
            }

            if (String.IsNullOrWhiteSpace(versionInfo.Version))
            {
                return ManagerResponse.InvalidData;
            }

            ManagerResponse response;

            using (var context = new Entities(_connectionString))
            {
                context.SqlScriptVersionInfos.Attach(versionInfo as SqlScriptVersionInfo);
                context.ObjectStateManager.ChangeObjectState(versionInfo, EntityState.Modified);
                response = context.SaveChanges() == 1 ? ManagerResponse.Success : ManagerResponse.UnknownFailure;
            }

            return response;
        }