ADO 2005 .NET Tips: (new features)

Sql Server 2005 Reporting Services: (quality report design, mgmt(output, security))
High level Language control of Data since the CLR has been put into SQLServer2005
Asynchronous Execution

More meta-data from the likes of GetSchema Method of SqlConnection class

New classes easing switching tween data providers at configuration time or runtime

Faster loading DataTables (30 minute load could finish in around 30 seconds)

DataSet, DataTable, DataView have new methods:

DataTable becomes more independent gaining methods like DataSet:
dt.ReadXml, dt.WriteXml, dt.ReadXmlSchema, dt.WriteSchema
GetDataReader, GetTableReader, Load allow better looping, merging;
ds.RemotingFormat property sets serialization mode: xml/binary
DataView.ToTable Method
TSQL language does have a number of enhancements:
TOP myVar, FROM TABLESAMPLE 25%, PIVOT/UNPIVOT;
Send mail to Computer Consulting with questions or comments about this web site.
Copyright © 1996 CompanyLongName
Last modified: January 26, 2006