con.SubmitChanges();
Column def:
Code: Select all
ALTER TABLE tbl ADD COLUMN id integer;
ALTER TABLE tbl ALTER COLUMN id SET STORAGE PLAIN;
ALTER TABLE tbl ALTER COLUMN id SET NOT NULL;ALTER TABLE tbl ALTER COLUMN id SET DEFAULT nextval('tbl_id_seq'::regclass);
Code: Select all
INSERT INTO public.tbl (data, name) VALUES (:p1, :p2) RETURNING id
-- p1: Input Int (Size = 0; DbType = Int32) [1]
-- p2: Input Text (Size = 1; DbType = AnsiString) [A]
-- ret1: Output Int (Size = 0; DbType = Int32) []
-- Context: Devart.Data.PostgreSql.Linq.Provider.PgSqlDataProvider Model: MetaModel Build: 4.0.29.0
InnerException {"Parameter name is missing.\r\nparametaer name: ret1"}