Introduction Open Source development would not be very useful or even feasible if it did not provide a database in which to store application data. In fact there are many Open Source databases that could be used in .NET development. Unlike previous versions of ADO, ADO.NET is very structured and well defined. Creating an ADO.NET Data Provider for a database, while not a trivial task, is much more viable than with classic ADO.Developing with disconnected Datasets is a convenience that, once used, is very hard to give up. Having data conveniently packaged in XML allows for a standard, transformable format. Datasets, and especially Strongly-Typed Datasets, give a great object-oriented API to your data. All this is accomplished while keeping track of changes for you and giving you an easy way to only send changes across the wire. There are so many features of ADO.NET that it warrants a great weight when evaluating which Open Source database to use with development. |