Michael S. Schwartz

Today, more than ever, enterprises are faced with the necessity of migrating applications from one platform to another. Here, we try to take some of the pain out of migrating a database application written in Java to ADO.NET. In this article we compare the various database API calls in JDBC (Java DataBase Connectivity) and ADO.NET (ActiveX Data Objects) side by side to enable an application programmer to easily migrate a database application written in Java to ADO.NET. We also discuss which API calls are better suited to various situations in order to help application programmers understand when to use which API. We provide snippets of code throughout the article to enable a better understanding of the richness of the database API, what type of information is returned f... (more)