RE: [Firebird-net-provider] Re: How to CREATE DATABASE using .Net FB Provider

[Mike S. <mi...@mi...>]

Hi Carlos

Yes, I already tried it with ExecuteNonQuery() :-)

This is where it should be, as it doesn't return a cursor - ExecuteReader()
implies something else.

Yes, ExecuteScript is a great idea, as it means that the Firebird Provider
becomes a "one-stop-solution" for anything you need to do with Firebird. I
don't want to have to use a separate tool to manage DBs, because I need to
code it into the unit tests and into the final application.

You'll have to do something like SET TERM so that you can change the
terminator as required. In which case, you'll need to parse the SQL properly
so that you can ignore SET TERM inside quotes and comments.

I'd strongly recommend using SET TERM because this is the standard for
scripts, and we can take a script from IBObjects, ISQL or whatever, and run
it unchanged using the provider - cool!

Mike.

-----Original Message-----
From: fir...@li...
[mailto:fir...@li...]On Behalf Of
Carlos Guzman Alvarez
Sent: 11 April 2003 15:17
To: mi...@mi...
Cc: Firebird .Net Provider
Subject: Re: [Firebird-net-provider] Re: How to CREATE DATABASE using
.Net FB Provider


Hello:

> I don't think it's a good idea to have "magic values" in the source code -
> in this case ';'. It's much more flexible if the user of the class can
> change it.
>
> If it was a property before, then I wouldn't have had any problem with
> creating a stored proc :-)

With latest CVS sources you can do it using ExecuteNonQuery method ( now
that you have it you can try by yourself :) ).

I'm thinking in add an ExecuteScript method to FbCommand for version
1.1, any thoughts ???







--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.



-------------------------------------------------------
This SF.net email is sponsored by: Etnus, makers of TotalView, The debugger
for complex code. Debugging C/C++ programs can leave you feeling lost and
disoriented. TotalView can help you find your way. Available on major UNIX
and Linux platforms. Try it free. www.etnus.com
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider