Macros in dotConnect for PostgreSql

Macros in dotConnect for PostgreSql

Postby chris901 » Sun 07 Aug 2016 17:35

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/CodeExamples/Berlin/en/FireDAC.TFDQuery.Macros_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.
chris901
 
Posts: 64
Joined: Wed 20 Jul 2016 04:21

Re: Macros in dotConnect for PostgreSql

Postby Pinturiccio » Tue 09 Aug 2016 16:00

dotConnect for PostgreSQL does not support macros, and unfortunately adding macros support isn't on our to do list.
Pinturiccio
Devart Team
 
Posts: 1982
Joined: Wed 02 Nov 2011 09:44

Re: Macros in dotConnect for PostgreSql

Postby chris901 » Tue 09 Aug 2016 16:17

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
 
Posts: 64
Joined: Wed 20 Jul 2016 04:21

Re: Macros in dotConnect for PostgreSql

Postby Pinturiccio » Thu 11 Aug 2016 14:13

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/universal/docs/UniSQL.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/universal/editions.html
http://www.devart.com/dotconnect/postgresql/editions.html
Pinturiccio
Devart Team
 
Posts: 1982
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for PostgreSQL