Data Type Conversion (Database Engine)

Publié le 2014/02/13 par Louis Dubois

Implicit and Explicit Conversion:

Implicit and Explicit Conversion

Implicit and Explicit Conversion

Publié dans SQL | 1 commentaire

Microsoft SQL Server Data Tools

Publié le 2014/02/07 par Louis Dubois

…provides an integrated environment for database developers to carry out all their database design work for any SQL Server platform (both on and off premise) within Visual Studio. Database developers can use the SQL Server Object Explorer in VS to easily create or edit database objects and data, or execute queries

Microsoft SQL Server Data Tools

Publié dans Informatique, SQL | Laisser un commentaire

SQL Server Data Tools – Business Intelligence

Publié le 2014/02/07 par Louis Dubois

Download File

Install SQL Server Data Tools – Business Intelligence for Visual Studio 2012
To install SQL Server Data Tools – Business Intelligence for Visual Studio 2012

  1. Run SSDTBI_VS2012_x86_ENU.exe to begin installation.
  2. In SQL Server 2012 Setup, on the License Terms page, if you agree to the Microsoft Software License Terms, select I accept the license terms, optionally select Send feature usage data to Microsoft, and then click Next.
  3. On the Installation Type page, verify Perform a new installation of SQL Server 2012 is selected, and then click Next.  Note: Setup will not install a new instance of SQL Server 2012 Server, but will install new SQL Server Features, including SQL Server Data Tools- Business Intelligence for Visual Studio 2012, which you will select on the next Feature Selection page.
  4. On the Feature Selection page, click SQL Server Data Tools – Business Intelligence for Visual Studio 2012, and then click Next.
  5.  On the Error Reporting page, optionally select Send Windows and SQL Server Error Reports to Microsoft or your corporate report server, and then click Next.
Publié dans SQL | Laisser un commentaire

IDisposable interface

Publié le 2014/02/06 par Louis Dubois 
public class MyClass : IDisposable
{
    private bool disposed;

    /// <summary>
    /// Construction
    /// </summary>
    public MyClass()
    {
    }

    /// <summary>
    /// Destructor
    /// </summary>
    ~MyClass()
    {
        this.Dispose(false);
    }

    /// <summary>
    /// The dispose method that implements IDisposable.
    /// </summary>
    public void Dispose()
    {
        this.Dispose(true);
        GC.SuppressFinalize(this);
    }

    /// <summary>
    /// The virtual dispose method that allows
    /// classes inherithed from this one to dispose their resources.
    /// </summary>
    /// <param name="disposing"></param>
    protected virtual void Dispose(bool disposing)
    {
        if (!disposed)
        {
            if (disposing)
            {
                // Dispose managed resources here.
            }

            // Dispose unmanaged resources here.
        }

        disposed = true;
    }
}

 

Publié dans CSharp | Tagué | Laisser un commentaire