public void UpdateUsingInformixAdoDotNetProviderDirectly()
{
using (var cn = new IBM.Data.Informix.IfxConnection(Simple.Data.Informix.Tests.Properties.Settings.Default.ConnectionString_V7)) {
cn.Open();
using (var cmd = cn.CreateCommand()) {
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "update manufact set lead_time = ? where manu_code = ?";
cmd.Parameters.Add("lead_time", "16");
cmd.Parameters.Add("manu_code", "NKL");
cmd.ExecuteNonQuery();
}
}
}
public void UpdateUsingInformixAdoDotNetProviderDirectly()
{
using (var cn = new IBM.Data.Informix.IfxConnection(Simple.Data.Informix.Tests.Properties.Settings.Default.ConnectionString_V7)) {
cn.Open();
using (var cmd = cn.CreateCommand()) {
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "update manufact set lead_time = ? where manu_code = ?";
cmd.Parameters.Add("lead_time", "16");
cmd.Parameters.Add("manu_code", "NKL");
cmd.ExecuteNonQuery();
}
}
}
public void InsertUsingInformixAdoDotNetProviderDirectly()
{
using (var cn = new IBM.Data.Informix.IfxConnection(Simple.Data.Informix.Tests.Properties.Settings.Default.ConnectionString_V7)) {
cn.Open();
using (var cmd = cn.CreateCommand()) {
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "insert into manufact (manu_code, manu_name, lead_time) values (?, ?, ?)";
cmd.Parameters.Add("manu_code", "J17");
cmd.Parameters.Add("manu_name", "Jon 17");
cmd.Parameters.Add("lead_time", "17");
//cmd.Parameters.Add("lead_time", new IBM.Data.Informix.IfxTimeSpan(17, IBM.Data.Informix.IfxTimeUnit.Day));
cmd.ExecuteNonQuery();
}
}
}
public void InsertUsingInformixAdoDotNetProviderDirectly()
{
using (var cn = new IBM.Data.Informix.IfxConnection(Simple.Data.Informix.Tests.Properties.Settings.Default.ConnectionString_V7)) {
cn.Open();
using (var cmd = cn.CreateCommand()) {
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "insert into manufact (manu_code, manu_name, lead_time) values (?, ?, ?)";
cmd.Parameters.Add("manu_code", "J17");
cmd.Parameters.Add("manu_name", "Jon 17");
cmd.Parameters.Add("lead_time", "17");
//cmd.Parameters.Add("lead_time", new IBM.Data.Informix.IfxTimeSpan(17, IBM.Data.Informix.IfxTimeUnit.Day));
cmd.ExecuteNonQuery();
}
}
}
public void FindUsingInformixAdoDotNetProviderDirectly()
{
using (var cn = new IBM.Data.Informix.IfxConnection(Simple.Data.Informix.Tests.Properties.Settings.Default.ConnectionString_V7)) {
cn.Open();
using (var cmd = cn.CreateCommand()) {
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "select * from manufact where lead_time = ?";
cmd.Parameters.Add("lead_time", "3");
using (var reader = cmd.ExecuteReader()) {
for (; reader.Read(); ) {
var manu_code = reader[0];
var manu_name = reader[1];
var lead_time = reader[2];
}
}
}
}
}
public void FindUsingInformixAdoDotNetProviderDirectly()
{
using (var cn = new IBM.Data.Informix.IfxConnection(Simple.Data.Informix.Tests.Properties.Settings.Default.ConnectionString_V7)) {
cn.Open();
using (var cmd = cn.CreateCommand()) {
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "select * from manufact where lead_time = ?";
cmd.Parameters.Add("lead_time", "3");
using (var reader = cmd.ExecuteReader()) {
for (; reader.Read();)
{
var manu_code = reader[0];
var manu_name = reader[1];
var lead_time = reader[2];
}
}
}
}
}
public IDbConnection CreateConnection()
{
IDbConnection conn = null;
if (ClientType.ctMsSql == DbType)
{
conn = new SqlConnection(ConnectionString);
}
else if (ClientType.ctOleDB == DbType)
{
conn = new OleDbConnection(ConnectionString);
}
else if (ClientType.ctOracle == DbType)
{
conn = new OracleConnection(ConnectionString);
if (conn.State == ConnectionState.Closed) conn.Open();
OracleTransaction tran = conn.BeginTransaction(IsolationLevel.Unspecified) as OracleTransaction;
tran.Commit();
conn.Close();
}
else if (ClientType.ctODBC == DbType)
{
conn = new OdbcConnection(ConnectionString);
}
#if MySql
else if (ClientType.ctMySql == DbType)
{
conn = new MySql.Data.MySqlClient.MySqlConnection(ConnectionString);
}
#endif
#if Informix
else if (ClientType.ctInformix == DbType)
{
conn = new IBM.Data.Informix.IfxConnection(ConnectionString);
if (conn.State == ConnectionState.Closed) conn.Open();
var command = conn.CreateCommand();
command.CommandText = "EXECUTE PROCEDURE ifx_allow_newline ('t')";
command.ExecuteNonQuery();
}
#endif
#if Sybase
else if (ClientType.ctSybase == DbType)
{
conn = new Sybase.Data.AseClient.AseConnection(ConnectionString);
}
#endif
else
{
throw new EEPException(EEPException.ExceptionType.MethodNotSupported, this.GetType(), null, "CreateConnection", null);
}
return conn;
}
