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.