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.
.NET Talk
My experiments in .NET
Tuesday, August 3, 2021
Tuesday, April 16, 2013
7 Reasons why I like the C# programming language
1. Multithreading
support – While there are many other excellent features of
the language, multithreading support is what tops my list. The
reason is that the threading mechanism is so much intuitive and easier to
implement than many other languages like C++ or even java.
Sunday, February 10, 2013
Some VB6 Tricks
Though Visual Basic 6 has started
getting lost in antiquity since the advent of .NET, we do know there
are still zillions of VB6 programs in existence, with medium to high
complexity. They are not migrated to C# or VB.NET and are maintained
in their current state.
Sunday, February 5, 2012
How to convert an image to bytes in .NET?
One of the most standard queries I come across in many of the coding forums these days is, how do we convert an image (Image/Bitmap class) in .NET to a byte[] array? The answer to this is very straight forward - a few lines of code in VB.NET or C#:
Tuesday, January 17, 2012
How to code efficiently in a .NET language?
Here are some techniques you may apply in your quest to become a better .NET coder:
[1] Leverage the power of industry-standard tools. There exist many proven tools to help you with various programming needs.
[1] Leverage the power of industry-standard tools. There exist many proven tools to help you with various programming needs.
Saturday, August 6, 2011
How to perform Cross-thread communication in .NET programs
Multithreading is a quite useful technique in programming, especially in complex applications that seem to do a lot of things at the same time. The System.Threading class in .NET provides members that allow us to seamlessly create, stop and abort threads at will. But this article is not about managing threads, there are already several texts available for that. This is about managing a very typical scenario that is faced by a developer working on a multi threaded application.
Saturday, July 30, 2011
How to create an FTP client in VB.NET
The FTP (File Transfer Protocol) is one of the oldest and most popular ways of transferring files from one computer to another over a TCP network such as the internet. It is a Client/Server based protocol based on cear-text authentication. To get a detailed idea of what FTP is and how it is used, refer to http://en.wikipedia.org/wiki/File_Transfer_Protocol
Subscribe to:
Posts (Atom)