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

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

ROW_NUMBER() method, T-SQL      256—257
rs namespace, ReportServer      440—441
Rules, generator component      349
SAFE permission, CLR (Common Language Runtime) Objects      309
SAPdb (MaxDB), backups      480
SAPdb (MaxDB), Database Analyzer      479
SAPdb (MaxDB), database clustering      480
SAPdb (MaxDB), database elements      479—481
SAPdb (MaxDB), Database Manager utility      479
SAPdb (MaxDB), development history      477—478
SAPdb (MaxDB), foreign keys      478
SAPdb (MaxDB), hot standby configuration support      480
SAPdb (MaxDB), implicit/explicit schemas      480
SAPdb (MaxDB), installation      481—483
SAPdb (MaxDB), isolation levels      480—481
SAPdb (MaxDB), locking      480—481
SAPdb (MaxDB), nested subtransactions      479
SAPdb (MaxDB), outer joins      478
SAPdb (MaxDB), query tools      479
SAPdb (MaxDB), referential integrity      478
SAPdb (MaxDB), resource information      484
SAPdb (MaxDB), server-side cursors      480
SAPdb (MaxDB), SQL interaction      478—479
SAPdb (MaxDB), SQL modes      478
SAPdb (MaxDB), SQL Studio      479
SAPdb (MaxDB), SQLClI      279
SAPdb (MaxDB), stored procedures      478—479
SAPdb (MaxDB), subtransactions      479
SAPdb (MaxDB), Synchronization Manager      480
SAPdb (MaxDB), temporary tables      480
SAPdb (MaxDB), triggers      478—479
SAPdb (MaxDB), updateable views      479
SAPdb (MaxDB), WebDAV (Web Distributed Authoring and Versioning)      480
SAPdb (MaxDB), WebSQL      479
SAPdb (MaxDB).NET interaction      483—484
Scalar-valued functions, CLR (Common Language Runtime) Objects      319—320
Scalars, single value returns      87
Schema inference, XML/ADO.NET integration      132—133
Schema metadata system, data source information      69—73
Schema metadata system, data types      69
Schema metadata system, IdentifierPattern property      71
Schema metadata system, information queries      68—73
Schema metadata system, information sources      76—77
Schema metadata system, OrderByColumnsInSelect property      71
Schema metadata system, ParaineterNaineMaxLength property      71
Schema metadata system, ParameterMarkerFormat      71
Schema metadata system, ParameterMarkerPattern property      71
Schema metadata system, ParameterNainePattern      71
Schema metadata system, provider-agnostic API      67
Schema metadata system, QuoteIdentifierCase      72
Schema metadata system, QuoteIdentifierPattern      72
Schema metadata system, reserved words      75
Schema metadata system, restrictions      73—75
Schema metadata system, StatementSeparatorPattern      72
Schema metadata system, StringLiteralPattern      72
Schema metadata system, SupportedJoinOperators      72—73
Schema metadata system, uses      77
Schemas, CustomerInfoScheina      376
Schemas, MaxDB      480
Scientific calculations, CLR (Common Language Runtime) Objects      329
Script() method, SQL Server Management Objects (SMOs)      342
Scripter class, SMO utility class      330
Scripter() object, SQL Server Management Objects (SMOs)      341—343
Scripting objects, SQL Server Management Objects (SMOs)      330
Scripts, Service Broker      373
Scripts, Service Broker communication routes      390—394
Scripts, SQL Server Management Objects (SMOs)      341—343
Scripts, test      306
Searches, ASP.NET asynchronous operations      272—276
Searches, results display      81—82
searches, XML      422
Security calculations, CLR (Common Language Runtime) Objects      329
Security, CAS (code access security)      127—128
Security, CLR (Common Language Runtime) Object permissions      309
Security, database views      23
Security, XSD documents      127—128
SELECT statement, data migration      29
Selectable stored procedures, Firebird      487
Self joins, T-SQL      253
Send() method, CLR (Common Language Runtime) Objects      318
Sending services, Service Broker component      370
Separators, CompositeIdentifierSeparatorPattern property      69—70
Sequence database object, Oracle      532—533
Serialization, DataTables      92—93
Serialization, XML/ADO.NET integration      122—123
Server() object, SQL Server Management Objects (SMOs)      331
Server-side cursors, MaxDB      480
ServerConnection() object, SQLServer Management Objects (SMOs)      331
Servers, query-linked      418
servers, Reporting Services      438—460
ServerVersion property, data providers      205
Service Broker, asynchronous communication      370
Service Broker, automatic activation      370
Service Broker, catalog views      396—399
Service Broker, communication patterns      369
Service Broker, components      370—371
Service Broker, contracts      377—378
Service Broker, coordination      370
Service Broker, customer sign-up service      383—386
Service Broker, database integration      370
Service Broker, e-mail sending service      386—389
Service Broker, log in      373
Service Broker, message locking      370
Service Broker, message ordering      370
Service Broker, message processing      381—394
Service Broker, message types      374—377
Service Broker, message validation      374—377
Service Broker, queries      372
Service Broker, queues      378—380 394—396
Service Broker, routes      390—394
Service Broker, sample scenario      371—372
Service Broker, scripts      373
Service Broker, service automation      390
Service Broker, services      380—381
Service Broker, setup      372—373
Service Broker, SQL Service Broker Explorer      400
Service Broker, SSB Admin      399—400
Service Broker, Web application form      381—383
Service Oriented Architecture Protocol (SOAP), Report-Server      447—448
Services, automating      390
Services, customer sign-up      383—386
Services, e-mail sending      386—389
Services, Service Broker      370 380—381
Services, Service Broker contracts      377—378
Set theory, CLR (Common Language Runtime) Objects      302—303
Set-based programming, CLR (Common Language Runtime) Objects      302—303
Settings() object, SQL Server Management Objects (SMOs)      332
Shorthand modes, MySQL      472
Simple terms, Full-Text Search query      413
Simple transactions versus distributed transactions      141
Single-master replication, BerkeleyDB      503
SMALLDATETIME data type, SQL Server      100
SMALLINT data type, SQL Server      100
SMALLMONEY data type, SQL Server      102
SMOs (SQLServer Management Objects), Backup() object      338—340
SMOs (SQLServer Management Objects), backup/restore      338—341
SMOs (SQLServer Management Objects), capture execution      330
SMOs (SQLServer Management Objects), Column() object      335
SMOs (SQLServer Management Objects), columns      334—336
SMOs (SQLServer Management Objects), Configuration() object      332
SMOs (SQLServer Management Objects), database creation      332—334
SMOs (SQLServer Management Objects), Database() object      332 334—335
SMOs (SQLServer Management Objects), described      301 329
SMOs (SQLServer Management Objects), direct execution      330
SMOs (SQLServer Management Objects), execution methods      330
SMOs (SQLServer Management Objects), foreign keys      337—338
SMOs (SQLServer Management Objects), ForeignKey() object      337—338
SMOs (SQLServer Management Objects), Index() object      335—336
SMOs (SQLServer Management Objects), indexes      334—336
SMOs (SQLServer Management Objects), Information() object      332

