ADO is the only way to work around a server cursor. ADO provides a schema management API to .Net 1.x. But ADO data (recordset) can’t be directly bound to ASP.NET controls. Accessing SQL Server by using the managed provider for OLE DB adds overhead because the objects called must pass through the COM interop layer. OLDB provider do not work with those implementing OLEDB 2.5 interfaces for semistructured and hierarchal rowset that includes Exchange (EXOLEDB) and Internet Publishing (MSDAIPP). Linq Data Source : There are five types of linq datasources: Linq-to- SQL , Linq-to- Objects , Linq-to- XML , and Linq-to- DataSet , and Linq-to- Entities . LinqDataSource provide the following properties: AutoGenerateOrderByClause (by using OrderByParameterCollection), AutoGenerateWhereClause (By using WhereParameterCollection), AutoPage , AutoSort , (They automatically enable Page sorting for GridView etc if enabled) ContextTypeName (Class...
