Àâòîðèçàöèÿ
Ïîèñê ïî óêàçàòåëÿì
McClure W.B. — Professional ADO NET 2: Programming with SQL Server 2005, Oracle, and MySQL
Îáñóäèòå êíèãó íà íàó÷íîì ôîðóìå Íàøëè îïå÷àòêó?
Íàçâàíèå: 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
Ïðåäìåòíûé óêàçàòåëü
Distributed transactions, Web services 155—156 Distributed transactions, workflow process 147—149 Distributors, Notification Service components 350 Double quote (") characters, quoted identifiers 78—79 DROP ENDPOINT command, SQL Server 344—345 DTS (Data Transformation Services), data migration 29 e-mail, sending service 386—389 EnableSubscriber() method, adding/removing subscribers 358—359 EndExecuteNonQuery() method, asynchronous commands 268—269 Enumerators, ADO.NET listing 549—584 Enumerators, SQL Server 278—279 Error codes, Firebird 488 Error tracing ODP.NET 534—535 Errors, exception information collection 62—66 Errors, Oracle 533—534 Errors, severity levels 63—64 Event batches, Notification Services 349 367—368 Event providers, Notification Services 349 Events, application definition file 353 356 Events, DDL triggers 263—264 313—314 Events, firing 367—368 Events, InfoMessage 244—246 events, Notification Services 349 353 367—368 Events, ObjectSourceData control 178—179 Events, OnRowUpdating 230 Events, Page_Load 358 Events, SqlDependency class 298 Events, StateChange 207 Events, XML change notification 133—134 Exception codes, Firebird 488 Exception handling, T-SQL 240—249 Exceptions, error information collection 62—66 Exceptions, management methods 62—66 Exceptions, OracleException class 533—534 Exceptions, provider-specific interaction 64—65 EXECUTE AS function, Reporting Services 429 ExecuteNonQuery() method, data providers 217—218 ExecuteNonQuery() method, data source data retrieval 81 ExecuteReader() method, search results display 81—82 ExecuteScalar() method, data providers 216 ExecuteScalar() method, single value return 83 96 Execution, SQL Server Management Objects (SMOs) 330 Explicit locking, MaxDB 480—481 Explicit schemas, MaxDB 480 Expressions, IdentifierPattern property 71 Expressions, Oracle 536—538 Expressions, ParameterMarkerPattern property 71 Expressions, ParameterNamePattern property 71 Expressions, QuoteIdentifierPattern property 72 Extended stored procedures (XP), SQLServer 301—302 Extensibility, Generic Factory Model 46 Extensibility, PostgreSQL 498 External events, Notification Services 349 EXTERNAL_ACCESS permission, CLR (Common Language Runtime) Objects 309 Failover notification, Oracle 526 FieldCount property, data providers 226 Fields, Boolean naming conventions 16 Fields, connection string 203—204 Fields, DateTime 16 Files, ADF (application definition file) 351—352 Files, application definition 352—356 Files, CodeBeside 446 Files, devicelist.aspx 360 Files, instance configuration 350—352 files, machine.config 46 Filters, defined 404 Filters, Full-Text Search 425—426 FindAll() method, data providers 219 Firebird, character sets 487 Firebird, Classic Server architecture 486—487 Firebird, client applications 487 Firebird, database elements 485—488 Firebird, development history 485 Firebird, error codes 488 Firebird, exception codes 488 Firebird, foreign keys 487 Firebird, generators 488 Firebird, installation 488—489 Firebird, InterBase Public License 485 Firebird, record locking 485—486 Firebird, record versioning 485—486 Firebird, referential integrity 487 Firebird, resource information 491 Firebird, selectable stored procedures 487 Firebird, SQL compliance 485 Firebird, Super Server architecture 486—487 Firebird, supported platforms 487 Firebird, UdFs (user-defined functions) 487 Firebird.NET integration 489—491 Fixed-length storage, CHAR (CHARACTER) data type 98 Flags, BINARY data type 103—106 Flat databases, normalization 28—29 FLOAT (FLOAT and DOUBLE PRECISION) data type, SQL Server 101 Floating-point, data types 101 Flow-control statements, T-SQL 239—240 Flow-through transactions, distributed transactions 156 Foreign keys, column naming conventions 16 Foreign keys, Firebird 487 Foreign keys, MaxDB 478 Foreign keys, MySQL 473 Foreign keys, PostgreSQL 498 Foreign keys, primary key relationships 20—21 Foreign keys, SQL Server Management Objects (SMOs) 337—338 ForeignKey() object, SQL Server Management Objects (SMOs) 337—338 Formatters, distributor component 350 Forms, customer sign-up 383—386 Forms, normalization types 25 Forms, ReportServer 445 Forms, Service Broker 381—383 FORMSOF object, Full-Text Search 416 FREETEXT function, Full-Text Search 414—415 FREETEXTABLE function, Full-Text Search 415—416 Full Text Indexing Wizard, Full-Text Search index setup 409—411 Full-text catalog, defined 404 Full-text index, defined 404 Full-Text Search, automatic change tracking population 406 Full-Text Search, BLOBs search 422—424 Full-Text Search, CONTAINS function 412—413 Full-Text Search, CONTAINS TABLE function 415 Full-Text Search, filters 425—426 Full-Text Search, FORMSOF object 416 Full-Text Search, FREETEXT function 414—415 Full-Text Search, FREETEXTABLE function 415—416 Full-Text Search, full population 406 Full-Text Search, incremental timestamp-based population 407 Full-Text Search, indexing setup 407—412 Full-Text Search, INFLECTIONAL parameter 417 Full-Text Search, ISABOUT object 417 Full-Text Search, language settings 418—419 Full-Text Search, manual change tracking population 407 Full-Text Search, multi-column queries 418 Full-Text Search, NEAR operator 417 Full-Text Search, properties 411—412 Full-Text Search, queries 412—418 Full-Text Search, query-linked servers 418 Full-Text Search, results rankings 419—422 Full-Text Search, structure elements 405—406 Full-Text Search, THESAURUS parameter 417 Full-Text Search, WEIGHT function 417 Full-Text Search, XML search 422 Full-text searching, described 403—404 Functions see also "Methods" Functions, CLR (Common Language Runtime) Objects 310—311 319—324 Functions, CONTAINS 412—413 Functions, CONTAINSTABLE 415 Functions, Dense_Rank() 258 Functions, EXECUTE AS 429 Functions, FREETEXT 414—415 Functions, FREETEXTABLE 415—415 Functions, NTile() 258—259 Functions, Oracle expressions 537 Functions, PIVOT 254—256 Functions, RANK() 257 Functions, READFAST 262 Functions, TABLESAMPLE 259—262 Functions, UNPIVOT 256 Functions, WAITFOR 262—263 Functions, WEIGHT 417 GenerateDBDirectMethods property, data binding 186—187 Generational terms, Full-Text Search query 413 Generators, Firebird 488 generators, Notification Services 349—350 Generic Factory Model, command parameter adding 79—80 Generic Factory Model, CreateCommand() object 77 Generic Factory Model, default parameters/values 58—59 Generic Factory Model, default providers 46 Generic Factory Model, exception catching methods 64 Generic Factory Model, extensibility 46 Generic Factory Model, Helper class 48—51 Generic Factory Model, pros/cons 47 Generic Factory Model, provider architecture 44—45 Generic Factory Model, provider-agnostic platform 42 Generic Factory Model, provider-independent classes 44—45 GetDataSources() method, data providers 232 GetDataSources() method, listing available data sources 51—52 GetDevices() method, device list display 360 362 GetEnumerator() method, data providers 228 GetName() method, data providers 228 GetNsApplication() method, subscription list display 364 GetNsInstance() method, subscriber list retrieval 357—359 GetNsInstance() method, subscription list display 364 GetOrdinal() method, data providers 228 GetSchemaTable() method, data providers 228 GetSqlValues() method, SqlTypes 289 GetSubscriber() method, subscribers 359—360 GetSubscription() methods, subscription list display 363—364 366 GetValues() method, data providers 228 Globally Unique Identifiers (GUIDs), primary key avoidance 19—20 GroupByBehavior enumerator, schema metadata system 70 HasRows property, data providers 226 Helper class, writing 48—51 Hosted event providers, application definition file 353 Hosted event providers, Notification Services 349 Hungarian notation, naming convention 15 IAsyncResult interface, asynchronous operations 275—276 IdbDataAdapter object, distributed transactions 150—153 IdentifierCase, schema metadata system 70 IdentifierPattern property, schema metadata system 71 Identifiers, IdentifierCase property 70 Identifiers, quoted 78—79 Identifiers, UNIQUEIDENTIFIER data type 108 IDisposable interface, data providers 207 IMAGE data type, SQL Server 102—103 Implicit locking, MaxDB 480—481 Implicit schemas, MaxDB 480 IMS (Information Management System), development history 3 In-memory transaction logs, BerkeleyDB 503 Incremental timestamp-based, Full-Text Search population method 407 Independent event providers, Notification Services 349 Index() object, SQL Server Management Objects (SMOs) 335—336 Indexers, data providers 219—221 Indexers, Full-Text Search setup 407—412 Indexes, database search performance enhancements 22 Indexes, SQL Server Management Objects (SMOs) 334—336 Indexing engine, performance/speed enhancements 94—95 Industry support, data access factor 2 Inference class, XML/ADO.NET integration 132—133 INFLECTIONAL parameter, Full-Text Search 417 Inflectional terms, Full-Text Search query 413 InfoMessage event, T-SQL 244—246 Information Management System (IMS), development history 3 Information() object, SQL Server Management Objects (SMOs) 332 Ingres, alerts 494 Ingres, CATOSL (CA Trusted Open Source License) 492 Ingres, clustering 493 Ingres, database elements 493—494 Ingres, development history 492 Ingres, distributed data 493 Ingres, installation 494—495 Ingres, key range table partitioning 493 Ingres, Knowledge Manager 493 Ingres, Oracle support 493 Ingres, page sizing 494 Ingres, parallel query execution 493 Ingres, read-ahead caching 493 Ingres, replication 493 Ingres, resource information 496—497 Ingres, row-level locking 494 Ingres, SQL compliance 493 Ingres, supported platforms 494 Ingres, user-defined extensions 493 Ingres.NET integration 495—496 Inheritance, PostgreSQL 498 Init() method, aggregate functions 322 INITIATOR service, Service Broker contracts 377—378 380—381 Insert command, data providers 218 Instance classes, SQL Server Management Objects (SMOs) 330 Instance configuration file, Notification Services 350—352 Instance methods, ObjectDataSource control support 180 instances, Notification Services 350—352 INT (integer) data type, SQL Server 97 99 Interfaces, ADO.NET 2 35—36 Interfaces, IAsyncResult 275—276 interfaces, IDisposable 207 Interfaces, ISqlReader 320—321 IO Completion ports, asynchronous commands 267 ISABOUT object, Full-Text Search 417 IsClosed property, data providers 226 IsCompleted property, asynchronous operations 270—271 IsDbNull() method, data providers 228 isolation levels, transactions 142—143 ISqlReader interface, table-valued functions 320—321 ItemDeleted event, change notification 133—134 ItemDeleting event, change notification 133—134 ItemInserted event, change notification 133—134 ItemInserting event, change notification 133—134 ItemUpdated event, change notification 133—134 ItemUpdating event, change notification 133—134 JavaScript, ReportServer validation 444—445 Joinbacks, queries 253—254 Joins, MaxDB 478 Joins, self 253 Joins, SupportedJoinOperators property 72—73 Key range table partitioning, Ingres 493 Key-value pairs, BerkeleyDB 503 Labels, DataSourceProductNaine property 70 Languages, Full-Text Search settings 418—419 Legal issues, data storage 35 Licensing, open-source software issues 467—468 Lists, subscriber retrieval 357—358 Load() method, streaming data 93—94 Local transactions versus distributed transactions 141 Local transactions, creating 143—145 Locking, BerkeleyDB 503 Locking, MaxDB support 480—481 Logically atomic transactions, BerkeleyDB 503 Loops, CURSOR data type 108 machine.config file, default providers 46 Manual change tracking, Full-Text Search population method 407 MARS (Multiple Active Result Sets), ADO.NET support 9 MARS (Multiple Active Result Sets), connection objects 276—278 Materialized views, PostgreSQL 498 MaxDB, backups 480 MaxDB, Database Analyzer 479 MaxDB, database clustering 480 MaxDB, database elements 479—481 MaxDB, Database Manager utility 479 MaxDB, development history 477—478 MaxDB, foreign keys 478 MaxDB, hot standby configuration support 480
Ðåêëàìà
|
|
Î ïðîåêòå