McClure W.B. — Professional ADO NET 2: Programming with SQL Server 2005, Oracle, and MySQL :: Электронная библиотека попечительского совета мехмата МГУ

Главная Ex Libris Книги Журналы Статьи Серии Каталог Wanted Загрузка ХудЛит Справка Поиск по индексам Поиск Форум

Авторизация

Поиск по указателям

Красота

McClure W.B. — Professional ADO NET 2: Programming with SQL Server 2005, Oracle, and MySQL

McClure W.B. — Professional ADO NET 2: Programming with SQL Server 2005, Oracle, and MySQL

Обсудите книгу на научном форуме

Нашли опечатку?
Выделите ее мышкой и нажмите Ctrl+Enter

Название: Professional ADO NET 2: Programming with SQL Server 2005, Oracle, and MySQL

Автор: McClure W.B.

Аннотация:

ADO.NET revolutionized the way data was accessed through SQL Server, Oracle, and MySQL. With Microsoft's release of ADO.NET 2, ADO and the .NET Framework are integrated with SQL Server for the first time-enabling you to program .NET applications directly within the SQL Server database.

Packed with sample code and recommended best practices for using ADO.NET 2, this code-intensive book explores the new data types that are available in the 2.0 Framework and discusses the appropriate time and way to use them. You'll learn how to make repetitive, mundane tasks much simpler and you'll walk away with a solid foundation for developing database-driven applications.

What you will learn from this book

The basics of creating a connection, executing a query, and returning a result
Best uses for Oracle in the ADO.NET Framework
The many new features that are available for XML
How to use the full text search capabilities of Microsoft(r) SQL Server 2005
Methods for retrieving data and presenting it in various ways
Why MySQL is a viable option for data storage

Who this book is for
This book is for experienced database developers who want to learn the latest release of ADO.NET 2.0. Knowledge of ADO.NET 1.0, general .NET development, and Microsoft SQL Server is necessary.
Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

Язык:

Рубрика: Computer science/

Статус предметного указателя: Готов указатель с номерами страниц

ed2k: ed2k stats

Год издания: 2006

Количество страниц: 644

Добавлена в каталог: 15.07.2014

Операции: Положить на полку | Скопировать ссылку для форума | Скопировать ID

Предметный указатель

