[thelist] [.NET] Multi-Database Programming

Joshua Olson joshua at waetech.com
Mon Nov 8 16:06:20 CST 2004


> -----Original Message-----
> From: Marcus Andersson
> Sent: Monday, November 08, 2004 2:34 PM
> 
> How about programming to interfaces and using reflection?

Marcus, 

I did end up figuring out the problem and it used half of your suggestion.
Programming to interfaces is the key, but reflection ended up being used
too.

Here's the code I ended up with:

Assembly asm = Assembly.LoadWithPartialName("Oracle.Database");
if (asm == null)
  throw new Exception("Oracle drivers not found.  Please ensure...");
Type t = asm.GetType("Oracle.DataAccessClient.SqlConnection");
conn = (System.Data.IDbConnection)Activator.CreateInstance(t);
conn.ConnectionString = "whatever"

I repeated the same sort of code for all the different support databases and
it worked excellent!  

Thanks all.

<><><><><><><><><><>
Joshua Olson
Web Application Engineer
WAE Tech Inc.
http://www.waetech.com/service_areas/
706.210.0168 





More information about the thelist mailing list