没有合适的资源?快使用搜索试试~ 我知道了~
Beginning C# 5.0 Databases, 2nd Edition.pdf
5星 · 超过95%的资源 需积分: 10 12 下载量 12 浏览量
2014-07-23
09:16:57
上传
评论
收藏 18.68MB PDF 举报
温馨提示
试读
427页
Beginning C# 5.0 Databases, 2nd Edition.pdf
资源推荐
资源详情
资源评论
Agarwal
SECOND
EDITION
Shelve in
.NET
User level:
Beginning–Intermediate
www.apress.com
SOURCE CODE ONLINE
BOOKS FOR PROFESSIONALS BY PROFESSIONALS
®
Beginning C# 5.0 Databases
Quickly become a highly proficient database application developer and user with
Beginning C# 5.0 Databases. Full of practical, detailed examples, this book gives you
the knowledge and skills you need to build a database application using T–SQL and
C#. It also provides you with a comprehensive tutorial on both SQL Server 2012 and
Visual Studio 2012.
You’ll find a complete introduction to database technology inside Beginning C# 5.0
Databases. You’ll learn how relational databases work and how to use them, work
through step-by-step examples of both T–SQL and C# programs, and discover how
to use ADO.NET and other data access techniques while programming your database.
All in all, Beginning C# 5.0 Databases shows you how to:
• Create database and table objects using SQL Server 2012
• Write SQL queries to modify and query data (including joins) in SQL tables
• Build GUI database applications with C#
• Handle runtime anomalies such as exceptions
• Program with ADO.NET Entity Framework and LINQ
• Write stored procedures in T–SQL and call them from C# 5.0
• Use SQL CLR to create stored procedure using C#
Beginning C# 5.0 Databases is fully revised and updated for C# 5.0 and Visual Studio
2012. Whether you have just started programming in C# or are an expert with the lan-
guage, this book teaches you all the fundamentals you need, and may ever need, to
develop professional database applications.
THE EXPERT’S VOICE
®
IN C#
RELATED
www.ebookee.org
iv
Contents at a Glance
About the Author................................................................................................ xviii
About the Technical Reviewer ............................................................................. xix
Acknowledgments ................................................................................................ xx
Introduction ......................................................................................................... xxi
Part I: Understanding Tools and Fundamentals Databases ....................................1
Chapter 1: Getting and Understanding Your Tools..................................................3
Chapter 2: Understanding Relational Databases ..................................................15
Chapter 3: Creating Database and Tables.............................................................25
Part II: Working with Database and XML ..............................................................41
Chapter 4: Manipulating Database Data ...............................................................43
Chapter 5: Querying Databases ............................................................................51
Chapter 6: Using Stored Procedures.....................................................................85
Chapter 7: Using XML .........................................................................................101
Chapter 8: Understanding Transactions .............................................................115
Part III: Working with Data Using ADO.NET.........................................................135
Chapter 9: Building Windows Forms Applications..............................................137
Chapter 10: Introduction to ADO.NET..................................................................171
Chapter 11: Handling Exceptions........................................................................183
Chapter 12: Making Connections........................................................................197
Chapter 13: Executing ADO.NET Commands to Retrieve Data.............................213
Chapter 14: Using Data Readers .........................................................................241
Part IV: Working with Advanced ADO.NET Related Features ..............................275
Chapter 15: Using Data Sets and Data Adapters.................................................277
www.ebookee.org
CONTENTS
v
Chapter 16: Using Data Controls with ASP.NET Applications .............................315
Chapter 17: Working with Text and Binary Data.................................................333
Chapter 18: Using LINQ .......................................................................................357
Chapter 19: Using the ADO.NET Entity Framework .............................................375
Chapter 20: Using the CLR in SQL Server............................................................395
Index ...................................................................................................................409
www.ebookee.org
xxi
Introduction
Welcome to this book. You have in your hands a book of ready-made solutions to common problems
encountered while writing SQL to run against an Oracle database. I’ve written this book for the person in
a hurry who needs to solve a specific problem and then get on with the job. Each recipe addresses a
specific problem and presents a solid, working solution to that problem. For those who are interested,
each recipe also provides an extended discussion of the solution and sometimes alternative solutions.
Who This Book Is For
If you are an application developer who likes to interact with databases using C#, this book is for you,
because it covers programming SQL Server 2012 using C# 5.0. This book does not require or even
assume that you have sound knowledge of C# 2.0 or SQL Server 2000 and database concepts. I have
covered all the fundamentals that other books assume a reader must have before moving on with the
chapters.
This book is a must for any application developer who intends to interact with databases using
C# 2012 as the development tool; if this is you, then this book is a must.
How This Book Is Structured
I’ve split the book into four parts, each covering one broad aspect of building database applications
using C# 5.0 and SQL Server 2012 database.
Part 1 deals with understanding the fundamentals of databases.
Part 2 covers the concepts of working with databases and XML.
Part 3 discusses working with data using ADO.NET.
Part 4 is a compendium of special topics and ranges from advanced ADO.NET features to
SQL CLR.
Conventions
Throughout the book, I’ve kept a consistent style for presenting SQL and results. Where a piece of code,
a SQL reserved word, or a fragment of SQL appears in the text, it is presented in fixed-width Courier font,
such as this (working) example:
select * from dual;
www.ebookee.org
剩余426页未读,继续阅读
资源评论
- 朱迪兔2018-12-21下载很久了,还可以
sunhe312
- 粉丝: 0
- 资源: 5
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- Screenshot_20240430_144340_com.ss.android.ugc.live.jpg
- 回到山沟沟.mp3
- 基于matlab实现自适应波束形成RLS及LMS算法仿真源程序1.rar
- 基于matlab实现自己编写的基于卡尔曼滤波的利用加速度传感器的计步器,测试数据是传感器放在腰部和手臂 .rar
- 基于matlab实现阵列信号处理,波束形成.rar
- 111111111111111111
- 基于matlab实现计步器编程;对当前的计步器装置的数值算法模拟 .rar
- Mdb学习查看PW;access;mdb;pw;password;patch
- 基于matlab实现关于语音信号声源定位DOA估计所用的一些传统算法.rar
- 基于ultralytics-yolov8, 将其检测/分类/分割/姿态等任务移植到rk3588上
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功