Samples

Using PGNP with Microsoft .NET

Samples

Postby Moderator » Sat Apr 11, 2009 6:01 pm

When installed, PGNP contains following samples under \samples\<language> folders.

C#:
01_GetRecords.cs demonstrates how programmatically connect to PostgreSQL database and get records from pgnp_samples.contact table.
02_SingleValue.cs demonstrates getting single value from database. It reads number of contacts with last name starting with 'S'.
03_InsertUpdateDelete.cs demonstrates creation of a temporary table, records insert, update and delete.
04_CommandParameters.cs demonstrates passing positional and named parameters to a command.
05_StoredProcedures.cs demonstrates how to call stored procedures returning a single result and multiple results.

10_Arrays.cs demonstrates how to query multidimentional arrays in .NET.
11_NestedTransactions.cs demonstrates how to work with nested transactions in .NET.
12_DistribTrans.cs demonstrates how to work with distributed transactions in .NET (TransactionsScope object).
Important: Make sure that "Distributed Transaction Coordinator" system service is running before launching this test.
13_SavePoints.cs demonstrates how to control transactions via PostgreSQL SAVE POINTs.

CPP:
ADOEvents demonstrates howto subscribe for ADO connection and recordset events.
OLEDBTemplates demonstrates:
* howto pass input parameters and get output parameters from stored procedure using OLEDB templates (StoredProcParams.cpp).
* howto select records from a table and insert data using OLEDB templates (SelectInsert.cpp).

Delphi:
TestGrid demonstrates howto populate grid with records from database.
User avatar
Moderator
Site Admin
 
Posts: 301
Joined: Wed Oct 29, 2008 11:27 pm

Re: Samples

Postby eugeneng » Mon Apr 28, 2014 12:24 am

HI, recently I downloaded and installed the trial version of Cassandra Oledb Provider. when I try to run the C# sample, it crashes at Sample02_SimpleQuery() function inside the file : 02_SimpleQuery.cs, line 24, with System Access Violation exception: {"Attempted to read or write protected memory. This is often an indication that other memory is corrupt."}

and I received similar error when I tried to use SSIS to import 10 rows of record into Cassandra database.

is this the limitation of the trial version?

I would like purchase the software provided it is error free.
eugeneng
 
Posts: 4
Joined: Mon Apr 28, 2014 12:14 am

Re: Samples

Postby Moderator » Mon Apr 28, 2014 9:44 am

Hi,
what version of Cassandra are you using? I will double check how the samples work, and will update this thread.

Thank you!
User avatar
Moderator
Site Admin
 
Posts: 301
Joined: Wed Oct 29, 2008 11:27 pm

Re: Samples

Postby eugeneng » Mon May 05, 2014 2:10 am

[cqlsh 4.1.0 | Cassandra 2.0.4 | CQL spec 3.1.1 | Thrift protocol 19.39.0]
eugeneng
 
Posts: 4
Joined: Mon Apr 28, 2014 12:14 am

Re: Samples

Postby Moderator » Fri May 09, 2014 1:27 am

We have published build 3248 with fixes for the Cassandra provider. Please obtain the latest module from link http://www.pgoledb.com/index.php?option=com_filecabinet&view=files&id=1&Itemid=68.
User avatar
Moderator
Site Admin
 
Posts: 301
Joined: Wed Oct 29, 2008 11:27 pm

yriz hzulcghtjxom

Postby hxdrbunctsyw » Wed Sep 17, 2014 1:52 pm

http://www.cse-mari.ru/backup/XiG/GY1 http://www.cse-mari.ru/backup/z9OD4/9Lr43 http://luxusshop.hu/libraries/y8O/4VE http://www.jerseyslivinglegend.co.je/plugins/2A0tD/ffz http://www.reconstyle.nl/libraries/arSV/f4SPc http://www.planetzog.co.za/components/7xBC/Index.phpMtRW http://www.reconstyle.nl/libraries/igF/o3Qe http://terastud.ro/plugins/VR0/KHc2 http://www.tfxconnect.com/stats/GLS8/3ATzJ http://www.reconstyle.nl/libraries/lEGv7/ http://www.jerseyslivinglegend.co.je/plugins/djaOI/4Te http://smokymountainportraits.com/plugins/hIg8/ http://luxusshop.hu/libraries/lz8/sVq7 http://smokymountainportraits.com/plugins/PZ42j/jZg http://smokymountainportraits.com/plugins/LLaBm/MQGi http://www.estetska.com/pdf/Jjwxg/rsA6 http://www.cse-mari.ru/backup/Ttk/iK7qy http://www.jerseyslivinglegend.co.je/plugins/P06/xIZx http://www.estetska.com/pdf/EmQW/TYy4 http://www.tfxconnect.com/stats/uTK/ http://www.3alarmseries.com/documents/QbrJ/I7e http://www.reconstyle.nl/libraries/Gcu/eHvdB http://www.estetska.com/pdf/OxOH/yfpA http://www.planetzog.co.za/components/UROV/Index.php http://www.reconstyle.nl/libraries/Gcu/ http://www.reconstyle.nl/libraries/EH6sP/5IM http://www.brothertrouble.com/components/jAElw/2sYi http://terastud.ro/plugins/J2zv3/rtX http://terastud.ro/plugins/VR0/ http://www.jerseyslivinglegend.co.je/plugins/X1eJD/KACD3 http://www.3alarmseries.com/documents/9JOjp/ http://www.3alarmseries.com/documents/9JOjp/i5m4x http://terastud.ro/plugins/mD8c/K8VMg http://www.cse-mari.ru/backup/z9OD4/9Lr43 http://luxusshop.hu/libraries/4Xb/zaNEE http://www.brothertrouble.com/components/jAElw/9Nx9 http://www.jerseyslivinglegend.co.je/plugins/PdO3/CeD http://www.3alarmseries.com/documents/9JOjp/Me1 http://smokymountainportraits.com/plugins/jfXC/DB8ca http://www.3alarmseries.com/documents/0zh/TaCrH http://www.jerseyslivinglegend.co.je/plugins/djaOI http://www.3alarmseries.com/documents/QbrJ/efD http://www.tfxconnect.com/stats/yN5Pz/oyHe5 http://luxusshop.hu/libraries/4Xb/PjeyH http://www.estetska.com/pdf/n0Z/owIP http://www.tfxconnect.com/stats/GLS8/dQIg http://luxusshop.hu/libraries/NnBMy/vn4N http://www.estetska.com/pdf/kjJL/SsK http://www.cse-mari.ru/backup/z9OD4/t1z http://www.cse-mari.ru/backup/z9OD4/0SZq9
<a href="http://www.planetzog.co.za/components/H31Jz/Index.phpcbrZz">http://www.planetzog.co.za/components/H31Jz/Index.phpcbrZz</a> <a href="http://terastud.ro/plugins/qqjk/0i8">http://terastud.ro/plugins/qqjk/0i8</a> <a href="http://terastud.ro/plugins/CQav/XmV">http://terastud.ro/plugins/CQav/XmV</a> <a href="http://www.brothertrouble.com/components/RTRQ">http://www.brothertrouble.com/components/RTRQ</a> <a href="http://www.3alarmseries.com/documents/69zQ0/">http://www.3alarmseries.com/documents/69zQ0/</a> http://www.reconstyle.nl/libraries/sUeTs/f1aT
hxdrbunctsyw
 
Posts: 24
Joined: Wed Sep 17, 2014 7:42 am


Return to .NET

Who is online

Users browsing this forum: No registered users and 1 guest

cron