SQLite, database elements      509—510
SQLite, development history      508
SQLite, installation      510
SQLite, minimalist approach      510
SQLite, resource information      512
SQLite, small footprint      510
SQLite, SQL compliance      508—509
SQLite, zero configuration requirements      510
SQLite.NET integration      510—511
SqlMetadata object, tabular results      326—327
SqlPipe object, CLR (Common Language Runtime) Objects      318
SqlProcedure attribute, CLR (Common Language Runtime) Objects      318—319
SqlTriggerContext class, CLR (Common Language Runtime) Objects      311—313
SqlTypes namespace, bulk copy operations      291—292
SqlTypes namespace, data retrieval methods      287—290
SqlTypes namespace, data types      109—113
SqlTypes namespace, provider statistics      292—293
SqlTypes namespace, SqlCacheDependency object      293—297
SqlTypes namespace, SqlCacheDependencyAdmin class      297
SqlTypes namespace, SqlDbType object      290—291
SqlTypes namespace, SqlDependency class      297—300
SqlTypes namespace, structures      284—287
SqlUserDefinedAggregate attribute, aggregate functions      322
SQL_VARIANT data type, SQL Server      107—108
Square brackets [ and ] characters, quoted identifiers      78—79
SSB Admin, Service Broker administration tool      399—400
sspGetSalesTotal procedure, Reporting Services      429—430
State property, data providers      205
StateChange event, data providers      207
Statements, ALERT QUEUE      378
Statements, StatementSeparatorPattern property      72
StatementSeparatorPattern property, schema metadata system      72
Static methods, ObjectDataSource control support      180
Statistics, data deletion protection method      35
Stemmer, defined      404
Storage engines, MySQL      469—470
Stored procedures, AddNewCustomer      382
Stored procedures, CLR (Common Language Runtime) Objects      318—319
Stored procedures, Firebird      487
Stored procedures, MaxDB      478—479
Stored procedures, MySQL      472—473
Stored procedures, naming conventions      17—19
Stored procedures, Oracle      544—547
Stored procedures, PostgreSQL      498
Stored procedures, sspGetSalesTotal      429—430
Stored procedures, TABLE data type      108
Stored procedures, TableAdapter method      188—189
Stored procedures, XP (extended)      301—302
String parameters, provider-specific connection strings      57—60
StringLiteralPattern property, schema metadata system      72
strings, connection      53—60
Strings, connection fields      203—204
Strings, database connection      306
Strings, ParameterMarkerFormat property      71
Strings, SqlDataSource connection      431—432
Structured exception handling, T-SQL      240—249
Structured Query Language (SQL), development history      3 235—238
Structured Query Language (SQL), Firebird compliance      485
Structured Query Language (SQL), MaxDB interaction      478—479
Subscriber devices, subscription management application component      349
SubscriberDevice object, device list editing      362—363
SubscriberEnumeration object, subscriber list retrieval      357—359
SubscriberID property, subscribers      357
Subscribers, adding/removing      358—359
Subscribers, device list display      360
Subscribers, retrieving      357—358
Subscribers, subscription management application      357—359 363—367
Subscribers, subscription management application component      348
Subscription lists, displaying      363—364
Subscription lists, editing      364—367
Subscription management application, adding/removing subscribers      358—359
Subscription management application, device list      360—363
Subscription management application, event firing      367—368
subscription management application, Notification Services      348—349
Subscription management application, saving subscriptions      366—367
Subscription management application, subscriber list retrieval      357—358
Subscription management application, subscription list      363—367
SubscriptionEnumeration object, subscription list display      363—364
Subscriptions, application definition file      355
Subscriptions, saving      366—367
Subscriptions, subscription management application component      349
SupportedJoinOperators property, schema metadata system      72—73
sys.assemblies table, CLR (Common Language Runtime) Object      310
sys.assembly_files table, CLR (Common Language Runtime) Object      310
sys.assembly_modules table, CLR (Common Language Runtime) Object      310
sys.assembly_preferences table, CLR (Common Language Runtime) Object      310
sys.assembly_types table, CLR (Common Language Runtime) Object      310
sys.sql_modules table, CLR (Common Language Runtime) Object      310
sys.types table, CLR (Common Language Runtime) Objects      310
System requirements, transactions      156—157
System.Data.CommandBehavior() objects, enumerated types      82—83
System.Data.Common namespace, provider classes      202
System.Data.Sql namespace, SQL Server      306
System.Data.SqlClient namespace, SQL Server      306
System.Data.SqlTypes namespace, SqlType structures      284—287
System.Transactions namespace, distributed transactions      146—149
T-SQL (Transact-SQL) language versus CLR objects      329
T-SQL (Transact-SQL) language, aggregate functions      323—324
T-SQL (Transact-SQL) language, at (@) character      239
T-SQL (Transact-SQL) language, CLR mapping methods      307
T-SQL (Transact-SQL) language, CREATE ASSEMBLY statement      307
T-SQL (Transact-SQL) language, CTEs (Common Table Expressions)      252—254
T-SQL (Transact-SQL) language, DDL triggers      263—264
T-SQL (Transact-SQL) language, Dense_Rank() function      258
T-SQL (Transact-SQL) language, development history      235—238
T-SQL (Transact-SQL) language, flow-control statements      239—240
T-SQL (Transact-SQL) language, InfoMessage event      244—246
T-SQL (Transact-SQL) language, NTile() function      258—259
T-SQL (Transact-SQL) language, OUTPUT method      249—250
T-SQL (Transact-SQL) language, PIVOT function      254—256
T-SQL (Transact-SQL) language, RANK() function      257
T-SQL (Transact-SQL) language, reachability      244
T-SQL (Transact-SQL) language, READFAST function      262
T-SQL (Transact-SQL) language, recursive queries      253—254
T-SQL (Transact-SQL) language, ROW_NUMBER() method      256—257
T-SQL (Transact-SQL) language, self joins      253
T-SQL (Transact-SQL) language, structured exception handling      240—249
T-SQL (Transact-SQL) language, TABLESAMPLE function      259—262
T-SQL (Transact-SQL) language, TOP operator      250—252
T-SQL (Transact-SQL) language, UNPIVOT function      256
T-SQL (Transact-SQL) language, variable declarations      238—239
T-SQL (Transact-SQL) language, WAITFOR function      262—263
TABLE data type, SQL Server      108
Table() object, SQL Server Management Objects (SMOs)      334—335
Table-valued functions, CLR (Common Language Runtime) Objects      320—321
TableAdapter method, data binding      185—189
Tables,CLR (Common Language Runtime) Objects      310—311
Tables,data providers      212
Tables,dragging/dropping into Windows Forms      192
Tables,foreign keys      20—21
Tables,MaxDB      480
Tables,message queues      378—380
Tables,namespace qualified      94
Tables,naming conventions      15—17
Tables,primary key conventions      19—20
Tables,Service Broker queues      394—395
Tables,SQL Server Management Objects (SMOs)      334—336
Tables,SQLDataSource control configuration      173—174
Tables,user properties versus Active Directory properties      221—222
Tables,views      22—23
TABLESAMPLE function, T-SQL      259—262
Tabular results, CLR (Common Language Runtime) Objects      326—327
Target service, Service Broker contracts      377—378 390—381
Terminate() method, aggregate functions      322—323
Test scripts, SQL Server projects      306
TEXT data type, SQL Server      99
Text markup, XML/ADO.NET integration      120
THESAURUS parameter, Full-Text Search      417
Time-based population, Full-Text Search method      407
Time/date, data types      100

