static bool ACCESS() { try { // LoadAll CSharp.ACCESS.Employees emps = new CSharp.ACCESS.Employees(); emps.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Access\NewNorthwind.mdb;"; if(!emps.LoadAll()) { return false; // ERROR } // LoadByPrimaryKey int id = emps.EmployeeID; emps = new CSharp.ACCESS.Employees(); emps.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Access\NewNorthwind.mdb;"; if(!emps.LoadByPrimaryKey(id)) { return false; // ERROR } // AddNew/Save emps = new CSharp.ACCESS.Employees(); emps.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Access\NewNorthwind.mdb;"; 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.ACCESS.Employees(); emps.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Access\NewNorthwind.mdb;"; 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.ACCESS.Employees emps1 = new CSharp.ACCESS.Employees(); emps1.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Access\NewNorthwind.mdb;"; emps1.AddNew(); emps1.FirstName = "trella1_tx1"; emps1.LastName = "trella1_tx1"; CSharp.ACCESS.Employees emps2 = new CSharp.ACCESS.Employees(); emps2.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Access\NewNorthwind.mdb;"; 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.ACCESS.Employees(); emps.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Access\NewNorthwind.mdb;"; 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 ACCESS() { try { // LoadAll CSharp.ACCESS.Employees emps = new CSharp.ACCESS.Employees(); emps.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Access\NewNorthwind.mdb;"; if (!emps.LoadAll()) { return(false); // ERROR } // LoadByPrimaryKey int id = emps.EmployeeID; emps = new CSharp.ACCESS.Employees(); emps.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Access\NewNorthwind.mdb;"; if (!emps.LoadByPrimaryKey(id)) { return(false); // ERROR } // AddNew/Save emps = new CSharp.ACCESS.Employees(); emps.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Access\NewNorthwind.mdb;"; 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.ACCESS.Employees(); emps.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Access\NewNorthwind.mdb;"; 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.ACCESS.Employees emps1 = new CSharp.ACCESS.Employees(); emps1.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Access\NewNorthwind.mdb;"; emps1.AddNew(); emps1.FirstName = "trella1_tx1"; emps1.LastName = "trella1_tx1"; CSharp.ACCESS.Employees emps2 = new CSharp.ACCESS.Employees(); emps2.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Access\NewNorthwind.mdb;"; 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.ACCESS.Employees(); emps.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Access\NewNorthwind.mdb;"; 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); }