Devart Forums

Hello,

i am migrating a Delphi Application written with FireDac to C#.

I don't know how familiar you are with FireDac but the application makes heavy use of Macros:
http://docwiki.embarcadero.com/CodeExam ... ros_Sample

In your documentations i found this page:
https://www.devart.com/odac/docs/?work_macros.htm

However this sadly doesn't apply to dotConnect for PostgreSql.

I am wondering how to make use of Macros and insert raw values in my command statements.

Thanks.

dotConnect for PostgreSQL does not support macros, and unfortunately adding macros support isn't on our to do list.

Macros are quite nice when it comes to inserting raw values in a parameterized sql statement. But I guess parameters cover over 90% of the standard tasks.

Sad to hear it is not on your to-do-list, but maybe you can add it on your roadmap in the near future .

Am i correct that this also means Macro-Support isn't available in any of your dotConnect suites, or is this PostgreSql specific?

chris901 wrote:Am i correct that this also means Macro-Support isn't available in any of your dotConnect suites, or is this PostgreSql specific?

Macros are supported in dotConnect Universal only. For more information, please refer to https://www.devart.com/dotconnect/unive ... niSQL.html

dotConnect Universal can work with PostgreSQL database via dotConnect for PostgreSQL. dotConnect Universal Professional Edition supports the runtime functionality of the Standard Edition of the dotConnect for Oracle, dotConnect for MySQL, dotConnect for SQLite and dotConnect for PostgreSQL data providers and allows using general ADO.NET functionality only.

dotConnect for PostgreSQL Professional Edition includes support for a set of advanced and PostgreSQL-specific features, which are not available in dotConnect Universal. In particular, dotConnect for PostgreSQL Professional Edition supports ORMs (Entity Framework and LinqConnect), whereas dotConnect Universal does not.

You can compare the features of these providers at:
http://www.devart.com/dotconnect/univer ... tions.html
http://www.devart.com/dotconnect/postgr ... tions.html