Example #1
0
        static void Update(DBConnectionWrapper conn, SalesOrderHeader obj, DBTransactionWrapper trans = null)
        {
            int nor = conn.Update(ref obj, trans);

            Console.WriteLine(nor + " line updated.");
            var obj2 = new SalesOrderHeader();

            obj2.SalesOrderId = obj.SalesOrderId;
            obj2.ModifiedDate = DateTime.Now;
            obj2.Status       = 2;
            nor = conn.Update(ref obj2, trans, i => i.ModifiedDate, i => i.Status);
            Console.WriteLine(nor + " line updated (only update ModifiedDate and Status).");
        }
Example #2
0
        static Employee Update(DBConnectionWrapper conn, DBTransactionWrapper trans = null)
        {
            Employee obj = new Employee
            {
                EMPLOYEE_ID = 207,
                HIRE_DATE   = DateTime.Now.AddMonths(-1)
            };
            int ret = conn.Update(ref obj, trans, i => i.HIRE_DATE);

            Console.WriteLine(ret + " rows updated");
            if (ret > 0)
            {
                Console.WriteLine("The first name of the updated record is " + obj.FIRST_NAME);
            }
            return(obj);
        }