protected override string GetInsertSql(object record)
        {
            OrdersFixed obj = (OrdersFixed)record;

            return(String.Format("INSERT INTO OrdersTemp (CustomerID, EmployeeID, Freight, OrderDate, OrderID, RequiredDate, ShippedDate, ShipVia) " +
                                 " VALUES ( \"{0}\" , \"{1}\" , \"{2}\" , \"{3}\" , \"{4}\" , \"{5}\" , \"{6}\" , \"{7}\"  ) ",
                                 obj.CustomerID,
                                 obj.EmployeeID,
                                 obj.Freight,
                                 obj.OrderDate,
                                 obj.OrderID,
                                 obj.RequiredDate,
                                 obj.ShippedDate,
                                 obj.ShipVia
                                 ));
        }
		protected override object FillRecord(object[] fields)
		{
			OrdersFixed record = new OrdersFixed();

			record.OrderID = (int) fields[0];
			record.CustomerID = (string) fields[1];
			record.EmployeeID = (int) fields[2];
			record.OrderDate = (DateTime) fields[3];
			record.RequiredDate = (DateTime) fields[4];
			if (fields[5] != DBNull.Value)
				record.ShippedDate = (DateTime) fields[5];
			else
				record.ShippedDate = DateTime.MinValue;
			record.ShipVia = (int) fields[6];
			record.Freight = (decimal) fields[7];

			return record;
		}
        protected override object FillRecord(object[] fields)
        {
            OrdersFixed record = new OrdersFixed();

            record.OrderID      = (int)fields[0];
            record.CustomerID   = (string)fields[1];
            record.EmployeeID   = (int)fields[2];
            record.OrderDate    = (DateTime)fields[3];
            record.RequiredDate = (DateTime)fields[4];
            if (fields[5] != DBNull.Value)
            {
                record.ShippedDate = (DateTime)fields[5];
            }
            else
            {
                record.ShippedDate = DateTime.MinValue;
            }
            record.ShipVia = (int)fields[6];
            record.Freight = (decimal)fields[7];

            return(record);
        }