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

[Carlos G. A. <car...@te...>]

Hello:

> All of the Interbase/Firebird connectivity components that I've used in the
> past have supported SET TERM, and could also execute what I assumed to be a
> DSQL script.
> 
> Are you saying that these components must have interpreted the scripts
> locally and made specific calls to Interbase?

I can't tell you how they made because i can't see the sources, but 
yesterday i'm seeing IBConsole ( it's and application and not interface 
component but how i now that ibconsole allow to exec isql commands i see 
this ) sources of Firebird CVS and as i see (i don't see it in deep ) 
this made a parsing of the command.


> What I want to do is have a complete script that creates my database and
> sets up all the tables, stored procs, etc. so that I can run this either in
> a tool such as IBExpert, or directly in my application both for unit testing
> (current unit tests create the database fresh each run) and for
> installation.
> 
> Do you foresee a way of doing this with the .Net provider?

Well you can make a little class for parse the script file and exec each 
command individually, i think it's not difficult task to do :)



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

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