dotConnect for PostgreSQL Documentation
In This Topic
    Samples Overview
    In This Topic

    dotConnect for PostgreSQL samples are divided into 6 categories: General demos, Entity Framework samples, LinqConnect samples, Web demos, Web Service sample, and CRM demo project. You can open all of them from the Start menu group. The General samples demonstrate how to work with components, classes, technologies, and also the usage of individual data access features, Web samples show how to use dotConnect for PostgreSQL in ASP.NET environment, and the CRM demo shows some good design and implementation practices that you can employ with dotConnect for PostgreSQL.

    Note: in the Standard, Mobile, and Express editions of dotConnect for PostgreSQL some samples are not available.

    General Samples

    General samples are demos that demonstrate working with dotConnect for PostgreSQL classes, components, and technologies.

    Use the Start menu group to open General samples in the language you prefer. You can also run the compiled binary, which incorporates all General samples and provides quick access to C# source, necessary SQL scripts, and run-time state.

    Sample Description
    Crystal This sample project demonstrates using dotConnect for PostgreSQL for generating reports with Crystal Reports. Be aware that this project requires Crystal Reports, which is no longer included with Visual Studio 2010 and higher. You have to download and install Crystal Reports separately: http://scn.sap.com/docs/DOC-7824 . Then update references to the CrystalDecisions.* assemblies and rebuild the solution.
    DataReader This sample project demonstrates using PgSqlDataReader class to obtain data from a query. The sample executes SQL statement at the PgSqlCommand and gets PgSqlDataReader to retrieve data.
    DataSet This sample project demonstrates using untyped dataset with dotConnect for PostgreSQL to review and update data. The sample uses a PgSqlDataAdapter component to fill a dataset and post updated data to a PostgresSQL database. The PgSqlDataAdapter component uses the PgSqlCommandBuilder class to automatically generate SQL for INSERT/UPDATE/DELETE operations.
    DbDataTable This sample project demonstrates data mapping from PostgresSQL tables and paginal access. The sample uses a PgSqlDataTable component to access data from a table and display this data in a DataGrid control.
    Note: this sample is available only for Professional Edition.
    Dependency The Dependency demo project illustrates how to use the data dependency technique. The sample watches for some tables in the database. As you modify their data, the name of the table being edited is shown in a list.
    Note: this sample is available for Professional and Standard Edition.
    Dump This sample project demonstrates how to backup data from database to file and then restore it. It uses the PgSqlDump component to accomplish the task.
    Note: this sample is available only for Professional Edition.
    Loader This sample project demonstrates working with PgSqlLoader component. PgSqlLoader work is based on generation of INSERT statements that insert data by several rows at once.
    Note: this sample is available only for Professional Edition.
    MasterDetail This sample project demonstrates setting master-detail relation at an untyped dataset. The sample fills two tables at the dataset using the PgSqlDataAdapter component and sets master-detail relation between them.
    MetaData This sample project shows how to retrieve information about databases, tables, columns, users, and so on. The only method used for these tasks is GetSchema.
    Pictures This sample project demonstrates using dotConnect for PostgreSQL for working with BLOB objects as graphics. The sample shows how to retrieve binary data from a PostgresSQL database and display it at the monitor, load and save pictures into the file and the database.
    RefCursor This sample project demonstrates using REF CURSOR type in dotConnect for PostgreSQL.
    RowDataReader This sample project demonstrates using PgSqlDataReader class to obtain composite type values. The sample executes SQL statement at the PgSqlCommand and gets PgSqlDataReader to retrieve data.
    RowDataSet This sample project demonstrates using dataset with dotConnect for PostgreSQL to review and update composite type values. The sample uses PgSqlDataAdapter to fill a dataset and post updated data to PostrgeSQL database. PgSqlDataAdapter uses PgSqlCommandBuilder class to automatically generate SQL for INSERT/UPDATE/DELETE operations.
    RowStoredProc This sample project demonstrates execution of a stored procedure that uses a composite type value.
    RowTable This sample project demonstrates data mapping from PostgreSQL tables. The sample uses PgSqlDataTable component to access composite type data from the table and displays this data in the DataGrid control.
    Note: this sample is available only for Professional Edition.
    StoredProc This sample project demonstrates how to execute a stored procedure and view modified data.
    Table This sample project demonstrates data mapping from PostgresSQL tables. The sample sets CommandType property of PgSqlCommand to TableDirect to access data from the table.
    Transactions This sample project demonstrates working with PostgresSQL transactions in dotConnect for PostgreSQL. The sample demonstrates how to get a PgSqlTransaction object from a PgSqlConnection object, how to commit or rollback a transaction.

    Note: before running sample projects from an IDE you need to execute commands from Program Files\Devart\dotConnect\PostgreSQL\Samples\tables.sql to create test data. If C++ projects fail to open, it is possible that you do not have the assemblies Devart.Data.PostgreSql.dll and Devart.Data.dll in GAC or project's folder.

    Web Samples

    Run InstallWebTables.sql script by default located in the Program Files\Devart\dotConnect\PostgreSQL\Web\ASP.NET 2\InstallWebTables.sql. Use the Start menu group to open Web samples in the language you prefer.

    Sample Description
    AjaxDemo This sample demonstrates data binding and editing in an asynchronous way. The sample uses PostgreSqlDataSource component in conjuction with ASP.NET AJAX Update Panel.
    Note: this sample is available only in Professional Edition.
    CRM This sample demonstrates how PostgreSqlDatasource can be used in the complex software product such as CRM (Customer Relationship Management).
    The sample illustrates how to perform data retrieving and editing in the complex scenario using PostgreSqlDataSource. This sample is based on the CRM_DEMO database.
    Note: this sample is available only in Professional Edition.
    DataSource This sample shows how to use the PostgreSqlDataSource component of dotConnect for PostgreSQL. The sample illustrates using of manual paging, auto paging and master-detail techniques with PostgreSqlDataSource component.
    Note: this sample is available only in Professional Edition.
    DataSource_devExpress This sample demonstrates using PostgreSqlDataSource with DevExpress ASPxGridView component. The ASPxGridView component uses PostgreSqlDataSource to perform asynchronous data retrieving and paging.
    Note: this sample is available only in Professional Edition.
    LoadOnDemand This sample demonstrates the load-data-on-demand technique with the dotConnect for PostgreSQL components.
    The sample shows how to use PostgreSqlDataSource and ObjectDataSource to retrieve data from DB asynchronously and only on user demand.
    Note: this sample is available only in Professional Edition.
    LoadOnDemand_Telerik This sample demonstrates load-data-on-demand technique with PostgreSqlDataSource component in conjuction with Telerik RadGrid control.
    Note: this sample is available only in Professional Edition.
    Web A sample on simple usage of dotConnect for PostgreSQL in an ASP.NET application.
    WebProviders This sample shows how to use dotConnect for PostgreSQL with ASP.NET Providers Model.

    The first part of the WebProviders sample illustrates usage of WebParts, SiteMap, WebEvent, and SessionState Providers, and the second - of Membership, Roles, and Profile Providers.
    Note: this sample is available only in Professional Edition.

    Entity Framework Samples

    Use the Start menu group to open Entity framework samples in the language you prefer. To run the samples you should have VisualStudio 2008 Service Pack 1 or later and .NET Framework 3.5 Service Pack 1 or later installed.

    Besides, to get more experience you can download the separate Entity Framework Query Samples package from our site.

    Note: these samples are available only for Professional Edition.

    Sample Description
    LinqQueries This sample shows the ways of executing LINQ to Entities queries.
    MasterDetail This sample shows how to setup master/detail relationship with the possibility of editing and saving bound entities.
    SaveChanges This sample shows data binding, the possibility of editing table entities collection in DataGridView, and saving the changes to database.

    Note: before running sample projects from an IDE you need to execute commands from crm_demo.sql to create test data. PostgreSql server 8.0 or higher should be installed on the server.

    LinqConnect Samples

    LinqConnect samples are an easy way to get started with LinqConnect applications. They demonstrate usage of Entity classes, Language-Integrated Queries, database operations within LinqConnect. These samples are based on the CRM_DEMO database.

    Use the Start menu group to open samples in the language you prefer.

    Note: these samples are available only in Professional Edition. You can get more detailed information on the LinqConnect samples in the ReadMe file by the following path - Program Files\Devart\dotConnect\Linq\Samples\Readme.html

    Web Service

    Sample Description
    Server This sample illustrates creating a web service with dotConnect for PostgreSQL. In the provided web method dotConnect for PostgreSQL classes are used to fill DataSet and return it to a client.
    WebClient This sample demonstrates using of the web service by the web client. The data recieved from web service is shown in GridView control.
    WinClient This sample demonstrates using of the web service by the WinForms client. The data recieved from web service is shown in the DataGridView control.

    CRM Demo

    CRM (Customer Relationship Management) is a widespread class of projects in which you can encounter many typical tasks of database applications development. This sample shows how these tasks can be resolved in the scope of approaches that are offered by dotConnect for PostgreSQL data access solution for designing and building WinForms applications. By examining the source code of CRM demo you can see how the advanced features of dotConnect for PostgreSQL help you build a centralized data access and storage solution. Particularly, it solves common problems like implementing flexible data binding, passing instances of data access components, controlling database connections, and so on. For more information on the best practices in the area of data access please refer to the General Concepts in Database Application Development section of dotConnect for PostgreSQL documentation.

    To see how it works launch the compiled binary from the Start menu. This sample is based on the CRM_Demo database.

    Note: this demo is available only in Professional Edition. Also there is similar demo for ASP.NET; more detailed information on it is provided in the Web samples section.