CollectionName,NumberOfRestrictions,NumberOfIdentifierParts,Data,Function MetaDataCollections,0,0,Table,Function Restrictions,0,0,Table,Function Databases,1,1,Function,Function Tables,4,3,Function,Function Columns,4,4,Function,Function Views,3,3,Function,Function Users,1,1,Function,Function Indexes,4,4,Function,Function IndexColumns,5,5,Function,Function
AdoDotNet.DataSource("Npgsql", "Server=redacted;Port=5432;User Id=redacted;Password=redacted;Database=redacted")
No, Npgsql doesn't come with a SQL parser - its job is only to take the SQL strings you provide it and send that to PostgreSQL. Parsing SQL is quite a complicated task as you've found out, especially if you start taking into accounts database-specific dialects...
I totally understand. I've kinda shelved that "side project" (parsing SQL statements) for now since I can't seem to get anything working correctly with ANTLR and I'm just having my application recreate the SQL statement completely instead of trying to manipulate its individual components.
That being said, for what I'm doing - extracting/parsing the SQL statement from a Crystal Reports document, updating one or more clauses, then push the modified SQL back into the document before the final report is generated/printed - it would still be nice to instead "simply" be able to access and modify that parse tree with the tools I'm already using (instead of banging my head against the ANTLR wall). As I said, I fully realize this is a fairly "one-off" type of usage situation in the grand scheme of things and there are other, "brute-force" methods of accomplishing the same goals.
I have app witch configured as <TargetFrameworks>net472;netcoreapp3.1</TargetFrameworks>
I use Npgsql 4.*(try any vertions) for work with DB
INSERT\UPDATE worked fine, but when I try use bulk operation then on start app under net472 have this exception
Have any some advise?
55000: prepared transactions are disabledbut i don't want enable prepared transactions
Hello guys, I am aware NpSQL is shipped with Power BI. sadly this is only the 4.0.1 version of NpgSQL, where I need the newer 4.1.x version in order to support
FOREIGN TABLEs. The MS documentation shows it takes the CAG installed NpSQL. I tried to install this through the given MSI and checking CAG installation, however I still do not seem to get the correct tables.
Does anybody know if Power BI can be supported with NpgSQL 4.1.x?