Devart Forums

Code: Select all

CREATE OR REPLACE FUNCTION sp_log_select(p_id integer)  RETURNS SETOF log AS
$BODY$ 

DECLARE   row log%rowtype ;

BEGIN
	FOR row IN 
	SELECT * FROM "log" 
	WHERE ((id=p_id) or (p_id is null))
	LOOP  RETURN NEXT row;
	END LOOP;
END

$BODY$
  LANGUAGE 'plpgsql' VOLATILE

Code: Select all

            InvoiceDataContext.InvoiceDataContext db = new InvoiceDataContext.InvoiceDataContext(_innerConnection);
            db.Log = Console.Out;
            System.Linq.IQueryable result = db.SpLogSelect(null);  

            //set -> Binding source
            bsSearch.DataSource = result;

Code: Select all

      using (DataContext1.DataContext1 db = new DataContext1.DataContext1()) {
        var q = db.Getsetofdept().ToList();
      }

Code: Select all

CREATE TABLE fakt_test
(
  id bigserial NOT NULL,
  customerid integer,
  sellerid integer,
  doctype character varying(15),
  referenc integer DEFAULT 0,
  shiptoid integer DEFAULT 0,
  daterecord timestamp without time zone DEFAULT now(),
  dateissue timestamp(0) without time zone DEFAULT now(),
  ptermsid integer,
  CONSTRAINT fakttestpk876876 PRIMARY KEY (id)
)
WITH (OIDS=FALSE);

Code: Select all

CREATE OR REPLACE FUNCTION sp_fakt_select_test() RETURNS SETOF fakt_test AS
$BODY$ 

DECLARE 
row fakt_test%rowtype ;

BEGIN
FOR wiersz IN  SELECT * FROM fakt_test ORDER BY id
LOOP RETURN NEXT row;
END LOOP;

END
$BODY$
LANGUAGE 'plpgsql' VOLATILE

Code: Select all

db.Log = Console.Out;
IQueryable result = db.SpFaktSelectTest();
fsBindingSource.DataSource = result;

Code: Select all

SELECT t1.Id AS "Id", t1.Customerid AS "Customerid", t1.Sellerid AS "Sellerid", t1.Doctype AS "Doctype", t1.Referenc AS "Referenc", t1.Shiptoid AS "Shiptoid", t1.Daterecord AS "Daterecord", t1.Dateissue AS "Dateissue", t1.Ptermsid AS "Ptermsid"
FROM public.sp_fakt_select_test() t1