SMOs (SQLServer Management Objects), instance classes      330
SMOs (SQLServer Management Objects), object creation      331—332
SMOs (SQLServer Management Objects), Restore() object      340—341
SMOs (SQLServer Management Objects), Script() method      342
SMOs (SQLServer Management Objects), Scripter() object      341—343
SMOs (SQLServer Management Objects), scripting objects      330
SMOs (SQLServer Management Objects), scripts      341—343
SMOs (SQLServer Management Objects), Server() object      331
SMOs (SQLServer Management Objects), ServerConnection() object      331
SMOs (SQLServer Management Objects), Settings() object      332
SMOs (SQLServer Management Objects), table creation      334—336
SMOs (SQLServer Management Objects), Table() object      334—335
SMOs (SQLServer Management Objects), tables      334—336
SMOs (SQLServer Management Objects), URN (Unique Resource Name) referencing      331
SMOs (SQLServer Management Objects), user creation      336—337
SMOs (SQLServer Management Objects), User() object      336—337
SMOs (SQLServer Management Objects), UserOptions() object      332
SMOs (SQLServer Management Objects), utility classes      330
SMOs (SQLServer Management Objects), WMI Provider objects      330
SOAP (Service Oriented Architecture Protocol), Report-Server      447—448
Space character, table name      16
SQL (Structured Query Language), development history      3 235—238
SQL (Structured Query Language), Firebird compliance      485
SQL (Structured Query Language), MaxDB interaction      478—479
SQL Server Management Objects (SMOs), Backup() object      338—340
SQL Server Management Objects (SMOs), backup/restore      338—341
SQL Server Management Objects (SMOs), capture execution      330
SQL Server Management Objects (SMOs), Column() object      335
SQL Server Management Objects (SMOs), columns      334—336
SQL Server Management Objects (SMOs), Configuration() object      332
SQL Server Management Objects (SMOs), database creation      332—334
SQL Server Management Objects (SMOs), Database() object      332 334—335
SQL Server Management Objects (SMOs), described      301 329
SQL Server Management Objects (SMOs), direct execution      330
SQL Server Management Objects (SMOs), execution methods      330
SQL Server Management Objects (SMOs), foreign keys      337—338
SQL Server Management Objects (SMOs), ForeignKey() object      337—338
SQL Server Management Objects (SMOs), Index() object      335—336
SQL Server Management Objects (SMOs), indexes      334—336
SQL Server Management Objects (SMOs), Information() object      332
SQL Server Management Objects (SMOs), instance classes      330
SQL Server Management Objects (SMOs), object creation      331—332
SQL Server Management Objects (SMOs), Restore() object      340—341
SQL Server Management Objects (SMOs), Script() method      342
SQL Server Management Objects (SMOs), Scripter() object      341—343
SQL Server Management Objects (SMOs), scripting objects      330
SQL Server Management Objects (SMOs), scripts      341—343
SQL Server Management Objects (SMOs), Server() object      331
SQL Server Management Objects (SMOs), ServerConnection() object      331
SQL Server Management Objects (SMOs), Settings() object      332
SQL Server Management Objects (SMOs), table creation      334—336
SQL Server Management Objects (SMOs), Table() object      334—335
SQL Server Management Objects (SMOs), tables      334—336
SQL Server Management Objects (SMOs), URN (Unique Resource Name) referencing      331
SQL Server Management Objects (SMOs), user creation      336—337
SQL Server Management Objects (SMOs), User() object      336—337
SQL Server Management Objects (SMOs), UserOptions() object      332
SQL Server Management Objects (SMOs), utility classes      330
SQL Server Management Objects (SMOs), WMI Provider objects      330
SQL Server Management Studio, Full-Text Search index setup      408—411
SQL Server, ADO.NET integration      265—266
SQL Server, BIGINT      100
SQL Server, BINARY      102—106
SQL Server, BIT      107
SQL Server, bulk copy operations      291—292
SQL Server, cache dependent data      168
SQL Server, CHAR (character)      98
SQL Server, CLR (Common Language Runtime) Objects      301—328
SQL Server, CLR Object tables/functions      310—311
SQL Server, connection pooling      279—280
SQL Server, CURSOR      108
SQL Server, data type/.NET mapping      114—116
SQL Server, data types      98—108
SQL Server, database connection strings      306
SQL Server, DATETIME (TIMESTAMP)      100
SQL Server, DDL CREATE endpoint command      344—345
SQL Server, DECIMAL (DEC and DEC (p, s ) )      101—102
SQL Server, DROP ENDPOINT command      344—345
SQL Server, enumerations      278—279
SQL Server, FLOAT (FLOAT and DOUBLE PRECISION)      101
SQL Server, full-text searching      403—404
SQL Server, IMAGE      102—103
SQL Server, INT (integer)      97 99
SQL Server, management objects      329—343
SQL Server, Microsoft.SqlServer.Server namespace      306
SQL Server, MONEY      102
SQL Server, MSFTESQL (Microsoft Full-Text Engine for SQL Server      405
SQL Server, NCHAR (national character storage)      99
SQL Server, NS instance      356—357
SQL Server, NTEXT data type      99
SQL Server, NUMERIC      101
SQL Server, NVARCHAR (MAX) data type      99
SQL Server, NVARCHAR (national character storage)      99
SQL Server, password management      280—283
SQL Server, programmability tracking      306
SQL Server, provider statistics      292—293
SQL Server, quoted identifiers      78—79
SQL Server, REAL (FLOAT (24))      101
SQL Server, Reporting Services setup      428—430
SQL Server, reserved words      75
SQL Server, SMALLDATETIME      100
SQL Server, SMALLINT      100
SQL Server, SMALLMONEY      102
SQL Server, SMOs (SQL Management Objects)      301
SQL Server, SqlConnectionStringBuilder class      281—283
SQL Server, SqlDataSourceEnumerator class      278—279
SQL Server, SqlTypes      283—300
SQL Server, SQL_VARIANT      107—108
SQL Server, stored procedure prefix guidelines      18
SQL Server, System.Data.Sql namespace      306
SQL Server, System.Data.SqlClient namespace      306
SQL Server, TABLE      108
SQL Server, test scripts      306
SQL Server, TEXT      99
SQL Server, TIMESTAMP      107
SQL Server, TINYINT      100
SQL Server, UNIQUEIDENTIFIER      108
SQL Server, VARBINARY      102—103
SQL Server, VARBINARY (MAX)      102—103
SQL Server, VARCHAR (char varying/character varying)      98
SQL Server, VARCHAR (MAX)      99
SQL Server, Web Services/XML Endpoint      301
SQL Server, XML      108
SQL Server, XML Web services      343—345
SQL Server, XPs (extended stored procedures)      301—302
SQL Server.NET Data Provider      265
SQL Service Broker Explorer, Service Broker administration tool      400
SQL statements, TableAdapter method      187
SQL Studio, MaxDB query tool      479
SqlBulkCopy class, bulk copy operations      291—292
SqlBulkCopyColumnMapping class, bulk copy operations      291—292
SqlBulkCopyColumnMappingCollection class, bulk copy operations      291—292
SqlCacheDependency object, change notification      539—543
SqlCacheDependency object, query data caching      293—297
SQLCacheDependency property, data source caching      168
SqlCacheDependencyAdmin class, SQL Server      297
SQLCLI, MaxDB query tool      479
SqlClient provider, SqlCommand object      78
SqlClientFactoryprovider, GetDataSources() method support      51
SqlCLRObjects assembly, deployment methods      307
SqlCommand class, asynchronous command support      267—272
SqlCommand object, calling from SqlClient provider      78
SqlConnectionStringBuilder class, SQL connections      281—283
SqlContext object, CLR (Common Language Runtime) Objects      327
SqlDataRecord object, tabular results      326—327
SqlDataSource connection string, Reporting Services      431—432
SQLDataSource control, configuration methods      170—175
SqlDataSourceEnumerator class, SQL Server      278—279
SqlDbType object, SqlTypes      290—291
SqlDependency class, SQL Server      297—300

1 2 3 4 5 6 7 8

Реклама

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

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

Valid HTML 4.01!

|

Valid CSS!

О проекте