FirebirdSQL / NETProvider

Firebird ADO.NET Data Provider
https://www.firebirdsql.org/en/net-provider/
Other
152 stars 63 forks source link

How to set readonly access mode? #1089

Closed Rainson12 closed 1 year ago

Rainson12 commented 1 year ago

Hi, is there a way to set the access mode to readonly when setting up the connection while using up ef core? I can see that there is some method to set the accessMode for the FbConfigurationService (https://github.com/FirebirdSQL/NETProvider/blob/ebd58c427de8fcdc3c5b08541a450dc09831e023/src/FirebirdSql.Data.FirebirdClient/Services/FbConfiguration.cs#L616) but I am unable to access it when using ef dbcontext wiring?

cincuranet commented 1 year ago

Either the database is in RO mode, which you can set using the FbConfiguration or the you have RO transaction. There's nothing that relates to connection.

Rainson12 commented 1 year ago

thanks for pointing out. worked