Re[2]: [Firebird-net-provider] Question: Why must I have a transactionobject supplied for command object=?koi8-r?Q?=3F?=

[Ivan - <pre...@bk...>]

> > Related to this question, I'm downloading the mono C#
> > compiler tools, but I wondered how (and perhaps why
> > not) I might build the source for the .NET provider
> > within VS.NET2003?  I want to pull out the exception
> > throw when transaction is found to be null - I don't
> > quite understand any reason the transaction is always
> > required.
> 
> The transaction is always required beacuse Firbird requires it always 
> :), i can modify the provider for "solve" this ?? yes, i like this ?? in 
> first place no :), if you start always a transaction your code will work 
> with both Firebird and SQL Server ( and other too ).

I am using VS.NET 2002. It compiles sources of FB.NET provider pretty good. Just add all the source files of provider (all files with .cs extension from "source" folder and subfolders) to your c# code, and that's all.
You can't just pull out the exception when transaction==null, because each statement in firebird server requires a valid transaction (This requirement sounds really unusual on "select" statements, but in firebird or interbase you can select from stored procedure, which updates data). But you can add code that checks transaction, and if it's null, then start new transaction and commit it after executing statement.