ADO.Net Facts

Came across a Microsoft Webcast and here is an interesting part on ADO.Net performance metrics :

• DataReader is 16% faster than the DataSet
• SqlDataReader is 115% faster than the OleDBDataReader
• Ordinal referencing of columns rather than by name is 11% faster Eg: dr[1] rather than dr["NAME"]
• Proper column casing increases the performance by 1% Eg:dr["NAME"] rather than dr["Name"] depending on the column name.
• Inline script is 233% faster than the DataGrid
• DataGrid with viewstate disabled is 66% faster than the DataGrid with Viewstate enabled.
• DataGrid without templates is 39% faster than the one with templates
• Explicit cast is 11% faster than the DataBind expression. Eg: ((DbDataRecord)Container.DataItem)["NAME"] is better than DataBinder.Eval
  (Container.DataItem, “NAME")
• Using DataCache is 637% faster than the standard DataGrid

Source : Microsoft Webcast