static bool MYSQL4()
{
try
{
// LoadAll
CSharp.MySQL4.employee emps = new CSharp.MySQL4.employee();
emps.ConnectionString = @"Database=Test;Data Source=Griffo;User Id=anonymous;";
emps.Query.AddResultColumn(CSharp.MySQL4.employee.ColumnNames.EmployeeID);
emps.Query.AddResultColumn(CSharp.MySQL4.employee.ColumnNames.LastName);
emps.Query.AddOrderBy(CSharp.MySQL4.employee.ColumnNames.LastName, WhereParameter.Dir.ASC);
emps.Query.Top = 2;
if(!emps.Query.Load())
{
return false; // ERROR
}
// LoadAll
emps = new CSharp.MySQL4.employee();
emps.ConnectionString = @"Database=Test;Data Source=Griffo;User Id=anonymous;";
if(!emps.LoadAll())
{
return false; // ERROR
}
// LoadByPrimaryKey
uint id = emps.EmployeeID;
emps = new CSharp.MySQL4.employee();
emps.ConnectionString = @"Database=Test;Data Source=Griffo;User Id=anonymous;";
if(!emps.LoadByPrimaryKey(id))
{
return false; // ERROR
}
// AddNew/Save
emps = new CSharp.MySQL4.employee();
emps.ConnectionString = @"Database=Test;Data Source=Griffo;User Id=anonymous;";
emps.AddNew();
emps.FirstName = "trella1";
emps.LastName = "trella1";
emps.AddNew();
emps.FirstName = "trella2";
emps.LastName = "trella2";
emps.Save();
// Query.Load/Update/Save
emps = new CSharp.MySQL4.employee();
emps.ConnectionString = @"Database=Test;Data Source=Griffo;User Id=anonymous;";
emps.Where.FirstName.Value = "trella%";
emps.Where.FirstName.Operator = WhereParameter.Operand.Like;
emps.Where.LastName.Value = "trella%";
emps.Where.LastName.Operator = WhereParameter.Operand.Like;
if(!emps.Query.Load())
{
return false; // ERROR
}
do
emps.LastName = emps.LastName + ":new";
while(emps.MoveNext());
emps.Save();
// Transaction
CSharp.MySQL4.employee emps1 = new CSharp.MySQL4.employee();
emps1.ConnectionString = @"Database=Test;Data Source=Griffo;User Id=anonymous;";
emps1.AddNew();
emps1.FirstName = "trella1_tx1";
emps1.LastName = "trella1_tx1";
CSharp.MySQL4.employee emps2 = new CSharp.MySQL4.employee();
emps2.ConnectionString = @"Database=Test;Data Source=Griffo;User Id=anonymous;";
emps2.AddNew();
emps2.FirstName = "trella1_tx2";
emps2.LastName = "trella1_tx2";
TransactionMgr.ThreadTransactionMgr().BeginTransaction();
emps1.Save();
emps2.Save();
TransactionMgr.ThreadTransactionMgr().CommitTransaction();
// Query.Load/MarkAsDeleted/Save
emps = new CSharp.MySQL4.employee();
emps.ConnectionString = @"Database=Test;Data Source=Griffo;User Id=anonymous;";
emps.Where.FirstName.Value = "trella%";
emps.Where.FirstName.Operator = WhereParameter.Operand.Like;
emps.Where.LastName.Value = "trella%";
emps.Where.LastName.Operator = WhereParameter.Operand.Like;
if(!emps.Query.Load())
{
return false; // ERROR
}
emps.DeleteAll();
emps.Save();
}
catch(Exception ex)
{
Console.WriteLine(ex.Message);
return false;
}
finally
{
TransactionMgr.ThreadTransactionMgrReset();
}
return true;
}
static bool MYSQL4()
{
try
{
// LoadAll
CSharp.MySQL4.employee emps = new CSharp.MySQL4.employee();
emps.ConnectionString = @"Database=Test;Data Source=Griffo;User Id=anonymous;";
emps.Query.AddResultColumn(CSharp.MySQL4.employee.ColumnNames.EmployeeID);
emps.Query.AddResultColumn(CSharp.MySQL4.employee.ColumnNames.LastName);
emps.Query.AddOrderBy(CSharp.MySQL4.employee.ColumnNames.LastName, WhereParameter.Dir.ASC);
emps.Query.Top = 2;
if (!emps.Query.Load())
{
return(false); // ERROR
}
// LoadAll
emps = new CSharp.MySQL4.employee();
emps.ConnectionString = @"Database=Test;Data Source=Griffo;User Id=anonymous;";
if (!emps.LoadAll())
{
return(false); // ERROR
}
// LoadByPrimaryKey
uint id = emps.EmployeeID;
emps = new CSharp.MySQL4.employee();
emps.ConnectionString = @"Database=Test;Data Source=Griffo;User Id=anonymous;";
if (!emps.LoadByPrimaryKey(id))
{
return(false); // ERROR
}
// AddNew/Save
emps = new CSharp.MySQL4.employee();
emps.ConnectionString = @"Database=Test;Data Source=Griffo;User Id=anonymous;";
emps.AddNew();
emps.FirstName = "trella1";
emps.LastName = "trella1";
emps.AddNew();
emps.FirstName = "trella2";
emps.LastName = "trella2";
emps.Save();
// Query.Load/Update/Save
emps = new CSharp.MySQL4.employee();
emps.ConnectionString = @"Database=Test;Data Source=Griffo;User Id=anonymous;";
emps.Where.FirstName.Value = "trella%";
emps.Where.FirstName.Operator = WhereParameter.Operand.Like;
emps.Where.LastName.Value = "trella%";
emps.Where.LastName.Operator = WhereParameter.Operand.Like;
if (!emps.Query.Load())
{
return(false); // ERROR
}
do
{
emps.LastName = emps.LastName + ":new";
}while(emps.MoveNext());
emps.Save();
// Transaction
CSharp.MySQL4.employee emps1 = new CSharp.MySQL4.employee();
emps1.ConnectionString = @"Database=Test;Data Source=Griffo;User Id=anonymous;";
emps1.AddNew();
emps1.FirstName = "trella1_tx1";
emps1.LastName = "trella1_tx1";
CSharp.MySQL4.employee emps2 = new CSharp.MySQL4.employee();
emps2.ConnectionString = @"Database=Test;Data Source=Griffo;User Id=anonymous;";
emps2.AddNew();
emps2.FirstName = "trella1_tx2";
emps2.LastName = "trella1_tx2";
TransactionMgr.ThreadTransactionMgr().BeginTransaction();
emps1.Save();
emps2.Save();
TransactionMgr.ThreadTransactionMgr().CommitTransaction();
// Query.Load/MarkAsDeleted/Save
emps = new CSharp.MySQL4.employee();
emps.ConnectionString = @"Database=Test;Data Source=Griffo;User Id=anonymous;";
emps.Where.FirstName.Value = "trella%";
emps.Where.FirstName.Operator = WhereParameter.Operand.Like;
emps.Where.LastName.Value = "trella%";
emps.Where.LastName.Operator = WhereParameter.Operand.Like;
if (!emps.Query.Load())
{
return(false); // ERROR
}
emps.DeleteAll();
emps.Save();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(false);
}
finally
{
TransactionMgr.ThreadTransactionMgrReset();
}
return(true);
}
