Connection Pooling?

Comments

• david connell Redgate › Posts: 172 Silver 1

  June 15, 2006 8:32AM

  Hi there,
  I am sorry to say that with the current API this is not possible.
  However here is an idea that you could possibly make work for yourself. However this idea is not supported and probably will not be possible in future releases. (ConectionProperties may become a sealed class.)
  The basis is taken from the code snippits.

  		class [b]MyConnectionProperties[/b] : ConnectionProperties
  		{
  			public MyConnectionProperties (string serverName, string databaseName) : base(serverName, databaseName)
  			{
  				
  			}
  
  			public MyConnectionProperties(string serverName, string databaseName, string userName, string password) : base (serverName, databaseName, userName, password)
  			{				
  			}
  			public override string ToString()
  			{
  				StringBuilder sb = new StringBuilder();
  				sb.Append("Data Source=");
  				sb.Append(this.ServerName);
  				sb.Append(";initial catalog=");
  				sb.Append(this.DatabaseName);
  				sb.Append(";");
  				sb.Append("Integrated security=SSPI;");
  				sb.Append(";[b]pooling=true[/b]");
  				return sb.ToString();
  			}			
  		}
  		private static void LoadAndSaveASnapshot()
  		{
  			//register a database using integrated security
  			Database db1=new Database();
  			db1.Register(new [b]MyConnectionProperties[/b](@"davidc\sql2005", "database1"), Options.Default);
  
  			//save the database to disk
  			db1.SaveToDisk(@"c:\WidgetStaging.snp");
  
  			Database db2=new Database();
  			db2.LoadFromDisk(@"c:\WidgetStaging.snp");
  
  			//dispose of the objects
  			db1.Dispose();
  			db2.Dispose();
  		}
  
  

  
  From here you could modify the connection string further.
  Note I have not supported non integrated security in this code. I have verified that this will work with SQL Bundle 5.1, but no further.
  I hope that helps...

  0 · Share on Twitter
• fordc03 Posts: 49 Bronze 2

  June 15, 2006 4:12PM

  Hey that's pretty cool...I might be able to do something with that.

  0 · Share on Twitter