Hitchhikers Guide to Visual Studio and SQL Server: Best Practice Architectures and Examples, 7th Edition (Microsoft Windows Server System Series)
Index[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z] D&D (drag-and-drop) data binding 2nd DAAB (Data Access Application Block) DACW (DataAdapter Configuration Wizard) dependency on CommandBuilder installing DAO (Data Access Objects) history of performance Data Access Application Block (DAAB) data access architectures ASP browser-based architectures DAAB (Data Access Application Block) data access providers database-agnostic applications deprecated data access controls multi-tiered designs overview of stand-alone (client/server) applications advantages/disadvantages client/server connection management client/server data binding 2nd client/server data entry paradigms client/server data retrieval client/server data validation data storage limits hybrid architectures server-side cursors stored procedures temporary tables XMLWeb Service architectures data access interfaces choosing creating adding parameters to queries configuring TableAdapters selecting Query methods single-table TableAdapters stored procedures data access providers building ConnectionStrings for choosing 2nd need for SNC (SQL Server Native Client) SQLEv (SQL Server Everywhere Edition) implementation overview of programming and maintenance security sharing and replication SQL Server tools SQLEngine Visual Studio support Data Access Objects (DAO) history of performance data access providers building ConnectionStrings for choosing 2nd data binding BindingNavigator control BindingSource class events methods properties typical data binding scenarios complex data binding control properties to custom controls DataBindings collection DataGridView control definition of drag-and-drop (D&D) data binding example of IBindableComponent interface overview of ProgressBar control rules to columns simple data binding to TableAdapter with drag and drop without drag and drop Data Binding with Windows Forms 2.0: Programming Smart Client Data Applications with .NET Data Connections [See connections, client/server connection management.] data restoration [See restoring data, backup and deployment issues.] data retrieval Data Source Configuration Wizard 2nd 3rd consuming and testing Web Services single-table TableAdapters, building TableAdapters adding parameters to queries configuring selecting Query methods stored procedures Data Source XSD designer 2nd 3rd Data Sources [See also TableAdapter objects.] creating 2nd adding parameters to queries configuring TableAdapters selecting Query methods single-table TableAdapters stored procedures definition of importing overview of SqlClient vulnerabilities of Web Services building consuming and testing exposing in the UI data structures, strongly typed [See also TableAdapter objects.] building Web Services consuming and testing Web Services exposing Web Services Data Sources in the UI need for data types ANSI 2nd barbinary bigint binary bit char 2nd CLR UDTs (user-defined types) AddLoan challenges of debugging instantiating UDT variables IsNull property methods Null property NULL values Parse function performance tuning public properties 2nd public structure declaration referencing referencing and updating values SELECT queries SqlUserDefinedTypeAttribute stepping through code templates ToString function typICurrencyV2 UDT user-defined serialization validating data when to use cursor datetime decimal doubleprecision exact numerics float image imprecise numbers int money nchar ntext numeric nvarchar real smalldatetime smallint smallmoney sql_variant 2nd sysname table text timestamp tinyint UDTs (user-defined types) 2nd Unicode 2nd uniqueidentifier varchar 2nd xml data validation DataAccess setting (SqlMethodAttribute property) DataAdapter Configuration Wizard [See DACW (DataAdapter Configuration Wizard), dependency on CommandBuilder.] database connections [See connections, client/server connection management.] Database Diagrams creating definition of Database Snapshots database-agnostic applications databases [See relational databases, administrative functions, Auto Close option.] DataBindings collection DataColumn objects DataError event DataGridView controls DataMember property (BindingSource class) DataMemberChanged event DataRow objects 2nd DataSet controls 2nd [See also populating data structures, DataSet Load method.] Load method overview of 2nd populating typed DataSets 2nd untyped DataSets DataSets block (RDLC files) DataSource property 2nd DataSourceChanged event DataSources property (LocalReport class) DataTable objects DataColumns DataRows joins Load method overview of 2nd populating [See populating data structures, DataSet Load method.] populating DataSets with properties DataTableMappingCollection property (SqlDataAdapter class) DataView class DataWorks team dates data types inqueries datetime data type db_datareader role db_datawriter role db_owner role db_public role DBCC DBMSs (database management systems) client considerations maintenance and administration multi-user issues overview of performance .NET Framework acceptable speed ADO DAO developer performance JET MDAC stack, sharing overview of performance metrics shareable and reusable components shared code SQL Server team development scalability server considerations SQL Server costs SQL Server security transactions-per-second limits DDL triggers debugging CLR executables SQL Server connections stored procedures against local instances with breakpoints from code on remote instances UDTs (user-defined types) decimal data type DECLARE statement Default CommandBehavior (ExecuteReader function) default instances (SQL Server Express Edition) default parameter values DEFAULT values (INSERT statement) DefaultValue property (DataColumn objects) Delaney, Karen Delegate objects Delete Query type (Query Designer) DELETE statements DeleteCommand object DeleteCommand property (SqlDataAdapter class) DELETED pseudo table denying permissions DenyPermissionsOnTo stored procedure dependencies (CLR executables) deployment CLR executables executable dependencies functions profiling deployment process data restoration SQL Server Express Edition deprecated controls reinstalling derived tables design [See application design, application settings.] destroying connection pools Developer Edition (SQL Server) developers keeping skills up to date optimizing performance of diagram pane (Query Designer) diagrams class diagrams Database Diagrams creating definition of dialogs [See specific dialogs.] disabling connection pools DisplayMember property DisplayName property 2nd Dispose method 2nd 3rd 4th Disposed event (connections) distribution database DML triggers documentation MSDN documentation weaknesses of DocumentMapCollapsed property (Report Viewer class) DocumentmapNavigation event DocumentMapWidt property (Report Viewer class) domains doubleprecision data type DoWork event handler drag-and-drop (D&D) data binding 2nd drill-through reports Drillthrough event handler 2nd DSCW [See Data Source Configuration Wizard.] duplicate parameter names duplicating SqlCommand objects DVD contents aliases, creating chapter-specific configuration issues example applications, installing example databases attaching installing dynamic cursors dynamic ports dynamic SQL |
Категории