Re: [Firebird-net-provider] how to change parameter prefix

[Jiri C. <di...@ci...>]

On 8/27/07, le...@po... <le...@po...> wrote:
> Hello,
>
> The problem seems to be not very frequent as I didn't find much one the
> Internet. It's really weird. The Oracle database provider is by
> microsoft:
> http://msdn2.microsoft.com/en-us/library/system.data.oracleclient.oraclecommand.parameters.aspx

It's magic, 'cause also unnamned params (?) are not supported. Looks
like some Cut'n'Paste implementation from another provider.

AFAIK Oracle has own provider on his site (I don't know differences
between framework's and "internal, but ...) - maybe it handles params
right.

> I couldn't find any nice workaround. May be someone had done some kind
> of wrapper that handle this? May be there is in Firebird provider some
> event handler that is triggered just before execution of statement? This
> way I could substitute the ':' with '@'?

Why do you need this? I don't think, that's a good idea to add to our
provider some magic code, to fix someones (oracle's) incompatibility.

Maybe you need something, that can be easily solved in another way.

BTW If you want to your application be able to work with oracle and FB
using same code and there's a problem with oracle-provider, why not to
use some constants and prefix params with it depending on selected
provider. It's not clear, it's not nice, but it solves problem.

> Regards.,
> ...michal
>
> Jiri Cincura pisze:
> > On 8/27/07, le...@po... <le...@po...> wrote:
> >> Hello,
> >> I need to have the C# .NET 2.0 application that could use both firebird
> >> and/or oracle as a database engine. What is the best way to hide the
> >> difference in parameter prefix? In firebird it is '@' in oracle it is
> >> ':' May be it is possible to explicitly set in firebird provider a
> >> prefix to ':'?
> >
> > For this time, it's hardcoded in provider code. The '@' character is
> > default fo ADO.NET classes, so if oracle is using another, it's weird.
> >
> > It's not long time ago, the fb .net provider supports also params
> > without '@' to better handle ASP.NET stuff. Carlos did it, look at
> > changelog. So maybe this is supported by oracle too.
> >
> > If you still want to chnage this character, you should look at
> > FbCommand, FbCommandBuilder and FbParameter classes. But I don't
> > think, it's a good idea, cause '@' is used on various places so
> > changing it can break something.
> >
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>


-- 
Jiri {x2} Cincura (Microsoft Student Partner)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com