Subject | Re: Really Newbie Question |
---|---|
Author | Will Freeman |
Post date | 2005-02-28T17:17:50Z |
Thanks much for the info. I was trying to write this using ODBC
drivers so that the program could easily accommodate other databases,
but the .NET provider goes Ok along that direction too. Thanks again
... for the book and all the years of work.
Will.
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:
drivers so that the program could easily accommodate other databases,
but the .NET provider goes Ok along that direction too. Thanks again
... for the book and all the years of work.
Will.
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:
> At 01:51 AM 28/02/2005 +0000, you wrote:interfaces is
>
>
>
> >Hello All,
> > I am a long time programmer, but not a database programmer. I am
> >using Firebird and have had good success acquiring data with standard
> >SELECT queries in .NET using the ODBC drivers and the .NET provider.
>
> Why both? It sounds as though you are in urgent need of the
> firebird-net-provider list wisdom. :-)
>
> >But I wanted to really manage Firebird databases so I bought "The
> >Firebird Book" (Great Book!!) and "Mastering SQL".
>
> Good. That's the database and the query language taken care of.
>
> >But am at a
> >complete loss as to how to implement the SQL code inside a RAD
> >environment.
>
> *Which* RAD environment? Just about everything that Firebird
> "a RAD environment" of some sort. I guess you could say it goesfrom IBPP
> at one end - tidy C++ wrappers around all the API functions - to thefar
> extreme - IB Objects in Delphi or C++Builder envronments, witheverything
> itchy well hidden from you.looping
>
> >Should I be storing the code as stored procedures and
> >calling those,
>
> When the choice is between passing a lot of data across the wire,
> through it on the client, and then stuffing it all back across thewire,
> then executable SPs are a brilliant alternative. (I wouldn't livewithout
> 'em!) But some people get carried away and write SPs for every lastdumb down
> thing. Now that is what I call "daft".
>
> >implementing the code directly using something like a
> >CommandBuilder,
>
> I don't know "a CommandBuilder"...there are products around that
> the interface between the end user and the database and let you dosuggest
> relatively simple stuff...if efficient programming is your aim, I'd
> leaving those for the birds. Au contraire, it's worth theinvestment of
> your personal R & D time to get fully in touch with the capabilitiesof the
> engine and to experiment with development tools till you find somethingappreciated.
> that satisfies you.
>
> >or something else??? I am not looking for anyone to
> >give me a tutorial, just a swift nudge in the right direction, so I am
> >not spinning my wheels. Any links to examples of implementing SQL
> >code this way (or a good book on the topic), would be greatly
>visit to
> There are too many to enumerate here in the support list. Pay a
> the Downloads>Contributed section at www.ibphoenix.com. The linksto the
> various language interface selections are all there. Also check outthe
> list forums - around the community there are lists for just about everyseems to
> interface (although poor old non.NET VB is a hungry cousin...VB
> have trouble wetting its toes outside the Microsoft wading pool). Ifbe. It
> you're a .NET chap, the net provider list will be a good place to
> also has its own devel section on the main Firebird website, atlinks for
> http://www.firebirdsql.org/index.php?op=devel&sub=netprovider -
> docs and examples at the top of the green sidemenui.
>
> ./hb