Re: [Firebird-net-provider] EF handling - as string parameter

[Nikolaus K. <par...@gm...>]

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:ji...@ci...] 
Gesendet: Dienstag, 2. Mai 2017 10:02
An: fir...@li...
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:ji...@ci...]
> Gesendet: Dienstag, 2. Mai 2017 09:43
> An: fir...@li...
> 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
> Fir...@li...
> 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
> Fir...@li...
> 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
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider