Walter,

Hope you don't mind me jumping in here with a few comments.

>>There is much to say about strong vs weak typing. I´ve got experience in both, and I must say that when doing for example C++ bypassing problems that comes with strong typing (as you might not know the type of object that will be passed) seems more a problem than the problems that come with weak typing.

I haven't used C++, but I can tell you that it's not really a problem in C#. You might not know the type of object that will be passed, but you can certainly test for the appropriate types.

if (MyObject is TextBox)
  o = (TextBox)MyObject;

So, no big deal...

>>The fact is that if you have to implement a SQL query on local data in ADO.NET, you´ve got to program a lot. As a result, there it is more difficult to write bufree code as you literally have to program the SQL command. The risks of having a bug in there is much more a problem than writing a single SQL command. Readability is harded because a developer has to wade though the code that access the collections and objects and trying to figure out how thing are done. With a simple SQL command this is not a problem because you´re not interested in how this is handled internally because you assume at forehand it is bugfree.

Sorry, Walter, but I don't see why you'd assume *anything* is bugfree. A single, complicated SQL command can have a bug in it just as easily as anything else.

>>The dataview must be build up and for all the internal handling behing this process and absense of the index ´concept´ this is performance wise not any alternative to the very quick DML of setting an index and drilling down that to get your data.


Well, setting up a DataView in ADO.NET is a piece of cake. Here's a simple example:

DataView oView = new DataView(MyTable);
oView.RowFilter = "MyColumn1 = " + Column1value +
             " AND MyColumn2 = " + Column2value

Now, I haven't benchmarked anything performance-wise between using a .NET DataView versus using a VFP index ... but have you benchmarked this at all either? I bet there's not much difference.

~~Bonnie