[Firebird-net-provider] Connecting to encrypted databases

2017-07-12 Thread Jiří Činčura
Hi *, thanks to IBPhoenix I have an plugin (http://www.ibphoenix.com/products/software/encryptionplugin) to create encrypted database and I have a working prototype for passing the key. Now the question of the day. :) How to pass the key? The two obvious options are in connection string and

Re: [Firebird-net-provider] Connecting to encrypted databases

2017-07-12 Thread Gerdus van Zyl
I think it makes more sense on the connection string. It already contains sensitive info (username,password) and needing to provide connection related info by another method would be counter intuitive. On 12 July 2017 at 08:55, Jiří Činčura wrote: > Hi *, > > thanks to

Re: [Firebird-net-provider] Connecting to encrypted databases

2017-07-12 Thread Jiří Činčura
> What about a callback on Connection that returns a Connection Info > (ConnectionStringBuilder-like) object. > Could also add a connection constructor overload that accepts a > Connection > Info object. > Can then provide all connection data in one place with convenience of not > converting

Re: [Firebird-net-provider] Connecting to encrypted databases

2017-07-12 Thread Gerdus van Zyl
What about a callback on Connection that returns a Connection Info (ConnectionStringBuilder-like) object. Could also add a connection constructor overload that accepts a Connection Info object. Can then provide all connection data in one place with convenience of not converting from/to a string.

Re: [Firebird-net-provider] Connecting to encrypted databases

2017-07-12 Thread Jiří Činčura
> Binary data should be able to be represented with hexadecimal. And, Good point. > We are looking at implementing our own encryption plugin, but still > undecided how the key will be passed, since our application uses a mix > of Delphi(IBDAC) and C#(EF6). Our initial thought is that it will

Re: [Firebird-net-provider] Connecting to encrypted databases

2017-07-12 Thread Gerdus van Zyl
Not exactly sure what you mean with right away. The reason to not use the existing ConnectionStringBuilder is that it is implicit that it can be converted to a string. Which would not be true anymore, except if you add EncryptionKey to connection string parsing anyway. On 12 July 2017 at 13:51,

Re: [Firebird-net-provider] Connecting to encrypted databases

2017-07-12 Thread Jiří Činčura
> Which would not be true anymore, except if you add EncryptionKey to > connection string parsing anyway. Of course I would. The builder and connection string options are in sync. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/

Re: [Firebird-net-provider] Connecting to encrypted databases

2017-07-12 Thread Daniel Rail
Hi, At July 12, 2017, 5:44 AM, Jiří Činčura wrote: >> I think it makes more sense on the connection string. It already contains >> sensitive info (username,password) and needing to provide connection >> related info by another method would be counter intuitive. > Good point. > In my thinking I

[Firebird-net-provider] Global event on connection open

2017-07-12 Thread Jiří Činčura
Hi *, I had a conversation with long time Firebird user. They I'd like to see very easy feature - global event that fires when some FbConnection is opened. The motivation is that sometimes there's some connection being opened from weird or wrong place and this would allow to hunt it down. What