SimplySql icon indicating copy to clipboard operation
SimplySql copied to clipboard

Add mysql advanced options

Open tocano33 opened this issue 6 years ago • 3 comments

Added a hashtable parameter to the 'default' ParameterSet for those that don't make an actual string ConnectionString, to make it easier for them to specify various connection options

tocano33 avatar Aug 18 '19 22:08 tocano33

@tocano33 I like the idea -- however, I would like to make this standard across all the providers currently in SimplySql -- would you be willing to extend this work to the SQLite, MSSQL, PostGres and Oracle providers?

mithrandyr avatar Aug 19 '19 13:08 mithrandyr

I'm willing to look into it but dont know if those providers handle additional options in the same way.

On Mon, Aug 19, 2019, 09:23 Mithrandyr [email protected] wrote:

@tocano33 https://github.com/tocano33 I like the idea -- however, I would like to make this standard across all the providers currently in SimplySql -- would you be willing to extend this work to the SQLite, MSSQL, PostGres and Oracle providers?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/mithrandyr/SimplySql/pull/20?email_source=notifications&email_token=ACTZABGGGCKX5D6PD2HCOLDQFKNDPA5CNFSM4IMUJZRKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD4S5H6A#issuecomment-522572792, or mute the thread https://github.com/notifications/unsubscribe-auth/ACTZABFKRARQHOZSBFCIUTDQFKNDPANCNFSM4IMUJZRA .

tocano33 avatar Aug 19 '19 13:08 tocano33

@tocano33 PostGres (NPGSQL) --> https://www.npgsql.org/doc/api/Npgsql.NpgsqlConnectionStringBuilder.html Oracle --> https://docs.oracle.com/en/database/oracle/oracle-database/12.2/odpnt/featConnecting.html#GUID-BCF2F215-C25F-403C-8D18-B03A69BC7104 SQLite --> https://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki MSSQL --> https://docs.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlconnectionstringbuilder?view=netframework-4.7.2

You should be able to use the same pattern in the other provider files that you have in the MySQL one...

mithrandyr avatar Aug 19 '19 16:08 mithrandyr