Àâòîðèçàöèÿ
Ïîèñê ïî óêàçàòåëÿì
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
Ïðåäìåòíûé óêàçàòåëü
MaxDB, implicit/explicit schemas 480 MaxDB, installation 481—483 MaxDB, isolation levels 480—481 MaxDB, locking 480—481 MaxDB, nested subtransactions 479 MaxDB, outer joins 478 MaxDB, query tools 479 MaxDB, referential integrity 478 MaxDB, resource information 484 MaxDB, server-side cursors 480 MaxDB, SQL interaction 478—479 MaxDB, SQL modes 478 MaxDB, SQL Studio 479 MaxDB, SQLClI 279 MaxDB, stored procedures 478—479 MaxDB, subtransactions 479 MaxDB, Synchronization Manager 480 MaxDB, temporary tables 480 MaxDB, triggers 478—479 MaxDB, updateable views 479 MaxDB, WebDAV (Web Distributed Authoring and Versioning) 480 MaxDB, WebSQL 479 MaxDB.NET interaction 483—484 Measurement units, column naming conventions 16 Merge() method, aggregate functions 322 Message locking, Service Broker element 370 Message ordering, Service Broker element 370 Message queues 378—380 Message types, Service Broker 370 374—377 Message validation, Service Broker 374—377 METHODS see also "Functions" Methods, Accumulate() 322 Methods, AdsDataReader class 226—228 Methods, AdsFactory class 231—232 Methods, AsyncCallBackObject() 268—270 Methods, BeginExecuteNonQuery() 267—269 Methods, BeginExecuteReader() 269—271 Methods, BeginExecuteXMLReader() 271—272 Methods, BeginTransaction() 209 Methods, BuildUpdateCommands() 231 Methods, Cancel() 215 Methods, ChangeDatabase() 209 Methods, ChangePassword() 281 Methods, ClearAllPools() 280 Methods, ClearPool() 280 methods, close() 208 228 Methods, Create() 336 Methods, CreateDbContmand() 208—209 Methods, CreateDbParameter() 215 Methods, CreateParameter() 79—80 Methods, CreatePerinission() 232 Methods, DbDataSourceEnumerator() 52—53 Methods, Delete() 359 Methods, Dispose() 208 228 Methods, EnableSubscriber() 358—359 Methods, EndExecuteNonQuery() 268—269 Methods, ExecuteNonQuery() 81 217—218 Methods, ExecuteReader() 81—82 Methods, ExecuteScalar() 216 Methods, FindAll() 219 Methods, GetDataSources() 51—52 232 Methods, GetDevices() 360 362 Methods, GetEnumerator() 228 Methods, GetName() 228 Methods, GetNsApplication() 364 Methods, GetNsInstance() 357—359 364 Methods, GetOrdinal() 228 Methods, GetSchemaTable() 228 Methods, GetSqlValues() 289 Methods, GetSubscriber() 359—360 Methods, GetSubscription() 363—364 366 Methods, GetValues() 228 Methods, Init() 322 Methods, IsDbNull() 228 Methods, legacy support issues 40—41 methods, Load() 93—94 Methods, Merge() 322 Methods, MoveNext() 221 Methods, NextResult() 228 Methods, ObjectDataSource control 183 methods, open() 206—207 Methods, OracleDataReader class 531 Methods, OUTPUT 249—250 Methods, Page_Load() 362 365—366 Methods, PopulateDevice() 362 Methods, PopulateSubscription() 365—366 Methods, Prepare() 215 Methods, PrepareCommand() 215 219 Methods, QuoteIdentifier() 78—79 Methods, Read() 219 Methods, ReadAsObj ect 122 Methods, reader (select) 216 Methods, Render() 450—451 Methods, ROW_NUMBER() 256—257 Methods, Script() 342 methods, send() 318 Methods, SqlCommand class 267—272 Methods, SqlDependency class 298 Methods, SqlType data retrieval 287—290 Methods, TableAdapter 185—189 Methods, Terminate() 322—323 Methods, TryGetValue() 210—211 Methods, UnQuoteIdentifier() 78—79 Methods, WriteFromObject 122 Microsoft Full-Text Engine for SQL Server (MSFTESQL), described 405 Microsoft Oracle provider, classes 517—518 Microsoft Oracle provider, connection string properties 524 Microsoft Transaction Server (MTS), Oracle services 543—544 Microsoft Visual Studio 2005, XML requirement 118 Microsoft.SqlServer.Server namespace, SQL Server 306 Models, MySQL support 470 Modes, MaxDB 478 Modes, MySQL 470—472 MONEY data type, SQL Server 102 MoveNext() method, data providers 221 MSFTESQL (Microsoft Full-Text Engine for SQL Server), described 405 MTS (Microsoft Transaction Server), Oracle services 543—544 Multi-column queries, Full-Text Search 418 Multi-version concurrency control, PostgreSQL 499 Multiple Active Result Sets (MARS), ADO.NET support 9 Multiple Active Result Sets (MARS), connection objects 276—278 Multiple recordsets, ADO support 9 MySQL, combined modes 472 MySQL, database elements 473—475 MySQL, development history 468—469 MySQL, foreign keys 473 MySQL, installation 475 MySQL, invalid data handling 473 MySQL, licensing 468—469 MySQL, mode descriptions 470—472 MySQL, models 470 MySQL, online documentation 469 MySQL, primary keys 473 MySQL, resource information 477 MySQL, shorthand modes 472 MySQL, SQL compliance issues 469—473 MySQL, storage engines 469—470 MySQL, stored procedures 472—473 MySQL, transaction support 470 MySQL, triggers 473 MySQL, unique constraints 473—474 MySQL, views 473 MySQL.NET interaction 475—476 Named parameters, command objects 80 Namespaces, providers 43—44 Namespaces, ReportServer 440—442 Namespaces, SQL Server 2005 306 Naming conventions, acronym use 15 Naming conventions, Boolean fields 16 Naming conventions, columns 16 Naming conventions, DateTime fields 16 Naming conventions, foreign keys 16 Naming conventions, Hungarian notation 15 Naming conventions, measurement units 16 Naming conventions, numeric columns 16 Naming conventions, Pascal Case 15 Naming conventions, primary keys 16 Naming conventions, rules 15—16 Naming conventions, space character use 16 Naming conventions, stored procedures 17—19 Naming conventions, table elements 15—17 Naming conventions, triggers 17 Naming conventions, underscore (_) character use 16 National character storage, NCHAR/NVARCHAR data types 99 NCHAR (national character storage) data type, SQL Server 99 NEAR operator, Full-Text Search 417 Nested transactions, distributed transactions 153—155 NET Framework, BerkeleyDB interaction 504—507 NET Framework, data type/SQL Server mapping 114—116 NET Framework, data types 109—116 NET Framework, Firebird integration 489—491 NET Framework, Ingres integration 495—496 NET Framework, MaxDB interaction 483—484 NET Framework, MySQL interaction 475—476 NET Framework, Oracle database extensions 544 NET Framework, PostgreSQL integration 500—501 NET Framework, SQLite integration 510—511 Networks, SQL Server enumeration 278—279 NextResult() method, data providers 228 Noise words, defined 404 Noise words, query results ranking 421—422 Nonhosted event providers, application definition file 353 Nonhosted event providers, Notification Services 349 Normalization, data views 22—23 Normalization, flat databases 28—29 Normalization, form types 25 Normalization, performance considerations 30 Normalization, real world application 25 Normalization, reasons for 24 Notification Services, ADF (application definition file) 351—352 Notification Services, application definition file 352—356 Notification Services, application types 347 Notification Services, components 348—350 Notification Services, development history 347 Notification Services, distributors 350 Notification Services, event providers 349 Notification Services, firing events 367—368 Notification Services, generator components 349—350 Notification Services, instance configuration file 350—352 Notification Services, SQL instance 356—357 Notification Services, subscription management application 348—349 357—367 NTEXT data type, SQL Server 99 NTile() function, T-SQL 258—259 Numbers, data types 99—102 Numbers, table names 15 Numeric columns, naming conventions 16 NUMERIC data type, SQL Server 101 NVARCHAR (MAX) data type, SQL Server 99 NVARCHAR (national character storage) data type, SQL Server 99 Object Linking and Embedding Database (OLE-DB), development history 5 Object serialization, XML/ADO.NET integration 122—123 ObjectDataSource control, data binding 176—185 Objects see also "Commands" Objects, Backup() 338—340 Objects, callback 269—270 Objects, CLR versus T-SQL 329 Objects, Column() 335 objects, Command 11 objects, connection 11 Objects, context connections 327—328 Objects, DataAdapter 11 Objects, Database() 332 334—335 Objects, DataReader 11 objects, DataSet 11 32 Objects, DeviceInfo 453—460 Objects, ExecuteScalar() 96 Objects, ForeignKey() 337—338 Objects, FORMSOF 416 Objects, IDBDataAdapter 150—153 Objects, Index() 335—336 Objects, Information() 332 Objects, ISABOUT 417 Objects, ObjectDataSource control implementation 182—183 Objects, Restore() 340—341 Objects, Scripter() 341—343 Objects, scripting 330 Objects, Sequence 532—533 Objects, Server() 331 Objects, ServerConnection() 331 Objects, set-based programming 302—303 Objects, SMO creation 331—332 Objects, SqlCacheDependency 293—297 538—543 Objects, SqlContext 327 Objects, SqlDataRecord 326—327 Objects, SqlDbType 290—291 Objects, SqlMetadata 326—327 Objects, SqlPipe 318 Objects, strongly typed 33—34 Objects, SubscriberDevice 362 Objects, SubscriberEnumeration 357—359 Objects, SubscriptionEnumeration 363—364 Objects, Table() 334—335 Objects, Transaction 142 Objects, TransactionScope 146—149 Objects, TriggerContext 327 Objects, URN referencing 331 Objects, User() 336—337 Objects, WMI Provider 330 ObjectSpaces, Visual Studio Longhorn release 136 ODBC (Open Database Connectivity), development history 4 ODP.NET (Oracle Data Provider for .NET), array binding 526—529 ODP.NET (Oracle Data Provider for .NET), classes 518—519 ODP.NET (Oracle Data Provider for .NET), connection string properties 524 525 OLE-DB (Object Linking and Embedding Database), development history 5 One-way data binding versus two-way data binding 163 OnRowUpdating event, data providers 230 Open Database Connectivity (ODBC), development history 4 Open Source Initiative (OSI), definition 468 Open() method, data providers 206—207 Open-source databases see also "Databases" Open-source databases, BerkeleyDB 502—508 Open-source databases, Firebird 485—492 Open-source databases, Ingres 492—497 Open-source databases, MaxDB 477—484 Open-source databases, MySQL 468—477 Open-source databases, PostgreSQL 497—502 Open-source databases, SQLite 508—512 Open-source software, licensing issues 467—468 OpenFTS, PostgreSQL downloadable add-on 498 Operators, NEAR 417 Operators, TOP 250—252 Oracle Data Provider for .NET (ODP.NET), classes 518—519 Oracle Explorer, Visual Stuido.NET 519—522 Oracle, array binding 526—529 Oracle, BFile data type 543 Oracle, change notifications 538—543 Oracle, connection string properties 524—525 Oracle, connections 523—526 Oracle, data providers 515—516 Oracle, data types 523 Oracle, DataTable fills 529—531 Oracle, error tracing 534—535 Oracle, errors 533—534 Oracle, expression functions 537 Oracle, failover notification 526 Oracle, Ingres integration 493 Oracle, large object support 523 Oracle, Microsoft Oracle provider 517—518 Oracle, MTS (Microsoft Transaction Server) 543—544 Oracle, ODP.NET 516
Ðåêëàìà
|
|
Î ïðîåêòå