Devart Forums

Code: Select all

        public void InsertLines(SmpWipmmtLinesVMeta data)
        {
            try
            {
                DateTime? db_date = db.GetDbSysDate();
                data.WmLineId = Convert.ToDecimal(db.GetWipmmtLinesNextval());
                data.WmHeaderId = this.hd_id;
                SmpWipmmtLinesTp dls = new SmpWipmmtLinesTp();
                copy_data(data, dls);
                db.SmpWipmmtLinesTps.InsertOnSubmit(dls);
                decimal i = 0;
                SmpWipmmtLinesTp target = db.SmpWipmmtLinesTps.Where(p => p.WmLineId == data.WmLineId).FirstOrDefault();
                if (target != null)  <-- why it is always null
                {
                    i = target.WmLineId;
                }
            }

Code: Select all

CREATE OR REPLACE TYPE HR.department_type AS OBJECT
(
  DNO NUMBER,
  NAME VARCHAR2(50),
  LOCATION VARCHAR2(50)
);

CREATE OR REPLACE TYPE HR.dept_array
AS TABLE OF DEPARTMENT_TYPE;


CREATE OR REPLACE PACKAGE HR.objecttype AS

 PROCEDURE insert_object (d dept_array);

END objecttype;
/
CREATE OR REPLACE PACKAGE BODY HR.objecttype
AS
   PROCEDURE insert_object (d dept_array)
   AS
   BEGIN
      FOR i IN d.FIRST .. d.LAST
      LOOP
         INSERT INTO department_teststruct
              VALUES (d (i).dno, d (i).name, d (i).location);
      END LOOP;
   END insert_object;
END objecttype;
/

Code: Select all

CREATE OR REPLACE PACKAGE PCK_TESTDEVART AS

TYPE t_reccord IS RECORD (some_id integer, some_string varchar2(10));
TYPE t_records IS TABLE OF t_reccord Index By Binary_Integer;

PROCEDURE sp05(
   in1 in integer,
   in2 in t_records,
   out1 out integer,
   out2 out t_records
);

FUNCTION func05(
   in1 in integer,
   in2 in t_records,
   out1 out integer,
   out2 out t_records
) return integer;

END PCK_TESTDEVART; 

Code: Select all

        public ActionResult Index()
        {
            using (myDataContext db = new myDataContext())
            {
                TestDlT dl = new TestDlT();
                dl.DlId = 1;
                dl.HdId = 1;
                dl.Seq = 1;
                dl.ItemId = 1;
                dl.Qty = 1;
                db.TestDlTs.InsertOnSubmit(dl);

                TestDlT dl2 = new TestDlT();
                dl2.DlId = 1;
                dl2.HdId = 1;
                dl2.Seq = 1;
                dl2.ItemId = 1;
                dl2.Qty = 1;
                db.TestDlTs.Attach(dl2);    // <--   Error
                db.TestDlTs.DeleteOnSubmit(dl2);

                db.SubmitChanges();
            }