Hello Jiri, thanks for the response.
I guess I am missing something here. The code below produces the same error as {0}. ppaQuery = "SELECT * FROM LPP_PRODUKTIONSAUFTRAEGE WHERE PRODUKTIONSSTATUS NOT IN ('Abgeschlossen','Storno') AND AUSLASTUNG_GEHOERT_ZU = @p0 ORDER BY PRODUKTIONSAUFTRAG_ID"; tmpPPA = this._ctx.LPP_PRODUKTIONSAUFTRAEGE.SqlQuery(ppaQuery, new object[]{this.CurrentHalle}).ToList(); If I copy the query to the SQL tool and execute the query it works fine (even when it does not return a record, which is also the case in other working queries). SELECT * FROM LPP_PRODUKTIONSAUFTRAEGE WHERE PRODUKTIONSSTATUS NOT IN ('Abgeschlossen','Storno') AND AUSLASTUNG_GEHOERT_ZU = 'Halle 6 - Schlosserei' ORDER BY PRODUKTIONSAUFTRAG_ID Do you have an idea whats missing? Thanks Niko -----Ursprüngliche Nachricht----- Von: Jiří Činčura [mailto:j...@cincura.net] Gesendet: Dienstag, 2. Mai 2017 10:02 An: firebird-net-provider@lists.sourceforge.net Betreff: Re: [Firebird-net-provider] EF handling - as string parameter You should use @p0 instead of {0} (https://msdn.microsoft.com/en-us/library/system.data.entity.dbset.sqlquery%28v=vs.113%29.aspx). Optionally you can also specify the Size in FbParameter. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Tue, May 2, 2017, at 09:58, Nikolaus Kern wrote: > Hi, > > I just saw that the query and the execution do not match correct. This > is the query with the parameter that creates an exception if the > parameter is "Halle 6 - Schlosserei". > > ppaQuery = "SELECT * FROM LPP_PRODUKTIONSAUFTRAEGE WHERE > PRODUKTIONSSTATUS NOT IN ('Abgeschlossen','Storno') AND > AUSLASTUNG_GEHOERT_ZU = {0} ORDER BY PRODUKTIONSAUFTRAG_ID"; tmpPPA = > this._ctx.LPP_PRODUKTIONSAUFTRAEGE.SqlQuery(ppaQuery, > this.CurrentHalle).ToList(); > > Niko > > -----Ursprüngliche Nachricht----- > Von: Jiří Činčura [mailto:j...@cincura.net] > Gesendet: Dienstag, 2. Mai 2017 09:43 > An: firebird-net-provider@lists.sourceforge.net > Betreff: Re: [Firebird-net-provider] EF handling - as string parameter > > What parameter? I don't see any parameter in the query. > > -- > Mgr. Jiří Činčura > https://www.tabsoverspaces.com/ > > > ---------------------------------------------------------------------- > -------- Check out the vibrant tech community on one of the world's > most engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > > ---------------------------------------------------------------------- > -------- Check out the vibrant tech community on one of the world's > most engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider