PostgreSQL ADO.NET Data ProvidersChapter 2. NPgSql also supports ADO.NET connection pooling, as shown in Figure 10-5. Figure 10-5. ADO.NET Connection Pooling.The NPgSql team chose to use both NAnt and NUnit for their development. The only feature left to evaluate is the useability of the API, which leads to the next section on Examples. Using NPgSql is intuitive and fits very well into ADO.NET. All of the NPgSql commands behave exactly as you would expect with the System.Data classes. Except for the integration with integrated development environments like Visual Studio.Net and #Develop, which let you drag and drop SQLConnections and wizards to configure SqlDataAdapters, using NPgSql classes is exactly the same as using the System.Data.SqlClient or System.Data.OleDb classes. A good example is needed to illustrate the ease of use of NPgSql. |