postgresql
postgresql
Hi All,does anyone have experience with postgres and dapper?Juraj
postgresql
Hi Juraj,
for PG ask Johan Nel, i think he uses it from the beginning... IIRC, Wolfgang R. also has it in production for some time.
As for dapper, AFAIK, nobody has spoken here about it, sorry.
for PG ask Johan Nel, i think he uses it from the beginning... IIRC, Wolfgang R. also has it in production for some time.
As for dapper, AFAIK, nobody has spoken here about it, sorry.
Regards
Karl
(on Win8.1/64, Xide32 2.20, X#2.20.0.3)
Karl
(on Win8.1/64, Xide32 2.20, X#2.20.0.3)
postgresql
Hi Juraj,
as Karl said: I'm using it in production, from VO (through a self written COM wrapper), X# and PHP (we have some larger projects on it).
But for Dapper: I had to google it to understand what it is.
I prefer to have less possible dependences in my code, and I have written my own (thin) libraries that expose the same functionality for PG, MS SQL, MySQL, SQLite and Oracle.
Wolfgang
as Karl said: I'm using it in production, from VO (through a self written COM wrapper), X# and PHP (we have some larger projects on it).
But for Dapper: I had to google it to understand what it is.
I prefer to have less possible dependences in my code, and I have written my own (thin) libraries that expose the same functionality for PG, MS SQL, MySQL, SQLite and Oracle.
Wolfgang
Wolfgang Riedmann
Meran, South Tyrol, Italy
wolfgang@riedmann.it
https://www.riedmann.it - https://docs.xsharp.it
Meran, South Tyrol, Italy
wolfgang@riedmann.it
https://www.riedmann.it - https://docs.xsharp.it
postgresql
Hi Wolfgang,Thank you for your response. I need to start a project quickly with Postgresql database in local network (3-4 clients), so it would be very helpful for me to use some validated existing libraries to save time. I will be grateful for any help.Juraj
postgresql
Jurai,
you are aware of npgsql.org? This should let you work with pg from x# like any DBMS via ado.net.
@all: sorry for strange appeareance, can't hinder forum software from interfering with my text
you are aware of npgsql.org? This should let you work with pg from x# like any DBMS via ado.net.
@all: sorry for strange appeareance, can't hinder forum software from interfering with my text
- Attachments
-
- forum.PNG (22.82 KiB) Viewed 621 times
Regards
Karl
(on Win8.1/64, Xide32 2.20, X#2.20.0.3)
Karl
(on Win8.1/64, Xide32 2.20, X#2.20.0.3)
postgresql
Hi Juraj,
please give me a bit of time, and then I will publish my class library.
Basically I'm having a class called PGConnection with methods like :GetDataTable( cSelect ) and :ExecuteStatement( cStmt ) that does all the work. And there are helper classes to build insert and update statements.
All these classes I have are working the same manner for all the different SQL engines I need to use (the most used are MS SQL, PostgreSQL, SQLite and Oracle).
The beauty of .NET is that you don't need any configuration on the client machines, and therefore I have build COM libraries for my VO applications that do exactly that.
Wolfgang
please give me a bit of time, and then I will publish my class library.
Basically I'm having a class called PGConnection with methods like :GetDataTable( cSelect ) and :ExecuteStatement( cStmt ) that does all the work. And there are helper classes to build insert and update statements.
All these classes I have are working the same manner for all the different SQL engines I need to use (the most used are MS SQL, PostgreSQL, SQLite and Oracle).
The beauty of .NET is that you don't need any configuration on the client machines, and therefore I have build COM libraries for my VO applications that do exactly that.
Wolfgang
Wolfgang Riedmann
Meran, South Tyrol, Italy
wolfgang@riedmann.it
https://www.riedmann.it - https://docs.xsharp.it
Meran, South Tyrol, Italy
wolfgang@riedmann.it
https://www.riedmann.it - https://docs.xsharp.it
postgresql
Hi Juraj,
this is my code to get a .NET DataTable from a PostgreSQL database:
method GetDataTable( cSelect as string ) as DataTable
local oAdapter as NpgsqlDataAdapter
local oDataSet as DataSet
local oDataTable as DataTable
oDataTable := null_object
try
oAdapter := NpgsqlDataAdapter{ cSelect, self:Connection }
oDataSet := Dataset{}
oAdapter:Fill( oDataSet )
oDataTable := oDataSet:Tables[0]
oDataSet := null_object
catch oEx as Exception
_cLastError := oEx:Message
rdm.BaseLib.ErrorSys.InvokeExceptionHandler( oEx, cSelect )
rdm.BaseLib.ErrorSys.ProcessException( oEx )
end try
return oDataTable
Wolfgang
this is my code to get a .NET DataTable from a PostgreSQL database:
method GetDataTable( cSelect as string ) as DataTable
local oAdapter as NpgsqlDataAdapter
local oDataSet as DataSet
local oDataTable as DataTable
oDataTable := null_object
try
oAdapter := NpgsqlDataAdapter{ cSelect, self:Connection }
oDataSet := Dataset{}
oAdapter:Fill( oDataSet )
oDataTable := oDataSet:Tables[0]
oDataSet := null_object
catch oEx as Exception
_cLastError := oEx:Message
rdm.BaseLib.ErrorSys.InvokeExceptionHandler( oEx, cSelect )
rdm.BaseLib.ErrorSys.ProcessException( oEx )
end try
return oDataTable
Wolfgang
Wolfgang Riedmann
Meran, South Tyrol, Italy
wolfgang@riedmann.it
https://www.riedmann.it - https://docs.xsharp.it
Meran, South Tyrol, Italy
wolfgang@riedmann.it
https://www.riedmann.it - https://docs.xsharp.it
postgresql
We are using this. You can use the free Npgsql. But we used the paid Devart dotConnect for PostgreSQL.
postgresql
rjpajaron wrote:...But we used the paid Devart dotConnect for PostgreSQL.
Why? Just curious...
Regards
Karl
(on Win8.1/64, Xide32 2.20, X#2.20.0.3)
Karl
(on Win8.1/64, Xide32 2.20, X#2.20.0.3)
postgresql
It is more powerful and feature loaded. Key features that we use syncing data that Npgsql does not have.