Click here to Skip to main content
15,879,535 members
Articles / Database Development / SQL Server / SQL Server 2008

Continuous Integration for Databases with Visual Studio

Rate me:
Please Sign up or sign in to vote.
4.85/5 (14 votes)
23 Nov 2010Apache18 min read 62.9K   1.2K   68  
Provides a framework for predictably compiling, extracting, and deploying a database project.
// <copyright file="IExistenceChecker.cs" company="Adam Nachman">
// Copyright (c) 2009 All Right Reserved Adam Nachman
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
// http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.
// </copyright>
// <author>Adam Nachman</author>
namespace AdamNachman.Build.SqlExtract
{
    /// <summary>
    /// The interface implemented by all ExistenceChecker classes
    /// </summary>
    public interface IExistenceChecker
    {
        #region Properties

        /// <summary>
        /// Gets or sets the configuration string of the IExistenceChecker
        /// </summary>
        string ConfigurationString
        {
            get;
            set;
        }

        /// <summary>
        /// Gets or sets the ILogger for of the IExistenceChecker
        /// </summary>
        SqlDeployment.Interfaces.ILogger Logger
        {
            get;
            set;
        }

        #endregion Properties

        #region Methods

        /// <summary>
        /// Determines whether or not an object already exists in the schema/manifest file
        /// </summary>
        /// <param name="schemaName">The name of the schema to which the object belongs</param>
        /// <param name="objectName">The name of the object</param>
        /// <returns>True if the object exists, else false</returns>
        bool DoesDBObjectExists(string schemaName, string objectName);

        /// <summary>
        /// Initializes the object
        /// </summary>
        void Initialize();

        #endregion Methods
    }
}

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Apache License, Version 2.0


Written By
Chief Technology Officer
Australia Australia
Emigrated to Sydney, Australia in 2013 from Cape Town, South Africa, and have been writing commercial software since 1997.

Expertise includes MS SQL Server (7 till latest), C#, VB6, VB.NET, VBScript, JavaScript, ASP, HTML, WPF Angular, Windows Installer and InstallShield (multiple versions) and a partridge in a pear tree. MSBuild, CruiseControl.NET, TFS, Jenkins, TeamCity, ant and nant are all necessary sidelines. Have tinkered with Java and C++

Experienced with Enterprise level application design and deployment, as well as sizing and scaling high volume OLTP database designs up to tens of thousands of transactions per second and diagnosing application and database performance bottlenecks.

Comments and Discussions