Menu
▾
▴
Re: [Firebird-net-provider] Firebird-net-provider Digest, Vol 111, Issue 2
|
From: LtColRDSChauhan <rds...@gm...> - 2015-07-22 12:19:04
|
On Wed, Jul 22, 2015 at 12:08 PM, < fir...@li...> wrote: > Send Firebird-net-provider mailing list submissions to > fir...@li... > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > or, via email, send a message with subject or body 'help' to > fir...@li... > > You can reach the person managing the list at > fir...@li... > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Firebird-net-provider digest..." > > > Today's Topics: > > 1. Re: Future of .NET Provider (Ji?? ?in?ura) > 2. Read allowed despite locking table in transaction > (LtColRDSChauhan) > 3. Re: Read allowed despite locking table in transaction > (Ji?? ?in?ura) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Fri, 10 Jul 2015 08:05:14 +0000 > From: Ji?? ?in?ura <ji...@ci...> > Subject: Re: [Firebird-net-provider] Future of .NET Provider > To: "For users and developers of the Firebird .NET providers" > <fir...@li...> > Message-ID: <53b4e1e0ea5b46619e7aa74754b54c5e@S05-MBX03-22.S05.local> > Content-Type: text/plain; charset="utf-8" > > With the Firebird 3.0 Beta 2 release a few days ago, I would like to ask > when we could expect the .NET Provider working with it, also in combination > with Entity Framework (with support for new datatypes like > > Provider works with FB 3 (with legacy auth). With the new encryption etc. > I don?t have any ETA. Mark is doing the implementation in Java, so maybe > we?ll join forces. Without some investment from community it?s not going to > happen quickly. > > Boolean). > > The SQL boolean has slightly different NULL/Unknown logic than .NET null > (or any ?normal? NULL) and EF does not expect that. Although it?s not > difficult to add support, the logic in C# code is damn confusing. > > In that fashion, how about Entity Framework 7 - which will be released on > 20. July (with the new Visual Studio) - will it be supported in the near > future (including DDEX support for VS 2015)? > > http://tracker.firebirdsql.org/browse/DNET-609. Support for EF 7 is going > to happen after EF 6.2 will be out (because of Migrations). > > > -- > Mgr. Ji?? ?in?ura > Independent IT Specialist > > -------------- next part -------------- > An HTML attachment was scrubbed... > > ------------------------------ > > Message: 2 > Date: Tue, 21 Jul 2015 16:18:11 +0530 > From: LtColRDSChauhan <rds...@gm...> > Subject: [Firebird-net-provider] Read allowed despite locking table in > transaction > To: fir...@li... > Message-ID: > <CAMG8wxjpjHkQo5hjmHioQJ83HJLFoXQUFd=+ > fDO...@ma...> > Content-Type: text/plain; charset="utf-8" > > Hello, > > Earlier, by mistake I sent an incomplete mail on this issue. Apologies for > the same. > > 1. I want to lock a table then : > (a) read a record from this table and then > (b) write a record to this table. > 2. While I do the above, I want to disallow read and write to this table. > 3. The below mentioned code allows read while the transaction is in > progress. > > tx = con.BeginTransaction( > new FbTransactionOptions() { > TransactionBehavior = > FbTransactionBehavior.Consistency | FbTransactionBehavior.NoWait, > LockTables = new Dictionary<string > , FbTransactionBehavior> { > {lockTable1, > FbTransactionBehavior.Protected | FbTransactionBehavior.LockRead | > FbTransactionBehavior.Exclusive} > } > } > > 4. Environment : > (a) FirebirdSql.Data.FirebirdClient-4.6.4.0 > (b) Firebird-2.5.4.26856_0_Win32 > (c) .NET 4.5.2 > 5. Please help. > > Thanks and Regards, > Rajiv > -------------- next part -------------- > An HTML attachment was scrubbed... > > ------------------------------ > > Message: 3 > Date: Wed, 22 Jul 2015 06:38:02 +0000 > From: Ji?? ?in?ura <ji...@ci...> > Subject: Re: [Firebird-net-provider] Read allowed despite locking > table in transaction > To: "For users and developers of the Firebird .NET providers" > <fir...@li...> > Message-ID: <147af4d6c76445218f76bfca536ca9c4@S05-MBX03-22.S05.local> > Content-Type: text/plain; charset="utf-8" > > Don?t do that. Database engine (any) people do a great effort to reach > maximum throughput and you want to limit it to basically 1. If you need > someething like that, your design has serious flaw. > You are correct, designs (any) needing transactions are at the cost of throughput. In this case please help to point out the error in code. > -- > Mgr. Ji?? ?in?ura > Independent IT Specialist > > From: LtColRDSChauhan [mailto:rds...@gm...] > Sent: Tuesday, July 21, 2015 12:48 PM > To: fir...@li... > Subject: [Firebird-net-provider] Read allowed despite locking table in > transaction > > Hello, > > Earlier, by mistake I sent an incomplete mail on this issue. Apologies for > the same. > > 1. I want to lock a table then : > (a) read a record from this table and then > (b) write a record to this table. > 2. While I do the above, I want to disallow read and write to this table. > 3. The below mentioned code allows read while the transaction is in > progress. > > tx = con.BeginTransaction( > new FbTransactionOptions() { > TransactionBehavior = > FbTransactionBehavior.Consistency | FbTransactionBehavior.NoWait, > LockTables = new Dictionary<string, > FbTransactionBehavior> { > {lockTable1, > FbTransactionBehavior.Protected | FbTransactionBehavior.LockRead | > FbTransactionBehavior.Exclusive} > } > } > > 4. Environment : > (a) FirebirdSql.Data.FirebirdClient-4.6.4.0 > (b) Firebird-2.5.4.26856_0_Win32 > (c) .NET 4.5.2 > 5. Please help. > > Thanks and Regards, > Rajiv > -------------- next part -------------- > An HTML attachment was scrubbed... > > ------------------------------ > > > ------------------------------------------------------------------------------ > Don't Limit Your Business. Reach for the Cloud. > GigeNET's Cloud Solutions provide you with the tools and support that > you need to offload your IT needs and focus on growing your business. > Configured For All Businesses. Start Your Cloud Today. > https://www.gigenetcloud.com/ > > ------------------------------ > > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > > End of Firebird-net-provider Digest, Vol 111, Issue 2 > ***************************************************** > -- Regards, Lt Col (Retd) Rajiv D.S. Chauhan in.linkedin.com/in/ltcolrdschauhan _____________________________ |
