.NET and Pick Database D3

Question

I want to connect my .net application with D3 pick database 9.0 (Windows version). In Earlier days, people used ODBC driver from Pick to write VB6 applications connecting with D3. Can I use same driver for .NET application? Pick also provides .NET API for .NET and D3 connectivity.

What confuses me is what's the difference between ODBC driver and .NET API? Is .NET API a replacement of ODBC driver for .NET or it is a further abstraction over ODBC for .NET?

Answer 1

ODBC driver is a universal driver which can be used by any client which supports it. .NET API (ADO.NET driver) is a specific driver implementing ADO.NET interface created by Microsoft. Perfomance of ado.net drivers is usually better than ODBC driver. So, both ODBC and ADO.NET are drivers, just different. If you plan to work solely on .net I recommend to use .NET driver, it will give you a much better experience.