Description Image http://baymyo.com/gallery/pimage/multi_sql_code_generate_gif-50cf8.gif[^] Open Source Code, Downlaod Click Here! MSSQL, ORACLE, MySQL, and OleDb to establish connections to servers via a single layer. The following block of code to show the connection layer.
public class MConnection : IDisposable
{
#region IDisposable Members
public void Dispose()
{
this.Close();
if (this.m_ClientConnection != null)
this.m_ClientConnection.Dispose();
GC.SuppressFinalize(this);
}
#endregion
#region --- Member ---
IMConnection m\_ClientConnection;
internal IMConnection ClientConnection
{
get { return m\_ClientConnection; }
}
private MClientProvider m\_ClientProvider;
public MClientProvider ClientProvider
{
get { return m\_ClientProvider; }
}
private string m\_ConnectionString;
public string ConnectionString
{
get { return m\_ConnectionString; }
}
private System.Data.ConnectionState m\_State;
public System.Data.ConnectionState State
{
get { return m\_State; }
}
public System.ComponentModel.ISite Site
{
get
{
return m\_ClientConnection.Site;
}
set
{
m\_ClientConnection.Site = value;
}
}
public string ServerVersion
{
get
{
return m\_ClientConnection.ServerVersion;
}
}
public string Database
{
get
{
return m\_ClientConnection.Database;
}
}
public string DataSource
{
get
{
return m\_ClientConnection.DataSource;
}
}
#endregion
#region --- Constructor ---
public MConnection(MClientProvider clientProvider)
{
this.m\_ClientProvider = clientProvider;
switch (this.m\_Cli