TIMESTAMP data type, SQL Server      107
TINYINT data type, SQL Server      100
Token, defined      404
TOP operator, T-SQL      250—252
Tracing ODP.NET      534—535
Transact-SQL (T-SQL) language, development history      235—238
Transaction logs, BerkeleyDB      503
Transaction object, isolation levels      142
Transaction processing, C# language      242—243
Transaction processing, VB.NET      241—242
Transactional data store, BerkeleyDB      503
Transactions, A.C.I.D (atomicity/consistency/isolation/durability)      140—141
Transactions, concepts      139—145
Transactions, Distributed      145—154
transactions, isolation levels      142—143
Transactions, local transaction creation      143—145
Transactions, logically atomic      503
Transactions, MaxDB      479
Transactions, MySQL support      470
Transactions, parent/child scenarios      140
Transactions, simple versus distributed      141
Transactions, system requirements      156—157
Transactions, types      141
TransactionScope object, distributed transactions      146—149
Transfer class, SMO utility class      330
TriggerAction property, operations      312—313
TriggerContext object, CLR (Common Language Runtime) Objects      327
Triggers, CLR (Common Language Runtime) Objects      311—317
Triggers, column updates      313
Triggers, DDL      263—264
Triggers, DDL events      313—314
Triggers, MaxDB      478—479
Triggers, MySQL      473
Triggers, naming conventions      17
Triggers, PostgreSQL      498
Triggers, TriggerContext object      327
TryGetValue() method, data providers      210—211
Two-way data binding, data concurrency issues      163
Typed DataSets, data binding      185—186
UDFs (user-defined functions), Firebird      487
UI controls, Windows Forms      197—198
Underscore (_) character, table name avoidance      16
Unique Resource Name (URN), SMO referencing      331
UNIQUEIDENTIFIER data type, SQL Server      108
Universal data access, development history      4—6
UNPIVOT function, T-SQL      256
UnQuotedIdentifier() method, SQL Server      78—79
UNSAFE permission, CLR (Common Language Runtime) Objects      309
Updateable views, PostgreSQL      498
Updates, columns      313
URL contacts, ReportServer      439—446
URL, ReportServer parameters      443—446
URN (Unique Resource Name), SMO referencing      331
User objects, data providers      212
User properties versus Active Directory properties      221—226
User() object, SQL Server Management Objects (SMOs)      336—337
User-control caching, when to use      168—169
User-defined aggregate functions, CLR (Common Language Runtime) Object      323
User-defined extensions, Ingres      493
User-defined functions (UDFs), Firebird      487
User-defined types, CLR (Common Language Runtime) Objects      324—326
Useroptions() object, SQLServer Management Objects (SMOs)      332
Users, password changing      280—281
Users, SQL Server Management Objects (SMOs)      336—337
Utility classes, SQL Server Management Objects (SMOs)      330
Utils class, device list editing      362
Utils class, subscriber list retrieval      357—359
Validations, parameter data      166
Validations, ReportServer      444—445
Validations, Service Broker messages      374—377
Validations, XML/ADO.NET integration      131—133
VARBINARY (MAX) data type, SQL Server      102—103
VARBINARY data type, SQL Server      102—103
VARCHAR (char varying/character varying) data type, SQL Server      98
VARCHAR (MAX) data type, SQL Server      99
Variable declarations, T-SQL      238—239
VB.NET language, reachability      244
VB.NET language, transaction processing      241—242
Vendor commitment, data access factor      2
Versioning records, data preservation method      35
Views, data normalization      22—23
Views, database abstraction      31—32
Views, MaxDB      479
Views, MySQL      473
Views, PostgreSQL      498
Views, reports      23—24
Views, security enforcement      23
Views, Service Broker catalogs      396—399
Visual Studio 2005, CLR debugging      309—310
Visual Studio 2005, CLR deployment      307—308
Visual Studio 2005, CLR mapping methods      307
Visual Studio 2005, CLR permissions      309
Visual Studio 2005, creating CLR objects      304—306
Visual Studio 2005, data components      192
Visual Studio 2005, Data Source controls      169—170
Visual Studio 2005, Report Server project      433
Visual Studio 2005, SQL Server projects      306—310
Visual Studio 2005, UI controls      197—198
Visual Studio 2005, Web applications      430—432
Visual Studio.NET, Oracle developer tools      519—533
Visual Studio.NET, Oracle Explorer      519—522
WAITFOR function, T-SQL      262—263
Web applications, data binding environment      159—160
Web applications, one-way versus two-way data binding      163
Web applications, Reporting Services      430—432
Web applications, ReportServer setup      448—453
Web Distributed Authoring and Versioning (WebDAV), MaxDB      480
Web forms, ObjectDataSource control implementation      182—183
Web Service Development Language (WSDL), Report-Server      447—448
Web services, distributed transactions      155—156
Web services, XML/ADO.NET integration      119—120
Web Services/XML Endpoints, SQL Server      301
Web sites, anti-stored procedure argument      238
Web sites, BerkeleyDB downloads      508
Web sites, BerkeleyDB drivers      508
Web sites, BerkeleyDB licensing information      502
Web sites, BerkeleyDB support      508
Web sites, Bill Vaughn      249
Web sites, BSD License      497
Web sites, CATOSL (CA Trusted Open Source License)      492
Web sites, Dan Sullivan      400
Web sites, Firebird downloads      491
Web sites, Firebird drivers      491
Web sites, Firebird support      492
Web sites, Ingres downloads      497
Web sites, Ingres drivers      497
Web sites, Ingres support      497
Web sites, InterBase Public License      485
Web sites, MaxDB downloads      484
Web sites, MaxDB drivers      484
Web sites, MaxDB support      484
Web sites, Microsoft downloads      427
Web sites, MySQL documentation      469
Web sites, MySQL downloads      477
Web sites, MySQL drivers      477
Web sites, MySQL licensing      468—469
Web sites, MySQL support      477
Web sites, Niels Berglund      399
Web sites, nullable types      114
Web sites, Oracle Developer Tools      519
Web sites, OSI (Open Source Initiative) definition      468
Web sites, PostgreSQL      499
Web sites, PostgreSQL downloads      501
Web sites, PostgreSQL drivers      502
Web sites, PostgreSQL support      502
Web sites, Scot Allen      140
Web sites, SQL (Structured Query Language) specifications      235
Web sites, SQLite discussion      508
Web sites, SQLite downloads      512
Web sites, SQLite drivers      512

1 2 3 4 5 6 7 8

Реклама

© Электронная библиотека попечительского совета мехмата МГУ, 2004-2024

Электронная библиотека мехмата МГУ

Valid HTML 4.01!

|

Valid CSS!

О проекте