Home > Microsoft .Net Development Tips > Chapter Downloads
Win Development Tips:
EMAIL THIS
 TIPS & NEWSLETTERS TOPICS 

CHAPTER DOWNLOADS

Book Excerpt: The .NET Framework and SQL Server 2005


Robert Vieira
07.10.2007
Rating: --- (out of 5)


.NET Essentials Channel
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


For developers making the transition from SQL Server 2000 to SQL Server 2005, there is much to study -- native data encryption, SQL Server Integration Services, the Service Broker and more robust T-SQL. One of the biggest changes, though, is the addition of .NET assemblies and the CLR, which were absent from SQL Server 2000 because, well, .NET was still just an idea back then.

Nothing but NET!, Chapter 14 of Wrox Press' Professional SQL Server 2005 Programming, takes a look at what the .NET Framework brings to the database. Author Robert Vieira divides his chapter into four main sections:

  1. Assemblies, which are just DLLs created in managed code (any .NET programming language will do);
  2. Aggregate Functions, which look at data sets, analyze them and return a corresponding value, none of which T-SQL user-defined functions can do;
  3. Creating Triggers, which due to their contextual nature are a bit different from most Assembly types, and
  4. Custom Data Types, which thanks to .NET assemblies can contain complex rules, multiple properties or just about anything else one can imagine.

[IMAGE] Read the rest of the excerpt in this PDF.

Excerpted from ...

Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google



RELATED CONTENT
Chapter Downloads
Advanced Windows Debugging Book Chapter and Podcast
Book excerpt: Murach's VB 2008
Book excerpt: Building personalized solutions in SharePoint 2007
Book excerpt: Java EE and .NET security interoperability
Book excerpt: Building document management solutions in SharePoint 2007
Book excerpt: .NET Framework Design Guidelines
Book excerpt: Advanced Windows Debugging
Book excerpt: Pragmatic unit testing in C# with NUnit
Book Excerpt: Executing activities in Windows Workflow Foundation
Book excerpt: Hands-on Windows Communication Foundation

Microsoft SQL Server
Using the Visual Studio 2005 DataSet Designer to build a data access layer
The CTE, the hierarchical query and SQL Server 2005
SQL Server 2005 recursive functions and the CTE
Choose the right .NET data provider, optimize application performance
The fallacy of the data layer -- or, a new architectural model for software designs
Book excerpt: ADO.NET and SQL Server 2005
Addressing common SQL Server questions
WinForms development using SQL Server 2005 and Visual Basic 2005
Configuring ASP.NET 2.0 apps to SQL Server 2005 databases
Book excerpt: Retrieve data from a SQL Server 2005 table

SQL Server and .NET development
Microsoft releases new CTP of Oslo SDK
Perpetuum unveils database synchronizer for .NET 2.0
The CTE, the hierarchical query and SQL Server 2005
SQL Server 2005 recursive functions and the CTE
SQL Examiner Suite synchronizes data schema, sets
Book excerpt: ADO.NET and SQL Server 2005
DataDirect database drivers now support MySQL
Top .NET tips of 2007 (so far)
Addressing common SQL Server questions
Turn SQL data into script with SQL Populator

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary


the Wrox Press book, Professional SQL Server 2005 Programming (ISBN: 978-0-7645-8434-3) by Robert Vieira.
Copyright © 2006. Published by John Wiley and Sons Inc., and available at your favorite book seller. Reprinted with permission.

Rate this Tip
To rate tips, you must be a member of SearchWinDevelopment.com.
Register now to start rating these tips. Log in if you are already a member.




DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.



Database Programming Solutions - .NET XML, Visual Studio LINQ, ORM .NET
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2000 - 2009, TechTarget | Read our Privacy Policy 		  TechTarget - The IT Media ROI Experts