Àâòîðèçàöèÿ
Ïîèñê ïî óêàçàòåëÿì
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
Ïðåäìåòíûé óêàçàòåëü
Oracle, OracleConnection class 523 Oracle, OracleConnectionStringBuilder class 523 Oracle, OracleDataReader class 531 Oracle, OracleException class 533—534 Oracle, packages 535—536 Oracle, parameter binding 526 Oracle, provider classes 516—519 Oracle, regular expressions 536—538 Oracle, row insertion 532—533 Oracle, Sequence database object 532—533 Oracle, vendor-specific code avoidance 516 Oracle, Visual Studio.NET developer tools 519—533 Oracle.NET database extensions 544 Oracle.NET stored procedures 544—547 OracleConnection class, Oracle connections 523 OracleConnectionStringBuilder class, Oracle connections 523 OracleDataReader class, methods 531 OracleDependency class, ODP.NET 538—539 OracleException class, Oracle errors 533—534 OrderByColumnslnSelect property, schema metadata system 71 OSI (Open Source Initiative), definition 468 Outer joins, MaxDB 478 Output formats, application definition file 353—354 OUTPUT method, T-SQL 249—250 Output parameters, value returns 84—85 Output validation, XML/ADO.NET integration 131—132 Output, CLR stored procedure results 318 Packages, Oracle definitions 535—536 Page-level caching, when to use 168—169 Page_Load() method, adding/removing subscribers 358—359 Page_Load() method, device list editing 362 Page_Load() method, subscription list editing 365—366 Paging, ObjectDataSource control support 179 ParaineterMarkerFormat property, schema metadata system 71 Parallel query execution, Ingres 493 ParameterMarkerPattern property, schema metadata system 71 ParameterNameMaxLength property, schema metadata system 71 ParameterNamePattern property, schema metadata system 71 Parameters, adding to an object 79—80 Parameters, application definition file 352—355 Parameters, BeginExecuteReader() method 269 Parameters, data provider non-support reasons 212 Parameters, data validation 166 Parameters, INFLECTIONAL 417 Parameters, instance configuration file 351 Parameters, named 80 Parameters, ObjectDataSource control 183—184 Parameters, Oracle 526 Parameters, output 84—85 Parameters, passing to Data Source controls 165—167 parameters, positional 80 Parameters, provider-specific 80—81 Parameters, Render() method 450—451 Parameters, rs namespace 440—441 Parameters, THESAURUS 417 Parameters, URL ReportServer 443—446 Partitioning, key range table 493 Pascal Case, naming conventions 15 Passwords, ChangePassword() method 281 Passwords, SQL Server management 280—283 Performance, data access factor 1 Permissions, CLR (Common Language Runtime) Objects 309 Permissions, data providers 232 Permissions, Service Broker contracts 377—378 pgAdmin III, PostgreSQL add-on tool 499 PIVOT function, T-SQL 254—256 PL/Perl language, PostgreSQL support 499 PL/pgSQL language, PostgreSQL support 499 PL/Python language, PostgreSQL support 499 PL/Tcl language, PostgreSQL support 499 PopulateDevice() method, device list editing 362 PopulateSubscription() method, subscription list editing 365—366 Population, Full-Text Search methods 406—407 Population/crawl, defined 404 Positional parameters, command objects 80 PostGIS, PostgreSQL downloadable add-on 498 PostgreSQL, BSD License 497 PostgreSQL, constraints 498 PostgreSQL, database elements 498—499 PostgreSQL, development history 497 PostgreSQL, extended data types 498 PostgreSQL, extensibility 498 PostgreSQL, inheritance 498 PostgreSQL, installation 499—500 PostgreSQL, materialized views 498 PostgreSQL, multi-version concurrency control 499 PostgreSQL, OpenFTS 498 PostgreSQL, pgAdmin III 499 PostgreSQL, PostGIS 498 PostgreSQL, procedural languages 499 PostgreSQL, properties foreign keys 498 PostgreSQL, referential integrity 498 PostgreSQL, replication 499 PostgreSQL, resource information 501—502 PostgreSQL, SQL compliance 498 PostgreSQL, stored procedures 498 PostgreSQL, triggers 498 PostgreSQL, updateable views 498 PostgreSQL.NET integration 500—501 Prefix terms, Full-Text Search query 413 Prefixes, stored procedure guidelines 18 Prefixes, trigger naming conventions 17 Prepare() method, data providers 215 PrepareCommand() method, data providers 215 219 Primary keys, column definitions 19—20 Primary keys, column naming conventions 16 Primary keys, foreign key relationships 20—21 Primary keys, MySQL 473 Private cache area, data source caching 167—169 Procedural languages, PostgreSQL supported types 499 Procedural programming, CLR (Common Language Runtime) Objects 303 Procedures, naming conventions 17—19 Procedures, sspGetSalesTotal 429—430 Procedures, XP (extended stored) 301—302 Programmability tracking, SQL Server projects 306 Properties, AdsDataAdapter class 229 Properties, AdsDataReader class 226—228 Properties, AdsProvider 205 206 Properties, ASSEMBLYPROPERTY 311 Properties, Column() object 335 Properties, CommandText 213 Properties, CompositeIdentifierSeparatorPattern 69—70 Properties, Connection 213 Properties, ConnectionString 204—205 Properties, ConnectionTimeout 205 properties, database 205 206 properties, DataSource 205 Properties, DataSourceProductName 70 Properties, DbConnection 213 Properties, DbParameterCollection 214—215 Properties, DbTransaction 214—215 Properties, Depth 226 Properties, FieldCount 226 Properties, Full-Text Search 411—412 Properties, GenerateDBDirectMethods 186—187 Properties, GroupByBehavior 70 Properties, HasRows 226 Properties, IdentifierCase 70 Properties, IdentifierPattern 70 Properties, Index() object 335—336 Properties, IsClosed 226 Properties, IsCompleted 270—271 Properties, legacy support issues 40—41 Properties, ObjectDataSource control 177—178 Properties, Oracle connection string 524—525 Properties, OrderByColumnsInSelect 71 Properties, ParameterMarkerFormat 71 Properties, ParameterMarkerPattern 71 Properties, ParameterNameMaxLength 71 Properties, ParameterNamePattern 71 Properties, query results ranking 419—420 Properties, QuoteIdentifierCase 72 Properties, QuoteIdentifierPattern 72 Properties, RecordsAffected 226 Properties, scalar-valued functions 320 Properties, ServerConnection() object 331 Properties, ServerVersion 205 Properties, SQLCacheDependency 168 Properties, SqlConnectionStringBuilder class 282—283 Properties, SqlContext object 327 Properties, SQLDataSource control 174—175 Properties, SqlDependency class 298 Properties, SqlFunction attribute 320 Properties, SqlTriggerContext class 311 Properties, State 205 Properties, StatementSeparatorPattern 72 Properties, StringLiteralPattern 72 Properties, SubscriberID 357 Properties, SupportedJoinOperators 72—73 Properties, Table() object 335 Properties, TriggerAction 312 Properties, user versus Active Directory 221—226 Properties, User() object 336—337 Property Page, SQLDataSource control configuration 173 Protocols, application definition file 354—355 Protocols, delivery 350 Provider classes, Oracle 516—519 Provider statistics, SQL Server 292—293 Providers see also "Data providers" Providers, application definition file 353 Providers, connection strings 53—60 Providers, Generic Factory Model architecture 44—45 Providers, GetDataSources() support 51 Providers, hosted event 349 353 Providers, independent event 349 Providers, machine.config file default types 46 Providers, namespaces 43—44 Providers, non-hosted event 349 353 Providers, OLE-DB workflow process 5—6 Providers, provider-specific commands 78 Proximity terms, Full-Text Search query 413 Quantum, generator component 349 Queries, anchors 253—254 Queries, data caching 293—297 Queries, Full-Text Search 412—418 Queries, joinback 253—254 Queries, MaxDB 479 Queries, multi-column 418 Queries, recursive 253—254 Queries, reserved words 75 Queries, results ranking 419—422 Queries, schema metadata system 68—73 Queries, schema metadata system information sources 76—77 Queries, schema metadata system restrictions 73—75 Queries, Service Broker 372 Queries, SQLDataSource control configuration 173 Query-linked servers, Full-Text Search 418 Queues, e-mail sending service 386—389 Queues, Service Broker 370 378—380 394—396 Quotation marks ("), quoted identifiers 78—79 Quoted identifiers, double quote (") characters 78—79 Quoted identifiers, square brackets [ and ] characters 78—79 QuoteIdentifier() method, SQL Server 78—79 QuoteIdentifierCase property, schema metadata system 72 QuoteIdentifierPattern property, schema metadata system 72 RANK() function, T-SQL 257 rc namespace, ReportServer 442 RDL (Report Definition Language), Reporting Services 436—438 RDO (Remote Data Objects), development history 7—8 Reachability, T-SQL 244 Read() method, data providers 219 Read-ahead caching, Ingres 493 ReadAsObject method, XML block reading 122 Reader (select) methods, data providers 216 READFAST function, T-SQL 262 REAL (FLOAT(24)) data type, SQL Server 101 Receiving services, Service Broker component 370 Record locking, Firebird 485—486 Record versioning, Firebird 485—486 Records, data provider deletion 217—218 Records, data provider updates 217—218 Records, deletion protection methods 35 RecordsAffected property, data providers 226 Recursive queries, T-SQL 253—254 REFERENCE permission, Service Broker contracts 377—378 381 Referential integrity, Firebird 487 Referential integrity, MaxDB 478 Referential integrity, PostgreSQL 498 Regular expressions, IdentifierPattern property 71 Regular expressions, Oracle 536—538 Regular expressions, ParameterMarkerPattern property 71 Regular expressions, ParameterNamePattern property 71 Regular expressions, QuoteIdentifierPattern property 72 Relational databases, development history 3—4 Relationships, foreign key/primary key 20—21 Reliability, data access factor 1 Remote Data Objects (RDO), development history 7—8 Render() method, ReportServer 450—451 Replication, BerkeleyDB 503 Replication, Ingres 493 Replication, PostgreSQL 499 Report Definition Language (RDL), Reporting Services 436—438 Reporting Services versus ASP.NET reports 433 Reporting Services, account rights 429 Reporting Services, data sources 436—437 Reporting Services, execute rights 429 Reporting Services, implementation 428 Reporting Services, log in 429 Reporting Services, page rendering 437—438 Reporting Services, RDL (Report Definition Language) 436—438 Reporting Services, report models 460—464 Reporting Services, ReportServer 438—460 Reporting Services, scenarios 428 Reporting Services, servers 438—460 Reporting Services, SQL Server setup 428—430 Reporting Services, SqlDataSource connection string 431—432 Reporting Services, sspGetSalesTotal procedure 429—430 Reporting Services, URL contacts 439—446 Reporting Services, URL setup 432 Reporting Services, Web applications 430—432 Reports, compiled views 23—24 Reports, ReportServer HTML rendering 452—453 ReportServer, CodeBeside page 446 ReportServer, DeviceInfo object 453—460 ReportServer, forms 445 ReportServer, HTML report rendering 452—453 ReportServer, JavaScript validation 444—445 ReportServer, rc namespace 442 ReportServer, Render() method 450—451 ReportServer, rs namespace 440—441 ReportServer, SOAP contacts 447—448 ReportServer, URL contacts 439—446 ReportServer, URL parameters 443—446 ReportServer, validations 444—445 ReportServer, Web application setup 448—453 ReportServer, WSDL (Web Service Description Language) 447—448 Reserved words, schema metadata system 75 Restore class, SMO utility class 330 Restore() object, SQL Server Management Objects (SMOs) 340—341 Restore/backup, SQL Server Management Objects (SMOs) 338—341 Restrictions, schema metadata system 73—75 Result sets, multiple active 276—278 Results output, CLR (Common Language Runtime) Objects 318 Results rankings, Full-Text Search 419—422 Return codes, command execution status reporting 85—87 Routes, Service Broker 370 390—394 Row set loops, CURSOR data type 108 Rows, Oracle insertion 531—533 Rows, TIMESTAMP data type 107 Rowstate() object, DataTables 91
Ðåêëàìà
|
|
Î ïðîåêòå