Apress - Pro ASP NET for SQL Server High Performance Data Access for Web Developers Sep 2007.pdf

(3825 KB) Pobierz
3233157 UNPDF
The eXperT’s Voice ® in sQl serVer
ASP.NET for
SQL Server
High Performance Data Access
for Web Developers
Mastering the bridge between ASP.NET and SQL Server
Brennan Stehling
Pro
3233157.046.png 3233157.056.png 3233157.067.png 3233157.077.png 3233157.001.png 3233157.002.png 3233157.003.png 3233157.004.png 3233157.005.png 3233157.006.png 3233157.007.png 3233157.008.png 3233157.009.png 3233157.010.png 3233157.011.png 3233157.012.png 3233157.013.png 3233157.014.png 3233157.015.png 3233157.016.png 3233157.017.png 3233157.018.png 3233157.019.png 3233157.020.png 3233157.021.png 3233157.022.png 3233157.023.png 3233157.024.png 3233157.025.png 3233157.026.png 3233157.027.png 3233157.028.png 3233157.029.png 3233157.030.png 3233157.031.png 3233157.032.png 3233157.033.png 3233157.034.png
 
3233157.035.png
 
3233157.036.png
 
3233157.037.png
 
3233157.038.png
 
3233157.039.png 3233157.040.png 3233157.041.png 3233157.042.png 3233157.043.png 3233157.044.png 3233157.045.png 3233157.047.png 3233157.048.png 3233157.049.png 3233157.050.png
 
3233157.051.png 3233157.052.png 3233157.053.png 3233157.054.png 3233157.055.png 3233157.057.png 3233157.058.png 3233157.059.png 3233157.060.png 3233157.061.png 3233157.062.png 3233157.063.png 3233157.064.png 3233157.065.png 3233157.066.png 3233157.068.png 3233157.069.png 3233157.070.png 3233157.071.png 3233157.072.png 3233157.073.png 3233157.074.png
 
Pro ASP.NET
for SQL Server
High Performance Data Access
for Web Developers
Brennan Stehling
3233157.075.png 3233157.076.png 3233157.078.png
Pro ASP.NET for SQL Server: High Performance Data Access for Web Developers
Copyright © 2007 by Brennan Stehling
All rights reserved. No part of this work may be reproduced or transmitted in any form or by any means,
electronic or mechanical, including photocopying, recording, or by any information storage or retrieval
system, without the prior written permission of the copyright owner and the publisher.
ISBN-13 (pbk): 978-1-59059-860-3
ISBN-10 (pbk): 1-59059-860-1
Printed and bound in the United States of America 9 8 7 6 5 4 3 2 1
Trademarked names may appear in this book. Rather than use a trademark symbol with every occurrence
of a trademarked name, we use the names only in an editorial fashion and to the benefit of the trademark
owner, with no intention of infringement of the trademark.
Lead Editors: Jonathan Gennick, Jim Huddleston
Technical Reviewer: Vidya Vrat Agarwal
Editorial Board: Steve Anglin, Ewan Buckingham, Gary Cornell, Jonathan Gennick, Jason Gilmore,
Jonathan Hassell, Matthew Moodie, Jeffrey Pepper, Ben Renow-Clarke, Dominic Shakeshaft,
Matt Wade, Tom Welsh
Project Manager: Kylie Johnston
Copy Editors: Sharon Wilkey, Ami Knox
Assistant Production Director: Kari Brooks-Copony
Production Editor: Ellie Fountain
Compositor: Diana Van Winkle, Van Winkle Design
Proofreader: April Eddy
Indexer: Carol Burbo
Cover Designer: Kurt Krames
Manufacturing Director: Tom Debolski
Distributed to the book trade worldwide by Springer-Verlag New York, Inc., 233 Spring Street, 6th Floor,
New York, NY 10013. Phone 1-800-SPRINGER, fax 201-348-4505, e-mail orders- ny@springer-sbm.com , or
For information on translations, please contact Apress directly at 2855 Telegraph Avenue, Suite 600,
Berkeley, CA 94705. Phone 510-549-5930, fax 510-549-5939, e-mail info@apress.com , or visit
The information in this book is distributed on an “as is” basis, without warranty. Although every precaution
has been taken in the preparation of this work, neither the author(s) nor Apress shall have any liability to
any person or entity with respect to any loss or damage caused or alleged to be caused directly or indirectly
by the information contained in this work.
The source code for this book is available to readers at http://www.apress.com in the Source Code/
Download section.
3233157.079.png
Contents at a Glance
About the Author . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xi
About the Technical Reviewer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii
Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xv
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvii
CHAPTER 1
Getting Started . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
CHAPTER 2
Data Model Choices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37
CHAPTER 3
Database Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55
CHAPTER 4
Databound Controls . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73
CHAPTER 5
SQL Providers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 111
CHAPTER 6
Caching . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 147
CHAPTER 7
Manual Data Access Layer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 191
CHAPTER 8
Generated Data Access Layer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 233
CHAPTER 9
Deployment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 255
CHAPTER 10 A Sample Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 289
■
APPENDIX
Photo Album . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 343
INDEX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 399
iii
■
■
■
■
■
■
■
■
■
■
■
3233157.080.png

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin