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.
Macros in dotConnect for PostgreSql
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Macros in dotConnect for PostgreSql
dotConnect for PostgreSQL does not support macros, and unfortunately adding macros support isn't on our to do list.
Re: Macros in dotConnect for PostgreSql
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?
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?
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Macros in dotConnect for PostgreSql
Macros are supported in dotConnect Universal only. For more information, please refer to https://www.devart.com/dotconnect/unive ... niSQL.htmlchris901 wrote:Am i correct that this also means Macro-Support isn't available in any of your dotConnect suites, or is this PostgreSql specific?
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