On Wed, Jul 22, 2015 at 12:08 PM, <
firebird-net-provider-requ...@lists.sourceforge.net> wrote:
> Send Firebird-net-provider mailing list submissions to
> firebird-net-provider@lists.sourceforge.net
>
> 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
> firebird-net-provider-requ...@lists.sourceforge.net
>
> You can reach the person managing the list at
> firebird-net-provider-ow...@lists.sourceforge.net
>
> 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 <j...@cincura.net>
> Subject: Re: [Firebird-net-provider] Future of .NET Provider
> To: "For users and developers of the Firebird .NET providers"
> <firebird-net-provider@lists.sourceforge.net>
> 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 <rdsc1...@gmail.com>
> Subject: [Firebird-net-provider] Read allowed despite locking table in
> transaction
> To: firebird-net-provider@lists.sourceforge.net
> Message-ID:
> <CAMG8wxjpjHkQo5hjmHioQJ83HJLFoXQUFd=+
> fdojyax-bgu...@mail.gmail.com>
> 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 <j...@cincura.net>
> Subject: Re: [Firebird-net-provider] Read allowed despite locking
> table in transaction
> To: "For users and developers of the Firebird .NET providers"
> <firebird-net-provider@lists.sourceforge.net>
> 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:rdsc1...@gmail.com]
> Sent: Tuesday, July 21, 2015 12:48 PM
> To: firebird-net-provider@lists.sourceforge.net
> 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
> Firebird-net-provider@lists.sourceforge.net
> 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
_____________________________
------------------------------------------------------------------------------
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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
