Modify DB Connection String


Is there a way to modify the database connection string when using the RADZEN Application / Data IDE?

I need to add "Convert Zero Datetime=true;" to the connection string of a MariaDB connection, to avoid NULL datetime errors.

I can add this on the deploy screen in RADZEN, or in Visual Studio, but do not see where I can include this when setting up a DataSource in RADZEN.

Another option may be to modify the SELECT query generated, or limit results, but I don't see how to do that either.

Any feedback is appreciated.

Perfect response from Eenchev below.
thank you

The connection string is appsettings.json - you can add your modifications and add the file to Radzen application ignore list. All queries are execute using EF methods - you might need to get familiar with Skip(), Take(), Where(), etc in Microsoft documentation.