Hi, Haven`t really thought about the ADO .NET specificatian actually (wasntme). The idea of using RWLS instead of Mutex is based on my current "coding style", since I was looking mostly at thread-proofing the FbConnection object itself(at lowest possible lvl, and maybe FbTransaction, but nothing more), and I don`t really > On Fri, Apr 16, 2010 at 18:18, Ivan Arabadzhiev > <intelru...@unrealsoft.net> wrote: >> Hi, >> I`ve asked before (and yes, I remember the provider is not thread safe), >> but I recently started using the 3.5 framework and was hit by a >> lightning. >> Could the FirebirdConnection object get a public "ReaderWriterLockSlim" >> member? It would be just about one line of code (definition ...), and >> would be sort of a workarround for anyone like me, who can wrap >> connection >> operations in try/catche/finally blocks. > > I don't know how the RWLockSlim relates to try/catch/finally. Anyway > having any kind of lock of anchor for locking isn't going to do thread > safe provider. The FbTransaction, FbCommand etc. have methods > operating with database, hence you can easily screw something up if > you don't do locking properly. And you can do the locking properly (in > fact it's more likely, than relying on part of client) if *you* do > yourself. Also take into account, that isn't adhere to ADO.NET design. > > BTW the RWLockSlim isn't good for this purpose, as in 99,999% cases > you need mutual exclusion (aka everybody is writer) because you don't > know (and shouldn't know) what's going on in lower layers. Also notice > how an application will scale if more threads will be using one > connection. It will be very bad. It's a similar story as thread vs. > threadpool and the solution is (un)surprisingly similar. > > On the other hand, you can grab sources and add the member yourself, > if you think you need it. >
-- Sanity is a sin! ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
