} // End Function CreateDataAdapter
public static System.Data.Common.DbDataAdapter CreateDataAdapter(this System.Data.Common.DbConnection connection, System.Data.Common.DbCommand cmd)
{
System.Data.Common.DbProviderFactory fact = GetProvider(connection);
System.Data.Common.DbDataAdapter da = fact.CreateDataAdapter();
da.SelectCommand = cmd;
return(da);
} // End Function CreateDataAdapter
public static System.Data.DataTable GetDataTable(System.Data.Common.DbCommand cmd)
{
System.Data.DataTable dt = new System.Data.DataTable();
using (System.Data.Common.DbConnection con = GetConnection())
{
cmd.Connection = con;
using (System.Data.Common.DbDataAdapter da = fact.CreateDataAdapter())
{
da.SelectCommand = cmd;
da.Fill(dt);
}
}
return(dt);
}
public static System.Data.Common.DbDataAdapter GetAdapter(string strSQL)
{
System.Data.Common.DbDataAdapter ada = fac.CreateDataAdapter();
ada.SelectCommand = fac.CreateCommand();
ada.SelectCommand.Connection = fac.CreateConnection();
ada.SelectCommand.Connection.ConnectionString = GetConnectionString();
ada.SelectCommand.CommandText = strSQL;
return(ada);
}
/// <summary>
/// Creates a new instance of a DataTable.
/// </summary>
public DataTable(System.Data.Common.DbProviderFactory provider)
: this()
{
factory = provider;
this._ActiveConnection = factory.CreateConnection();
this._Ad = factory.CreateDataAdapter();
this._Cmd = _Ad.SelectCommand;
this._Cmds = factory.CreateCommandBuilder();
_Cmds.DataAdapter = _Ad;
if (_ActiveConnection.State == ConnectionState.Closed)
{
_ActiveConnection.Open();
}
}
private void AttachConnection(ConnectionStringSettings connection)
{
Tenor.Data.Dialects.GeneralDialect dialect = Dialects.DialectFactory.CreateDialect(connection);
factory = dialect.Factory;
_ActiveConnection = Helper.CreateConnection(connection);
_Cmd = _ActiveConnection.CreateCommand();
_Cmd.CommandTimeout = Helper.DefaultTimeout;
_Ad = factory.CreateDataAdapter();
_Ad.SelectCommand = _Cmd;
_Cmds = factory.CreateCommandBuilder();
_Cmds.DataAdapter = _Ad;
if (_ActiveConnection.State == ConnectionState.Closed)
{
Helper.OpenConnection(_ActiveConnection, dialect);
}
}
} // End Function GetDataTable
public virtual System.Data.DataTable GetDataTable(System.Data.IDbCommand cmd)
{
System.Data.DataTable dt = new System.Data.DataTable();
using (System.Data.Common.DbConnection idbc = GetConnection())
{
lock (idbc)
{
lock (cmd)
{
try
{
cmd.Connection = idbc;
using (System.Data.Common.DbDataAdapter daQueryTable = m_fact.CreateDataAdapter())
{
daQueryTable.SelectCommand = (System.Data.Common.DbCommand)cmd;
daQueryTable.Fill(dt);
} // End Using daQueryTable
} // End Try
catch (System.Data.Common.DbException ex)
{
if (Log("SQL.GetDataTable(System.Data.IDbCommand cmd)", ex, cmd))
{
throw;
}
}// End Catch
finally
{
if (idbc.State != System.Data.ConnectionState.Closed)
{
idbc.Close();
}
} // End Finally
} // End lock cmd
} // End lock idbc
} // End Using idbc
return(dt);
} // End Function GetDataTable
public static System.Data.DataTable GetDataTable(System.Data.IDbCommand cmd)
{
System.Data.DataTable dt = new System.Data.DataTable();
using (System.Data.IDbConnection idbConn = GetConnection())
{
cmd.Connection = idbConn;
try
{
using (System.Data.Common.DbDataAdapter da = s_factory.CreateDataAdapter())
{
da.SelectCommand = (System.Data.Common.DbCommand)cmd;
da.Fill(dt);
}
}
catch
{
throw;
}
}
return(dt);
}
} // End Function GetProvider
public static System.Data.Common.DbDataAdapter CreateDataAdapter(this System.Data.Common.DbConnection connection)
{
System.Data.Common.DbProviderFactory fact = GetProvider(connection);
return(fact.CreateDataAdapter());
} // End Function CreateDataAdapter
public IDbDataAdapter CreateAdapter()
{
IDbDataAdapter adr = _instance.CreateDataAdapter();
return(adr);
}
