SQL Server Yukon Release


Whereas database-based application development has always been a key component of any Web, Windows, or mobile application (or even a Web service development), the programming models have always been quite different. For instance, today if you were to design and develop a sufficiently complex .NET application, apart from writing the necessary .NET components , applications, and services in your favorite .NET programming language, you would also inevitably have to write a set of stored procedures in the database-specific programming language, such as TSQL or Transact SQL for SQL Server. At the same time, SQL Server seems to be the database of choice when it comes to developing and deploying .NET applications. Microsoft realizes this and as part of the next generation SQL Server release, popularly known as the Yukon release, SQL Server will incorporate core CLR functionality into its database engine. This trend is not entirely a new concept; for instance, if you are an expert JDBC/Oracle programmer, you know that in a number of ways, this is similar to Oracle's approach of utilizing the Java programming language and other J2EE capabilities within the Oracle database.

SQL SERVER 2000 REPORTING SERVICES

SQL Server 2000 Reporting Services adds the capability of creating and running reports within the SQL Server environment. Reporting Services enable developers to use Visual Studio .NET and XML to create and deliver interactive reports based on a Report Markup Language. This technology is actually an enhancement to SQL Server technology that is available before the Yukon release. At the time of writing this book, the Reporting Services technology was available in Beta 2 release.


What does this mean? Basically, the Yukon release will provide developers of .NET applications the capability to write database stored procedures in Visual Basic .NET and C#. To unify the data-access logic approaches for both the scenarios (within the database in stored procedures and middle- tier business logic components), ADO.NET will be used as the programming model. In addition to this key enhancement, the Yukon release features extensive XML support, including support of XML as a data type, XML data specific indexes, support for XPath, XML Schemas, and XQuery standards. Essentially, SQL Server Yukon will be a full-blown native XML store. At the same time, the Yukon release of the database coincides with the Whidbey release of the Visual Studio .NET product and provides integrated developing, debugging, deploying, and profiling support of stored procedures within the Visual Studio .NET tool. For instance, with Whidbey, you should be able to put a breakpoint in your C#-based stored procedure in the database and be able to debug the code in a step-by-step fashion similar to code written outside the database.



Microsoft.Net Kick Start
Microsoft .NET Kick Start
ISBN: 0672325748
EAN: 2147483647
Year: 2003
Pages: 195
Authors: Hitesh Seth

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net