Challenges faced while using ADO.NET while interacting with Database
Frankly, I've found the ADO.NET's disconnected database model to be quite a verbose and lengthy process to work with. First, you need to create a Connection object to connect to the database and then corresponding DataAdapter and DataSet objects to deal with each table in that database. For example, assuming just 4 tables in an SQLite table, there will be 1 SQLiteConnection, 4 SQLiteDataAdapter objects and 4 DataSet objects, so total 9 objects just to work with the database! This is perhaps too much to grasp for someone coming from Python or PHP where its much simpler to create a connection and/or cursor object which can then be used to query any given table using a SQL statement.