Summary


For all the great features included in SQL Server 2005, one of the most useful for the Visual Basic developer is the capability to move your code into the database. By integrating the common language runtime (CLR) with SQL Server, developers now have a choice when creating data access code between T-SQL and VB. While the implications of having your database run VB code can be a little unnerving, the benefits you receive in terms of flexibility and power may be just what you need in some applications. Visual Basic provides a number of tools that are not normally available when working with T-SQL, such as access to the classes of the .NET Framework. While you should only use VB in stored procedures and other database structures when it is appropriate, in those situations you can dramatically improve the scalability, performance, and functionality of your database applications.

Resources

  • SQL Server Developer Center (http://msdn.microsoft.com/sql) Main developer resource for information on the features of SQL Server

  • Ask Dr. Math (http://mathforum.org/library/drmath/) A great resource for mathematical algorithms

  • Yahoo Developer Center (http://developer.yahoo.com/dotnet/) Information on accessing Yahoo! services using Visual Basic




Professional VB 2005 with. NET 3. 0
Professional VB 2005 with .NET 3.0 (Programmer to Programmer)
ISBN: 0470124709
EAN: 2147483647
Year: 2004
Pages: 267

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