//-----------------------------------------------------------------------
//  This file is part of the Microsoft .NET Framework SDK Code Samples.
// 
//  Copyright (C) Microsoft Corporation.  All rights reserved.
// 
//This source code is intended only as a supplement to Microsoft
//Development Tools and/or on-line documentation.  See these other
//materials for detailed information regarding Microsoft code samples.
// 
//THIS CODE AND INFORMATION ARE PROVIDED AS IS WITHOUT WARRANTY OF ANY
//KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE
//IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A
//PARTICULAR PURPOSE.
//-----------------------------------------------------------------------

#using <mscorlib.dll>
using System::String; using System::Console; using System::Exception;
#using <System.dll>
#using <system.data.dll>
using namespace System::Data::SqlClient;

ref class connectionpooling
{
  

  public:
 void Run()
  {
    try
    {
      String ^ connString;

      // Specification in the connection string:
      // Please note: Pooling is implicit, you automatically get it unless you disable it. 
      //              Therefore, "true" is the default for the pooling keyword (pooling=true).   
      // Connection Reset:    False
      // Connection Lifetime: 5
      // Enlist:              true
      // Min Pool Size:       1
      // Max Pool Size:       50
      // Warning: Embedded usernames/passwords in database connection strings are inherently
      // insecure, and should only be used on platforms (e.g. Win9x) that do not support Integrated
      // Security.  See the ASP.NET Quickstart for examples of Integrated Security.
      connString = String::Concat(String::Concat("server=(local)\\SQLExpress;Integrated Security=SSPI;database=northwind;",
                   "connection reset=false;",
                   "connection lifetime=5;",
                   "min pool size=1;"), 
                   "max pool size=50");

      SqlConnection ^ myConnection1 = gcnew SqlConnection(connString);
      SqlConnection ^ myConnection2 = gcnew SqlConnection(connString);
      SqlConnection ^ myConnection3 = gcnew SqlConnection(connString);

      // Open two connections. One is from the pool (see min pool size), the other is created.
      Console::WriteLine ("Open two connections.");
      myConnection1->Open();
      myConnection2->Open();

      // Now there are two connections in the pool that matches the connection string.
      // Return the both connections to the pool. 
      Console::WriteLine ("Return both of the connections to the pool.");
      myConnection1->Close();
      myConnection2->Close();

      // Get a connection out of the pool.
      Console::WriteLine ("Open a connection from the pool.");
      myConnection1->Open();

      // Get a second connection out of the pool.
      Console::WriteLine ("Open a second connection from the pool.");
      myConnection2->Open();

      // Open a third connection.
      Console::WriteLine ("Open a third connection.");
      myConnection3->Open();

      // Return the all connections to the pool.  
      Console::WriteLine ("Return all three connections to the pool.");
      myConnection1->Close();
      myConnection2->Close();
      myConnection3->Close();
    }
	catch (Exception ^ e)
    {
      // Display the error.
      Console::WriteLine(e->ToString());
    }
  }
};


int main()
  {
    connectionpooling ^ myconnectionpooling = gcnew connectionpooling();
    myconnectionpooling->Run();
  }