[Firebird-net-provider] Where can I learn more about FbConnection.ClearAllPools

2007-08-01 Thread Bryan Pendleton
I was looking at the FbConnection documentation and I saw a bit about the ClearAllPools method: http://www.firebirdsql.org/dotnetfirebird/documentation/api/1.7/FirebirdSql.Data.Firebird.FbConnection.ClearAllPools.html Is there any more information available about this method, such as: - when I w

Re: [Firebird-net-provider] FB and VS 2008

2007-08-01 Thread Carlos Guzmán Álvarez
Hello: > Somebody knows if the System.Data.Entity.dll assembly should come with > the Orcas beta 2 installation ?? Looks like all entity framework stuff got out of the beta 2 ( sic ) - This SF.net email is sponsored by: Spl

Re: [Firebird-net-provider] FB and VS 2008

2007-08-01 Thread Carlos Guzmán Álvarez
Hello: > Ya, that's the easy part ... Implementing and adapting the SQL generator was > a pain in the butt, as will be adjusting the XML files that provide LINQ > with information on builtin functions, datatypes, conversions, etc. Somebody knows if the System.Data.Entity.dll assembly should come

Re: [Firebird-net-provider] FB and VS 2008

2007-08-01 Thread Robert Simpson
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > On Behalf Of Carlos Guzmán Álvarez > Sent: Wednesday, August 01, 2007 9:35 AM > To: firebird-net-provider@lists.sourceforge.net; Robert Simpson > Cc: 'For users and developers of the Firebird .NET providers' > Su

Re: [Firebird-net-provider] FB and VS 2008

2007-08-01 Thread Carlos Guzmán Álvarez
Hello: > Carlos, you'll be wanting the Resources.zip file from here: > > http://blogs.msdn.com/adonet/archive/2007/03/16/ado-net-orcas-sample-provide > r.aspx Thanks very much for the information :D > Inside is an OrcasProvider.exe which is a self-extracting executable > containing a simple LIN

Re: [Firebird-net-provider] Concurrency control

2007-08-01 Thread Madhu Sasidhar, MD
One option is to use "SELECT FOR UPDATE WITH LOCK" ...if a second thread attempts to obtain a LOCK, it will throw an exception. This is ideal if you are only editing one row at a time. You have to think about "dead clients" though. If a client loses connection, the row is locked till the server det

Re: [Firebird-net-provider] FB and VS 2008

2007-08-01 Thread Robert Simpson
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > On Behalf Of Carlos Guzmán Álvarez > Sent: Wednesday, August 01, 2007 8:30 AM > To: firebird-net-provider@lists.sourceforge.net > Subject: Re: [Firebird-net-provider] FB and VS 2008 > > Hello: > > > This seems

[Firebird-net-provider] Concurrency control

2007-08-01 Thread Kevin Donn
I could use a bit of help deciding how best to use transactions in a particular case. I've used transactions quite a bit before, but my goal has always been simply to be able to commit or rollback groups of changes. In my current case, I've got to worry about concurrent access. I expect my as

Re: [Firebird-net-provider] FB and VS 2008

2007-08-01 Thread Carlos Guzmán Álvarez
Hello: > This seems like a good start: > http://blogs.msdn.com/kevin_halverson/archive/2007/07/10/how-to-implement-iq > ueryable.aspx Looks great, thanks very much !! > > It's VB but shouldn't be hard to translate :-) Agreed.