And if that wasn't technical enough...

In "ADO.Net 2 Advanced Data Access Patterns", Pablo Castro demonstrates the workings of an algebraic query processor, built on top of the ADO.Net technology. I guess it is technical, but his point is that it is possible, and actually not that difficult. I find it interesting to see the methods of logic processing that were presented in the advanced sessions this week - I've had to write some of these things before, but realize that I don't really understand the standard theories behind code and logic compilation. Good way to keep me humble!

One interesting thing that Pablo described was the indexing that happens behind the scenes in ADO.Net DataTables. If you run DataTable.Select, an index is automatically created on the data to optimize the select. Likewise, a DataView triggers the indexing - I suppose it is probably the same thing happening behind the scenes, but the DataView gives you a reference to the filter/sort request that was made, so that it is easy to re-execute it (though the creation of a new DataView with the same parameters would use the indexes created by the previous one)

Published Friday, September 16, 2005 8:40 PM by Joshua Langemann
Filed under:

Comments

Friday, July 06, 2007 4:12 AM by Ignatios

# re: And if that wasn't technical enough...

Interesting...

Monday, July 09, 2007 2:24 PM by Anastasios

# re: And if that wasn't technical enough...

Cool...

Tuesday, July 10, 2007 3:45 AM by Silvanos

# re: And if that wasn't technical enough...

Nice!

Tuesday, July 10, 2007 4:28 AM by Kyriakos

# re: And if that wasn't technical enough...

Sorry :(

Tuesday, July 10, 2007 7:09 AM by Xenophon

# re: And if that wasn't technical enough...

Cool.

Tuesday, July 10, 2007 9:57 PM by Georgios

# re: And if that wasn't technical enough...

Nice!

Tuesday, July 10, 2007 10:09 PM by Makarios

# re: And if that wasn't technical enough...

Cool.

Leave a Comment

(required) 
(required) 
(optional)
(required)