Example #1
0
            internal _FindResult_()
            {
                cms = Common.Utility.UseThreadLocalStream();
                NoTemplateCommand = PostgresCommandFactory.NewCommand(cms);

                this.RichFind    = PostgresCommandFactory.PreparedCommand(cms, "FS-Test-XYZ", @"SELECT _r FROM ""Test"".""XYZ_entity"" _r WHERE _r.""ID"" = $1", "int4");
                this.RichFindAll = PostgresCommandFactory.PreparedCommand(cms, "FM-Test-XYZ", @"SELECT _r FROM ""Test"".""XYZ_entity"" _r WHERE _r.""ID"" = ANY($1)", "int4[]");
            }
Example #2
0
            internal _FindResult_()
            {
                cms = Common.Utility.UseThreadLocalStream();
                NoTemplateCommand = PostgresCommandFactory.NewCommand(cms);

                this.RichFind    = PostgresCommandFactory.PreparedCommand(cms, "FS-FormABC-Input", @"SELECT _r FROM ""FormABC"".""Input_entity"" _r WHERE _r.""ID"" = $1", "uuid");
                this.RichFindAll = PostgresCommandFactory.PreparedCommand(cms, "FM-FormABC-Input", @"SELECT _r FROM ""FormABC"".""Input_entity"" _r WHERE _r.""ID"" = ANY($1)", "uuid[]");
            }
            internal _FindResult_()
            {
                cms = Common.Utility.UseThreadLocalStream();
                NoTemplateCommand = PostgresCommandFactory.NewCommand(cms);

                this.RichFind    = PostgresCommandFactory.PreparedCommand(cms, "FS-UseCase1-Submission", @"SELECT _r FROM ""UseCase1"".""Submission_entity"" _r WHERE _r.""ID"" = $1", "uuid");
                this.RichFindAll = PostgresCommandFactory.PreparedCommand(cms, "FM-UseCase1-Submission", @"SELECT _r FROM ""UseCase1"".""Submission_entity"" _r WHERE _r.""ID"" = ANY($1)", "uuid[]");
            }